File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Tomcat and the fly likes Please Help!  I Do Not See the Problem.  Tomcat Connection Configuration Problem! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of JavaScript Promises Essentials this week in the JavaScript forum!
JavaRanch » Java Forums » Products » Tomcat
Bookmark "Please Help!  I Do Not See the Problem.  Tomcat Connection Configuration Problem!" Watch "Please Help!  I Do Not See the Problem.  Tomcat Connection Configuration Problem!" New topic
Author

Please Help! I Do Not See the Problem. Tomcat Connection Configuration Problem!

JiaPei Jen
Ranch Hand

Joined: Nov 19, 2000
Posts: 1309
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 ]
somkiat puisungnoen
Ranch Hand

Joined: Jul 04, 2003
Posts: 1312
I am using the Tomcat 5.0.27, Oracle 10i, j2sdk1.4.2, and Windows XP.


In tomcat 5.0.27 have Web Administrator Section,

you should be config in Administrator Section ...

It's easy and correctly.


SCJA,SCJP,SCWCD,SCBCD,SCEA I
Java Developer, Thailand
JiaPei Jen
Ranch Hand

Joined: Nov 19, 2000
Posts: 1309
Where is the Web Administrator Section? How do I use it? Please help me.
William Brogden
Author and all-around good cowpoke
Rancher

Joined: Mar 22, 2000
Posts: 12821
    
    5
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Please Help! I Do Not See the Problem. Tomcat Connection Configuration Problem!