After scouring the mailing list and a few forums, I'm
still at a dead end attempting to get MySql connection
pooling working with Tomcat. I'm running the following
on Windows 2000:
Tomcat 4.1.18
MySql 4.0.10
JDK 1.4.1
I've tried using both the MySql 3.0.5 and 2.0.14
drivers. I've placed these in [tomcat root]\common\lib
(only one at a time - never both simultaenously). I
know my code and web.xml are pretty solid, because I'm
porting a funtional app from WebSphere 5.0. The
relevant portion of server.xml is:
<Context path="/dsforecast"
docBase="c:\tomcat\webapps\dsforecast" debug="5"
reloadable="true" crossContext="true">
<Resource name="jdbc/raytheon" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/raytheon">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>5</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<parameter>
<name>username</name>
<value>mysql</value>
</parameter>
<parameter>
<name>password</name>
<value>mysql</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql//localhost:3306/dsdemo?autoReconnect=true</value>
</parameter>
</ResourceParams>
</Context>
And the error I'm getting is:
"Cannot create JDBC driver of class
'com.mysql.jdbc.Driver' for connect URL
'jdbc:mysql//localhost:3306/dsdemo?autoReconnect=true'"
It seems that a fair amount of other folk have
encountered this same problem, but I have to stumble
across a solutions. Any help would be appreciated.
Tom
[EMAIL PROTECTED]
=====
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
