[esb-issues] [JBoss JIRA] Updated: (JBESB-1247) DB Listener does not include reconnect logic

DB Listener does not include reconnect logic -------------------------------------------- Key: JBESB-1247 URL: http://jira.jboss.com/jira/browse/JBESB-1247 Project: JBoss ESB Issue Type: Bug Security Level: Public(Everyone can see) Components: Transports Affects Versions: 4.2 Milestone Release 3 Reporter: David Boeren Assigned To: Tom Cunningham Priority: Minor What's happening is that the DB Listener seems to be getting stuck and no longer picking up new database entries. If the appserver is bounced then it resumes normal functioning. There's a big string of these errors in the log: 2007-10-24 00:56:43,882 DEBUG [org.jboss.soa.esb.helpers.persist.JdbcCleanConn] execQueryWait() FAILED COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0108E Communication link failure. SQLSTATE=40003 at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:254) at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:418) at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:396) at COM.ibm.db2.jdbc.net.DB2PreparedStatement.executeQuery(DB2PreparedStatement.java:1068) at org.jboss.soa.esb.helpers.persist.JdbcCleanConn.execQueryWait(JdbcCleanConn.java:138) at org.jboss.soa.esb.listeners.gateway.SqlTableGatewayListener.pollForCandidates(SqlTableGatewayListener.java:447) at org.jboss.soa.esb.listeners.gateway.SqlTableGatewayListener.doRun(SqlTableGatewayListener.java:149) at org.jboss.soa.esb.listeners.lifecycle.AbstractThreadedManagedLifecycle.run(AbstractThreadedManagedLifecycle.java:115) at java.lang.Thread.run(Thread.java:595) 2007-10-24 00:56:43,882 DEBUG [org.jboss.soa.esb.listeners.gateway.SqlTableGatewayListener] Some triggers might not have been returned COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0108E Communication link failure. SQLSTATE=40003 at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:254) at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:418) at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:396) at COM.ibm.db2.jdbc.net.DB2PreparedStatement.executeQuery(DB2PreparedStatement.java:1068) at org.jboss.soa.esb.helpers.persist.JdbcCleanConn.execQueryWait(JdbcCleanConn.java:138) at org.jboss.soa.esb.listeners.gateway.SqlTableGatewayListener.pollForCandidates(SqlTableGatewayListener.java:447) at org.jboss.soa.esb.listeners.gateway.SqlTableGatewayListener.doRun(SqlTableGatewayListener.java:149) at org.jboss.soa.esb.listeners.lifecycle.AbstractThreadedManagedLifecycle.run(AbstractThreadedManagedLifecycle.java:115) at java.lang.Thread.run(Thread.java:595) 2007-10-24 00:56:43,882 DEBUG [org.jboss.soa.esb.listeners.gateway.SqlTableGatewayListener] Returning 0 rows. Looks like the DB connection has gone down, and the code does not contain any reconnect logic so at that point it fails.