1 Reply Latest reply on Oct 2, 2011 6:15 AM by Wolf-Dieter Fink

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

    mahdi asgari nea Newbie

      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