On 18/11/2009 14:57, Neil Aggarwal wrote:
Giocarmine:
It seems that the connection with MySQL it's closed by the
driver due to a
timeout.
Have you set autoReconnect=true in your JDBC url?
jdbc:mysql://localhost:3306/dbName?autoReconnect=true
Opening a single connection, and keeping it open, is not usually a good
strategy. A better solution would be to configure a connection pool.
http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html#Database%20Connection%20Pool%20%28DBCP%29%20Configurations
p
Neil
--
Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net
Host your tomcat app on a CentOS VPS for only $25/month!
Unmetered bandwidth, 7 day no risk trial, Google Checkout
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
