bloritsch    02/01/23 06:57:00

  Modified:    src/java/org/apache/avalon/excalibur/datasource
                        AbstractJdbcConnection.java
  Log:
  apply improvements from Leif Mortenson to only test every 5 seconds
  
  Revision  Changes    Path
  1.9       +9 -4      
jakarta-avalon-excalibur/src/java/org/apache/avalon/excalibur/datasource/AbstractJdbcConnection.java
  
  Index: AbstractJdbcConnection.java
  ===================================================================
  RCS file: 
/home/cvs/jakarta-avalon-excalibur/src/java/org/apache/avalon/excalibur/datasource/AbstractJdbcConnection.java,v
  retrieving revision 1.8
  retrieving revision 1.9
  diff -u -r1.8 -r1.9
  --- AbstractJdbcConnection.java       23 Jan 2002 14:46:21 -0000      1.8
  +++ AbstractJdbcConnection.java       23 Jan 2002 14:57:00 -0000      1.9
  @@ -29,7 +29,7 @@
    * total number of Connection objects that are created.
    *
    * @author <a href="mailto:[EMAIL PROTECTED]">Berin Loritsch</a>
  - * @version CVS $Revision: 1.8 $ $Date: 2002/01/23 14:46:21 $
  + * @version CVS $Revision: 1.9 $ $Date: 2002/01/23 14:57:00 $
    * @since 4.1
    */
   public abstract class AbstractJdbcConnection
  @@ -124,15 +124,20 @@
               return true;
           }
   
  -        if ( System.currentTimeMillis() - m_lastUsed
  -               > 1000*60*60 ) // over an hour?
  +        long age = System.currentTimeMillis() - m_lastUsed;
  +        if ( age > 1000*60*60 ) // over an hour?
           {
               this.dispose();
               return true;
           }
   
  -        if (m_testStatement != null)
  +        if (m_testStatement != null && age > (5*1000)) // over 5 seconds ago
           {
  +            if (getLogger().isDebugEnabled())
  +            {
  +                getLogger().debug("Pinging database after " + age + "ms of 
inactivity.");
  +            }
  +
               try
               {
                   m_testStatement.executeQuery();
  
  
  

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to