receive an exception from ps.executeQuery() after 15 min 30 sec

[sean lee]

MySQL: 5.0.77
Connector J: 5.1.7
java runtime: java 5

I can duplicate this issue:

I have a snipet of the codes.
-----------------------------------------
Connection conn = DbPool.getConn();
PreparedStatement ps = conn.getPreparedStmt("select a, b from X);
ps.executeQuery();
------------------------------------------

1. The connection in the connection pool has been idle for a while.
2. This connection is used for conn.getPreparedStatement().
3. Execute this stmt: ps.executeQuery();
4. This call never returns and throws an exception AFTER 15 min 30 sec.

Communications link failure
Last packet sent to the server was 8140031 ms ago

Everything looks ok ... wait_timeout for mysql and reset connection time for the pool are
ok ... It just happens when the connections have been idle ...

MySQL: 5.0.77
Connector J: 5.1.7
java runtime: java 5

I can duplicate this issue:

I have a snipet of the codes.
-----------------------------------------
Connection conn = DbPool.getConn();
PreparedStatement ps = conn.getPreparedStmt("select a, b from X);
ps.executeQuery();
------------------------------------------

1. The connection in the connection pool has been idle for a while.
2. This connection is used for conn.getPreparedStatement().
3. Execute this stmt: ps.executeQuery();
4. This call never returns and throws an exception AFTER 15 min 30 sec.

Communications link failure
Last packet sent to the server was 8140031 ms ago

Do you have any idea about this issue?

Thanks!



Edited 1 time(s). Last edit at 03/07/2009 01:35PM by sean lee.