Originally posted by Mike Curwen:
Yes, you're creating a single connection object every time you call getConnection() so this is not a very good Pool. Not to mention the InitialContext.
Is there any reason you're not using DBCP that comes with Tomcat?
http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html
Originally posted by Jeanne Boyarsky:
Aditya,
You may want to store the data in a 1D arraylist of value objects (getters and setters for each field), so the data makes sense. It will also be easier to track down problems and maintain.
Originally posted by David O'Meara:
You're writing an 's_resbean', which is a beans.SearchBean then you are trying to read it back as a ResultSet.
Can I say I hat ethe idea of passing database resources around in web-applications. You should have a level below which database operations exist, and not allow knowledge about the database to leak above this layer. Therefore you'd be better off convertind from database fields to custom Java objects as quickly as possible and forget about passing database objects around.
Dave
Originally posted by Amit More:
Hi Aditya,
Can you provide the code for forwarding your request from servlet to jsp.
Because it does matter.
Are u using RequestDispatcher object or something different?
Let me know.