Re: jdbc "Communications link failure" / Logging myql
Posted by: Todd Farmer
Date: May 07, 2013 11:38AM

Hi Stefan,

You might find the following blog post useful:

http://mysqlblog.fivefarmers.com/2010/09/06/debugging-communication-link-failure-exceptions-in-connectorj/

It looks as though the socket is being shut down (likely being killed as inactive at the OS or firewall level). Networks can be problematic, even when connections are not left idle for extensive periods of time (2h qualifies). You can try to track this down at the network level, but it's far better to ensure your application (or more appropriately, connection pool library) is doing periodic maintenance on unused Connections to ensure they remain viable.

Hope that helps,

--
Todd Farmer
MySQL @ Oracle
http://www.oracle.com/mysql/

Options: ReplyQuote


Subject
Written By
Posted
Re: jdbc "Communications link failure" / Logging myql
May 07, 2013 11:38AM


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.