Matt,
This is how I got mine working...
In Server.xml within <Context></Context>
<Resource name="TigardDB" scope="Shareable" type="javax.sql.DataSource"/>
<ResourceParams name="TigardDB">
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/tigardDB?autoReconnect=true</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>username</name>
<value>my_username</value>
</parameter>
<parameter>
<name>password</name>
<value>my_password</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
</ResourceParams>
Now in your java code do something like this:
InitialContext ctx = new InitialContext();
if(ctx == null )
throw new Exception("Boom - No Context");
Context envCtx = (Context) ctx.lookup("java:/comp/env/");
DataSource ds = (DataSource) envCtx.lookup("/TigardDB");
Connection oconn = ds.getConnection();
if(oconn != null) {
Statement stmt = oconn.createStatement();
String sql = "SELECT * FROM sometable";
ResultSet rst = stmt.executeQuery(sql);
if (rst.next()) {
out.println(rst.getString(1) +"<BR>");
}
rst.close();
oconn.close();
}
I am using the 2.0.14 mysql driver.
good luck!
- Victor Soares
>>> [EMAIL PROTECTED] 02/13/03 01:36PM >>>
<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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
