Re: loosing connection after period of inactivity? java.sql.SQLException: Communication link failure: java.io.EOFException
Posted by: Mark Matthews
Date: November 03, 2004 03:41PM

Maybe section 5.4 here has your answer?

http://dev.mysql.com/doc/connector/j/en/index.html#id2488240

(when all else fails, read the docs ;) )

Since Struts now uses DBCP, I'd also take a look at setting the idle check time way lower than max_timeout on MySQL (maybe even few 10's of minutes or so, it takes no time to connect to MySQL), as well as 'minEvictableIdleTimeMillis' to something _really_ low (like a few minutes), and also enable 'testWhileIdle', with a 'validationQuery' of 'SELECT 1' (see http://jakarta.apache.org/commons/dbcp/configuration.html for more details).

-Mark

Options: ReplyQuote


Subject
Written By
Posted
Re: loosing connection after period of inactivity? java.sql.SQLException: Communication link failure: java.io.EOFException
November 03, 2004 03:41PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.