If you're looking for a manual way to restart it, you could stop and start the listener in JMX.
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.
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.
If that's a feature request that you're interested in, definitely raise it in JIRA - and reference this thread in the bug.