Mailing-List: contact dev-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Developers List" <dev@tomcat.apache.org>
From: bugzilla@apache.org
To: dev@tomcat.apache.org
Subject: [Bug 53254] Support for purging connection pool
Date: Fri, 18 May 2012 19:18:05 +0000
Message-ID: <bug-53254-78-h0R6xjkFy1@https.issues.apache.org/bugzilla/>
In-Reply-To: <bug-53254-78@https.issues.apache.org/bugzilla/>
References: <bug-53254-78@https.issues.apache.org/bugzilla/>
Content-Type: multipart/alternative; boundary="1337368687.AD8F1.95544";
 charset="us-ascii"
Auto-Submitted: auto-generated
MIME-Version: 1.0

--1337368687.AD8F1.95544
Date: Fri, 18 May 2012 19:18:07 +0000
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"

https://issues.apache.org/bugzilla/show_bug.cgi?id=53254

--- Comment #2 from Mike Youngstrom <youngm@gmail.com> ---
Nice!  Thanks Filip!

For laughs here is the workaround implementation I created yesterday. :)

public void purge() throws Exception {
        long oldMaxAge = dataSource.getMaxAge();
        int oldMaxIdle = dataSource.getMaxIdle();
        int oldMaxActive = dataSource.getMaxActive();
        int oldMinEvictTime = dataSource.getMinEvictableIdleTimeMillis();
        PooledConnection connection = dataSource.getPooledConnection();
        IllegalStateException error = null;
        try {
            dataSource.setMaxActive(1);
            dataSource.setMaxIdle(1);
            dataSource.setMaxAge(1);
            dataSource.setMinEvictableIdleTimeMillis(1);
            int sec = 0;
            Thread.sleep(1001);
            while(dataSource.getActive() > 1 && sec < 29) {
                Thread.sleep(1000);
                sec++;
            }
            dataSource.checkIdle();
            if(dataSource.getActive() > 1) {
                error = new IllegalStateException("Closed all but
"+(dataSource.getActive()-1)+" connection(s) after 30 sec.  Try again.");
            }
            connection.close();
        } finally {
            dataSource.setMaxAge(oldMaxAge);
            dataSource.setMaxActive(oldMaxActive);
            dataSource.setMaxIdle(oldMaxIdle);
            dataSource.setMinEvictableIdleTimeMillis(oldMinEvictTime);
            if(error != null) {
                throw error;
            }
        }
    }

-- 
You are receiving this mail because:
You are the assignee for the bug.

--1337368687.AD8F1.95544--