Hi dear all
I have a problem with datasource,
I found, sometimes my postgres database failed to process request and send the following exception
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
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)