[esb-issues] [JBoss JIRA] Created: (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)
Affects Versions: 4.2 Milestone Release 3
Reporter: David Boeren
Assigned To: Mark Little
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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira