<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
> -----Original Message-----
> From: Tom O'Neil [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 13, 2003 2:25 PM
> To: [EMAIL PROTECTED]
> Subject: MySql connection pool difficulties
>
>
> 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]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
