Kawthar,
Change:
<Resource auth="Container" description="JDBC Connection to
MySQL v4.0.18" name="mySQLDatabase" scope="Shareable"
type="javax.sql.DataSource"/>
<Resource name="jdbc/mySQLDatabase" auth="Container"
type="javax.sql.DataSource"/>
To:
<Resource auth="Container" description="JDBC Connection to
MySQL v4.0.18" name="jdbc/mySQLDatabase" scope="Shareable"
type="javax.sql.DataSource"/>
Should work either way, mine did, just cleaner and proper.
Note name is changed in second entry, added jdbc/ .
Doug
----- Original Message -----
From: "Parsons Technical Services" <[EMAIL PROTECTED]>
To: "Tomcat Users List" <[EMAIL PROTECTED]>
Sent: Wednesday, March 17, 2004 11:02 PM
Subject: Re: JDBC/mySQL problem.
> Kawthar,
>
> Try this context in place of yours.
>
> <Context path="/db" docBase ="ROOT" debug="9" reloadable="true">
> <Resource auth="Container" description="JDBC Connection to
> MySQL v4.0.18" name="mySQLDatabase" scope="Shareable"
> type="javax.sql.DataSource"/>
>
> <Resource name="jdbc/mySQLDatabase" auth="Container"
> type="javax.sql.DataSource"/>
>
> <ResourceParams name="jdbc/mySQLDatabase">
> <parameter>
> <name>factory</name>
>
> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
> </parameter>
> <parameter>
> <name>username</name>
> <value>xxxx</value>
> </parameter>
> <parameter>
> <name>password</name>
> <value>xxxx</value>
> </parameter>
> <parameter>
> <name>maxActive</name>
> <value>100</value>
> </parameter>
> <parameter>
> <name>maxIdle</name>
> <value>5</value>
> </parameter>
> <parameter>
> <name>maxWait</name>
> <value>10000</value>
> </parameter>
>
> <parameter>
> <name>driverClassName</name>
> <value>org.gjt.mm.mysql.Driver</value>
> </parameter>
> <parameter>
> <name>url</name>
> <value>jdbc:mysql://localhost:3306/ecpa?autoReconnect=true</value>
> </parameter>
> </ResourceParams>
>
> <Logger className="org.apache.catalina.logger.FileLogger"
> prefix="DBlog." suffix=".txt"
> timestamp="true"/>
> </Context>
>
> Don't forget to close the statement and the result set.
> I do mine in a finally block along with the conn.close() and each one is
> wrapped in a try / catch.
>
> Make sure to restart Tomcat after you make changes to the server.xml.
>
> Doug
>
>
>
> ---------------------------------------------------------------------
> 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]
