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