tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Raible, Matt" <Matt_Rai...@cable.comcast.com>
Subject RE: MySql connection pool difficulties
Date Thu, 13 Feb 2003 21:36:51 GMT
        <parameter>
            <name>driverClassName</name>
            <value>org.gjt.mm.mysql.Driver</value>
        </parameter>

> -----Original Message-----
> From: Tom O'Neil [mailto:tomoneil@documental-solutions.com]
> Sent: Thursday, February 13, 2003 2:25 PM
> To: tomcat-user@jakarta.apache.org
> 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
> tomoneil@documental-solutions.com
> 
> =====
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message