I am using MYSQL 5.0 and Tomcat 5.5. After 8 hours , MYSQL closes by default all idle connections and so I am getting an SQL Exception .Any solution to this problem
Which connection pool are you using? Most allow a heartbeat command to be executed periodically to keep connections from idling out.
EDIT: Looking at the DBCP configuration page, I think you should set an appropriate (cheap) validationQuery
. You could then either tell DBCP to test this when potentially evicting idle connections (testWhileIdle
) or tell it to test just before returning the connection (testOnBorrow
). The first would (hopefully!) keep your idle connections alive; the second wouldn’t, but wouldn’t return you broken connections (i.e. if would create a new one if necessary).