[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - mysql connection reset

[tomerbd2]

I'm using cmp2.1 + jdbc and i get from time to time (daily) a connection reset exception.
im using mysql: 5.0.26 and i made sure that the wait_timeout parameter of mysql is longer than the connection idle timeout of jboss connection pool.

Can anyone advise please?

anonymous wrote : 
  | Exception: Communication link failure: java.net.SocketException, underlying cause: Connection reset
  | 
  | ** BEGIN NESTED EXCEPTION ** 
  | 
  | java.net.SocketException
  | MESSAGE: Connection reset
  | 
  | STACKTRACE:
  | 
  | java.net.SocketException: Connection reset
  |         at java.net.SocketInputStream.read(SocketInputStream.java:168)
  |         at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)
  |         at java.io.BufferedInputStream.read1(BufferedInputStream.java:256)
  |         at java.io.BufferedInputStream.read(BufferedInputStream.java:313)
  |         at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1316)
  |         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:2037)
  |         at com.mysql.jdbc.Statement.execute(Statement.java:900)
  |         at org.jboss.resource.adapter.jdbc.WrappedStatement.execute(Unknown Source)
  | 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4096586#4096586

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4096586