Re: Mysql JDBC Drivers: Use 2.x or 3.x? (Kinda Long, sry)

[Chuck Carson]

When I move my datasource definition to the web.xml file for my webapp, I get nothing. 
When I use
the Tomcat manager app and drill down into Service->Host->Context
(testapp1)->Resource->DataSources I see my jdbc/MysqlTest1 datasource defined but all 
the
parameters associated with it are blank.

Here is my webapps/testapp1/WEB-INF/web.xml file:

<?xml version="1.0" encoding="ISO-8859-1"?>

<web-app>
  <description>Test App 1</description>

  <resource-ref>
        <description>DB Connection</description>
        <res-ref-name>jdbc/MysqlTest1</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
  </resource-ref>

  <Resource name="jdbc/MysqlTest1" scope="Shareable" type="javax.sql.DataSource"/>
  <ResourceParams name="jdbc/MysqlTest1">
        <parameter>
                <name>url</name>
               
<value>jdbc:mysql://localhost:3306/tomcat-test1?autoReconnect=true,maxReconnects=3</value>
 
        </parameter>
        <parameter>
                <name>username</name>
                <value>xxxxxx</value>
        </parameter>
        <parameter>
                <name>password</name>
                <value>xxxxxx</value>
        </parameter>
        <parameter>
                <name>maxActive</name>
                <value>100</value>
        </parameter>
        <parameter>
                <name>maxWait</name>
                <value>15000</value>
        </parameter>
        <parameter>
                <name>validationQuery</name>
                <value>SELECT version()</value>
        </parameter>
        <parameter>
                <name>testOnBorrow</name>
                <value>true</value>
        </parameter>
        <parameter>
                <name>driverClassName</name>
                <value>com.mysql.jdbc.Driver</value>
        </parameter>
        <parameter>
                <name>maxIdle</name>
                <value>100</value>
        </parameter>
        <parameter>
                <name>removeAbandoned</name>
                <value>true</value>
        </parameter>
        <parameter>
                <name>removeAbandonedTimeout</name>
                <value>60</value>
        </parameter>
        <parameter>
                <name>logAbandoned</name>
                <value>true</value>
        </parameter>
</ResourceParams>
</web-app>

I'm sure this is something simple I am missing but the docs are not leading me in the 
right
direction.

Thanks for any help,
CC
--- Robert Bateman <[EMAIL PROTECTED]> wrote:

> Chuck,
> 
> I think you need to move your connection pooling over to your context.xml at 
> the web application level.  Here is my pool definition from one of my apps:
> 
<snip>
> 
> it may not be perfect, but it works on our end.
> 
> 
> Hope that helps!
> 
> Bob
> 
> ---------------------------------------------------------------------
> 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]