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

[Ryuji Hattori<hattori@xxxxxxxxxxxxxxxxxx>]

Hello. 

Sometimes I find the same type exception using Enhydra 5.1-7 and 
MySQL 4.0.17 in My Application too. But in my case, an exception
arize at connection allocation.  My Application's enviroment
is listed below  
    
 OS      : Redhat Linux 9.0 
 RDBMS   : MySQL 4.0.17 (safe mode) 
 JDBC    : mysql-connecter-java-3.0.10 stable
 Enhydra : 5.1-7        

and exception stack trace is followed.

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

** BEGIN NESTED EXCEPTION ** 

java.io.EOFException

STACKTRACE:

java.io.EOFException
        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1319)
        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1463)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1854)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1109)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1203)
        at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1164)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2087)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2049)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2030)
        at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:522)
        at 
com.lutris.appserver.server.sql.standard.StandardDBConnection.reset(Unknown 
Source)
        at 
com.lutris.appserver.server.sql.standard.StandardDBConnection.allocate(Unknown
 Source)
        at 
com.lutris.appserver.server.sql.standard.StandardConnectionAllocator.allocate(Unknown
 Source)
        at 
com.lutris.appserver.server.sql.standard.StandardLogicalDatabase.allocateConnection(Unknown
 Source)
        at 
com.lutris.appserver.server.sql.StandardDatabaseManager.allocateConnection(Unknown
 Source)


In message "[enhydra] DODS MySQL JDBC driver readFully/reuseAndReadPacket 
EOFExceptions"
    on 04/05/18, Petr Stehlik <pstehlik@xxxxxxxxxx> writes:
> 
> 
> Using Enhydra 5.1-9, very latest JDBC driver for MySQL 3.23.49 (Debian
> stable) and getting the following error randonly:
> 
> 2004-05-18 09:55:39,460: [Thread-15], ERROR: Data Object     Error:
> Communications link failure due to underlying exception: 
> 
> ** BEGIN NESTED EXCEPTION ** 
> 
> java.io.EOFException
> 
> STACKTRACE:
> 
> java.io.EOFException
>         at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1619)
>         at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1828)
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2179)
>         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1412)
>         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1494)
>         at com.mysql.jdbc.Connection.execSQL(Connection.java:1909)
>         at com.mysql.jdbc.Connection.execSQL(Connection.java:1847)
>         at
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1711)
>         at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1559)
>         at
> com.lutris.dods.builder.generator.query.QueryBuilder.executeQuery(Unknown 
> Source)
> 
> Any idea how to fix this? I have autoReconnect=true in the
> Connection.Url (as weel as autoReconnectForPools=true).
> 
> Petr
> 
> 
> 
> 
> ------------=_1084916064-15735-312
> Content-Type: text/plain; name="message.footer"
> Content-Disposition: inline; filename="message.footer"
> Content-Transfer-Encoding: 8bit
> 
> 
> --
> You receive this message as a subscriber of the enhydra@xxxxxxxxxxxxx 
> mailing list.
> To unsubscribe: mailto:enhydra-unsubscribe@xxxxxxxxxxxxx
> For general help: mailto:sympa@xxxxxxxxxxxxx?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
> 
> ------------=_1084916064-15735-312--