Hi, I am in trouble. Your help would be greatly appreciated.
I tried to retrieve some data from the Oracle to test if my connection pool configuration is done correctly. I got 'Null Pointer Exception' thrown on this statement:
The query string is defined; therefore, query is not null. Apparently, the 'conn' object is a null. I have been using a DBConnection.java class to get a 'conn' object from the connection pool for quite some time which using the MySQL. Therefore, my configuration for using the Oracle is most likely wrong.
I am using the Tomcat 5.0.27, Oracle 10i, j2sdk1.4.2, and Windows XP. Here is my configuration:
Jakarta-Commons DBCP 1.2.1 Jakarta-Commons Collections 2.1.1 Jakarta-Commons Pool 1.2
These jar files are installed in $CATALINA_HOME/common/lib directory
placed the classes12.jar in the $CATALINA_HOME/common/lib directory
Documentation for the Web Administrator and Manager applications was installed as part of your normal Tomcat installation. If you can see the normal Tomcat startup page - look on the left side for Tomcat Documentation. Bill