13 messages in com.mysql.lists.javaRe: EOFException with latest jdbc driver
FromSent OnAttachments
Darrell Esau22 Nov 2004 10:34 
Mark Matthews22 Nov 2004 10:42 
Darrell Esau22 Nov 2004 10:57 
Peter Romianowski07 Jan 2005 05:21 
Mark Matthews07 Jan 2005 06:53 
Peter Romianowski07 Jan 2005 08:21 
Peter Romianowski07 Jan 2005 11:30 
Peter Romianowski10 Jan 2005 03:50 
Mark Matthews10 Jan 2005 06:27 
Peter Romianowski10 Jan 2005 06:58 
Mark Matthews10 Jan 2005 07:19 
Peter Romianowski11 Jan 2005 08:43 
Peter Romianowski04 Feb 2005 05:00 
Subject:Re: EOFException with latest jdbc driver
From:Mark Matthews (ma@mysql.com)
Date:11/22/2004 10:42:42 AM
List:com.mysql.lists.java

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

Darrell Esau wrote:

Hello all,

I recently upgraded my JDBC driver to mysql-connector-java-3.0.16-ga-bin.jar (from version 3.0.9 I believe).

Since the upgrade, I'm getting a sporadic problem. It seems that about 1 in 5 calls fails, yielding the following stack trace.

Here is the code that I use to get a Connection object: Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://" + dbHost + ":" + dbPort + "/" + database + "?autoReconnect=true"; con = DriverManager.getConnection(url, dbUser, dbPassword);

Below is the stack trace:

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:1394) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1538) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1929) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1224) at com.mysql.jdbc.Connection.execSQL(Connection.java:2248) at com.mysql.jdbc.Connection.execSQL(Connection.java:2196) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1163)

Darrell,

What version of MySQL are you using? Are these connections coming from a pool? Are these 'fresh' connections or have they been idle for some amount of time?

-Mark

- -- Mark Matthews MySQL AB, Software Development Manager - Client Connectivity Office: +1 708 332 0507 www.mysql.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFBojM3tvXNTca6JD8RAtgnAJ9iwWCv92tMJkN0nhMTrHZ2a36QdwCgrCuH Il7OHFl7fnjlLGwoAylOFpU= =fONt -----END PGP SIGNATURE-----