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]