i have an terrible terrible problem with my application, after hosting this application it stops to work after 8-10hrs of idle state. then the server has to restart and then its fine again.
i learnt that the mysql driver disconects after 8hrs of an idle connection so i addred autoreconnect=true to the connection url. however the problem doesnt seem to get sovled. just extended fro another another and then the same problem again.
i need to know how to remove org.apache.struts.legacy.GenericDataSource and use the connection from DBCP (commons lib ie.) and will i need to change the settings in the code (struts-config.xml) i also am thinking of refactoring the entire codebase usng iBatis. will it solve this issue?
pls help! i need this project to be up and running in the next week. thanks once again the logs follows.
NFO: Return allocated connection, activeCount=2, useCount=1
Nov 28, 2003 8:00:15 PM com.hedging.HedgeUser validUser
INFO: --> Error: Communication link failure: java.io.IOException<--
Nov 28, 2003 8:00:15 PM org.apache.struts.legacy.GenericDataSource returnConnection
INFO: releaseConnection(), activeCount=2, useCount=0
Nov 28, 2003 8:00:30 PM org.apache.jk.common.ChannelSocket processConnection
INFO: connection timeout reached
Nov 28, 2003 8:00:33 PM org.apache.jk.common.ChannelSocket processConnection
INFO: connection timeout reached
Nov 28, 2003 8:00:35 PM org.apache.jk.common.ChannelSocket processConnection
INFO: connection timeout reached
Nov 28, 2003 8:00:36 PM org.apache.jk.common.ChannelSocket processConnection
INFO: connection timeout reached
Nov 29, 2003 12:33:42 AM org.apache.jk.common.ChannelSocket processConnection
INFO: connection timeout reached
Nov 29, 2003 12:33:47 AM org.apache.jk.common.ChannelSocket processConnection
INFO: connection timeout reached
Nov 29, 2003 12:33:58 AM org.apache.struts.legacy.GenericDataSource getConnection
INFO: getConnection()
Nov 29, 2003 12:33:58 AM org.apache.struts.legacy.GenericDataSource getConnection
INFO: Check for timeout, activeCount=2, useCount=0
Nov 29, 2003 12:33:58 AM org.apache.struts.legacy.GenericDataSource getConnection
INFO: Found available connection
Nov 29, 2003 12:33:58 AM org.apache.struts.legacy.GenericDataSource getConnection
INFO: Return allocated connection, activeCount=2, useCount=1
Nov 29, 2003 12:33:58 AM com.hedging.HedgeUser validUser
INFO: --> Error: No operations allowed after connection closed<--
Nov 29, 2003 12:33:58 AM org.apache.struts.legacy.GenericDataSource returnConnection
INFO: releaseConnection(), activeCount=2, useCount=0
Nov 29, 2003 12:34:18 AM org.apache.jk.common.ChannelSocket processConnection
--
Rajat Pandit | [EMAIL PROTECTED] +91 612 3117606 [ Developer and Part Time Human Being]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
