Re: Communication link failure java.io.EOFException
We were experiancing this problem with our webapp using Spring/Hibernate/MySql, however after reading these posts
http://forums.mysql.com/read.php?39,16257,162417#msg-162417
http://forums.mysql.com/read.php?39,55450,122573
We replaced the apache BasicDataSource and used the C3P0 pooling library which appears to have fixed the problem.
Our issue was due to connections in MySql defaulting to being open for 8 hours after which MySql drops the connection. The apache BasicDataSource didn`t handle this very well resulting in the communications link failure. With C3P0 you have a a load of configuration options to close connections after a certain amount of time and also to test a connction after a certain amount of time. If the test fails the connection is dropped transparently by C3P0.
Lots of people have issues with the Communications link error so I think it should be part of the FAQ.
Subject
Written By
Posted
Re: Communication link failure java.io.EOFException
November 01, 2007 03:22AM
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.