1 Reply Latest reply on Sep 8, 2004 5:26 PM by jae77

    database connection pool

    vspv62

      Hi,

      Do you know how I can monitor database connections in a database pool.. ? I am using Jboss container.

      The purpose is to monitor connections that are closed and refresh them.

      There a firewall.. across which my application makes connections to the database.. the firewall times out due to the inactivity. and my application dies.

      I was thinking may be I could check for the database connections in a pool and then one that is not being used for a long time .. close it and again refresh the connection.

      Please Advise...

        • 1. 3847584
          jae77

          you can add an entry to the datasource that will check the validity of a sql connection when it is pulled from the pool (use a simple, low overhead sql select).

          
          <check-valid-connection-sql>SELECT ...</check-valid-connection-sql>