File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Tomcat and the fly likes Connectionpooling in tomcat 5.5 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Make it so: Java DB Connections & Transactions this week in the JDBC forum!
JavaRanch » Java Forums » Products » Tomcat
Bookmark "Connectionpooling in tomcat 5.5 " Watch "Connectionpooling in tomcat 5.5 " New topic

Connectionpooling in tomcat 5.5

nagendraveera pilla

Joined: May 28, 2007
Posts: 1
plese give me solution to this problem. since last two days i did't get any solution about this issue. I searched all forums .But no use, I did't get any solution this problem

I have problem with tomcat 5.5 connection pooling concepts, It give errors like this
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource.
I put mysql connector jar file in my tomcat commom/lib dirctory .But it stil l give error like this.

I think problem is only in my server.xml file .But i configured correctly .it is my server. xml file

<Context path="/soap" docBase="C:\web_services\soap-2_2\webapps\soap"
debug="1" reloadable="true">

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

<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_DBTest_log." suffix=".txt"

<Resource name="jdbc/TestDB"

<ResourceParams name="jdbc/TestDB">

<!-- Maximum number of dB connections in pool. Make sure you
configure your mysqld max_connections large enough to handle
all of your db connections. Set to 0 for no limit.

<!-- Maximum number of idle dB connections to retain in pool.
Set to 0 for no limit.

<!-- Maximum time to wait for a dB connection to become available
in ms, in this example 10 seconds. An Exception is thrown if
this timeout is exceeded. Set to -1 to wait indefinitely.

<!-- MySQL dB username and password for dB connections -->

<!-- Class name for mm.mysql JDBC driver -->

<!-- The JDBC connection url for connecting to your MySQL dB.
The autoReconnect=true argument to the url makes sure that the
mm.mysql JDBC Driver will automatically reconnect if mysqld closed the
connection. mysqld by default closes idle connections after 8 hours.

please give me a solution to this one. It make me a great help.

I agree. Here's the link:
subject: Connectionpooling in tomcat 5.5
It's not a secret anymore!