Re: [enhydra] DODS MySQL JDBC driver readFully/reuseAndReadPacket EOFExceptions

[Petr Stehlik <pstehlik@xxxxxxxxxx>]

V Čt, 20. 05. 2004 v 03:28, Ryuji Hattori píše:
> Sometimes I find the same type exception using Enhydra 5.1-7

we've been suffering this in Enhydra 5.1-7 as well so I tried to upgrade
to latest (since I saw some DODS fixes) but it didn't help.

> But in my case, an exception arize at connection allocation.

I believe we have the same problem. The symptoms are that sometime when
new user tries to enter the web site they get the exception. But if they
reload immediately the web app runs just fine. So it seems like
connection allocation problem.

I were also thinking if this could be caused by the MySQL closing unused
connections after 8 hours (that's what I heard somewhere) but the
"autoReconnect" and/or "autoReconnectForPools" should solve this issue.

> 2004-04-26 10:57:45,816: [Thread-3], ERROR, Wavebaby: RID:17510: Unhandled 
> Application error in Wavebaby
> java.sql.SQLException: Communication link failure: java.io.EOFException, 
> underlying cause: null

Yes, that's exactly the same case.

What can we do in order to fix it? This is a serious problem and since
it's so random it's hard to catch and debug it.

Petr