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]
