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:
Step 1.
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
Step 2.
placed the classes12.jar in the $CATALINA_HOME/common/lib directory
Step 3. C:\jakarta-tomcat-5.0.27\conf\server.xml configuration
Note: I added the following code in the <Host> element just before the closing </Host> tag.
Step 4. web.xml Configuration (the one in MyApp/WEB-INF directory)
add these lines after the <taglib> element
and my DBConnection.java class looks like:
[ September 14, 2004: Message edited by: Mike Curwen ]