Jboss AS 5.1.0 must be restart after database connection fail!!

[mahdiiran]

Hi dear all

I have a problem with datasource,

I found, sometimes my postgres database failed to process request and send the following exception

• org.postgresql.util.PSQLException: FATAL: the database system is in recovery mode

After it, all next queries failed, however postgres stand on after a few second and ready to execute next query, but jboss

Fail to get another connection and throw the following exception

org.postgresql.util.PSQLException: This connection has been closed.

the only way i found to solve this, restart jboss, but is it any configuration to make jboss keep connections alive, or re-open database connection, or re build connection pools?

Thanks in advance

[wdfink]

Hi,

you should set the <check-valid-connection-sql> in your ds-xml file to check the connection before handed out of the pool.

See http://community.jboss.org/wiki/configdatasources for details.

Also a reset of the connection pool of your datasource should help (JCA sections within the JMX-console)