tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Caroline Jen <>
Subject Re: Tomcat Connection Pool Configuration Problem (Cannot Establish the Connection)
Date Wed, 15 Sep 2004 02:51:35 GMT
I have been struggling with this problem for more than
a week. I did follow the JDBC datasource howto.  And I
posted all the steps that I have taken to configure
the Tomcat 5.0.27 connection pool.  Nobody has really
helped to look into the problem.  Tomcat 5.0.27,
j2sdk1.4.2, Oracle 10i, Windows XP

I will post all my configuration steps again below the
error message.  The Tomcat logs file shows:

root cause 

SQLException: Cannot create JDBC driver of class ''
for connect URL 'null'



The configuration steps that I have taken are listed

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 

Step 2.
download rename it to classes12.jar and
place it in 

Step 3. C:\jakarta-tomcat-5.0.27\conf\server.xml
I did put the driver and URL in the
C:\jakarta-tomcat-5.0.27\conf\server.xml file (The
code shown below is inserted between
the         <Logger
directory="logs"  prefix="localhost_log."
suffix=".txt" timestamp="true"/> and the
closing </Host> tag).  

<Context path="/DBTest" docBase="DBTest"
        debug="5" reloadable="true"

   <Resource name="jdbc/OracleDB" auth="Container"

   <ResourceParams name="jdbc/OracleDB">

Step 4. web.xml Configuration (the one in
MyApp/WEB-INF directory)

add these lines after the <taglib> element

 <description>Oracle Datasource</description>

--- Peng Tuck Kwok <> wrote:

> On Tue, 14 Sep 2004 13:56:48 -0700 (PDT), Caroline
> Jen
> <> wrote:
> > When I configured the Tomcat 5.0.27, I did put the
> > driver and URL in the
> > C:\jakarta-tomcat-5.0.27\conf\server.xml file (The
> That's great, but did you actually put the driver in
> a location that
> tomcat could find it  ?
> Like here: $CATALINA_HOME/common/lib ?  Dump your
> driver there (make
> sure it's a jar file),
> restart tomcat. Check out the jdbc datasource howto
> if you've missed
> anything else.
> To unsubscribe, e-mail:
> For additional commands, e-mail:

Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message