Jboss can't connect after DB has restarted

[mroosendaal]

Hi,

During a failover test we saw that JBoss can't handle a restart of the DB correctly. We expected that JBoss would have some mechanisme to check to DS first and then throw an Exception. So when the DB is restarted after a few minutes, JBoss can reconnect to it.

Is there something in JBoss that we can configure or do we need to do something with de postgres-ds.xml (check-valid-connection).

Hope someone can help.

Thanks,
Maarten

[jukvaa]

Yes, you'll need to put some inexpensive select to check valid connection. Somehting like this will do it for PostgreSQL:


<check-valid-connection-sql>select 1</check-valid-connection-sql>

[anders.hedstrom]

http://wiki.jboss.org/wiki/Wiki.jsp?page=FAQJBossJCA