Mailing-List: contact commons-dev-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Jakarta Commons Developers List" <commons-dev@jakarta.apache.org>
Date: 20 Sep 2002 17:51:55 -0000
Message-ID: <20020920175155.4187.qmail@nagoya.betaversion.org>
From: bugzilla@apache.org
To: commons-dev@jakarta.apache.org
Cc: 
Subject: DO NOT REPLY [Bug 12869] New:  -
    Abandoned Connections are never closed

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=12869>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=12869

Abandoned Connections are never closed

           Summary: Abandoned Connections are never closed
           Product: Commons
           Version: 1.0 Final
          Platform: Other
        OS/Version: Other
            Status: NEW
          Severity: Major
          Priority: Other
         Component: Dbcp
        AssignedTo: commons-dev@jakarta.apache.org
        ReportedBy: richard_atkinson@hotmail.com


Abandoned Connections are never closed even when all the correct properties 
have been set and there are the requisite number of active and idle 
Connections.  This appears to be because lastUsed property is not updated on 
the PoolableConnection.  When the removedAbandoned() is called on the 
AbandonedObjectPool it ignores all the abandoned connections because they have 
lastUsed times of 0.

Modifying the activate() method on DelegatingConnection to update the lastUsed 
time corrects the problem for me.  I'm not sure if that is the best way of 
fixing it.

    protected void activate() {
        _closed = false;
+       this.setLastUsed();
        if(_conn instanceof DelegatingConnection) {
            ((DelegatingConnection)_conn).activate();
        }
    }

Since Tomcat 4.1 went stable I expect lots of people are going to be hitting 
this problem soon.

--
To unsubscribe, e-mail:   <mailto:commons-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:commons-dev-help@jakarta.apache.org>