[esb-issues] [JBoss JIRA] Resolved: (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 Fix For: 4.2.1 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.