SqlTableGatewayListener does not recover from DB failure

[bblasko]

I have a simple ESB where I use SqlTableGatewayListener to listen for data.  If the DB goes down when listening, the gateway will attempt to reconnect but after the max number of retries of 5(hard coded in JdbcCleanConn.connection, it returns a null connection. 

This then causes a NPE in pollForCandidates which in turns causes the thread to exit.

Then when the DB comes back up, the listener will not restart.

Is there a way to get the listener to recover from this?

[tcunning]

If you're looking for a manual way to restart it, you could stop and start the listener in JMX.     

http://docs.jboss.org/jbossesb/docs/4.10/manuals/html/Administration_Guide/index.html#monit_and_manage_console

If you're looking for a programmatic way to restart it, you could locate the MBean and stop and start it programmatically, or you could just write your own CustomSqlTableGatewayListener - using SqlTableGatewayListener as a starting point and give it some custom recovery options.

[bblasko]

I was hoping there was a configuration option that would have the ESB handle this correctly and restart the listener.  If not, I will raise this as a issue in JIRA.

Thanks for the tips.

[tcunning]

If that's a feature request that you're interested in, definitely raise it in JIRA - and reference this thread in the bug.