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>
Subject: Re: DBCP validation query: how to use?
From: Bryan Field-Elliot <bryan_lists@netmeme.org>
To: Jakarta Commons Developers List <commons-dev@jakarta.apache.org>
In-Reply-To: <006b01c20fbf$a7f1d850$0111010a@user>
References: <1023597546.8804.4.camel@bryan.netmeme.org>
	<004101c20f88$1b77f350$0111010a@user>
	<1023630278.18052.2.camel@bryan.netmeme.org>
	<006b01c20fbf$a7f1d850$0111010a@user>
Content-Type: multipart/alternative; boundary="=-nG3zimbeWSl/0TSyVVNm"
Date: 09 Jun 2002 11:24:01 -0600
Message-Id: <1023643441.19481.1.camel@bryan.netmeme.org>
Mime-Version: 1.0

--=-nG3zimbeWSl/0TSyVVNm
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

That's the missing link, thank you! On my GenericObjectPool I have to
call setTestOnBorrow(true) right after creating it.

I assumed (obviously incorrectly) that if my PoolableConnectionFactory
had a validationQuery, then it would complete the plumbing in the other
parts of the system as necessary to make it work. But evidently not.
This was tricky and should be documented better.

Thank you!

Bryan

On Sun, 2002-06-09 at 08:12, Juozas Baliuka wrote:

    It is code in GenericObjectPool. "_testOnBorrow"  must be set to true.
    Sorry, but I dont know how to set it in DBCP, I believe somebody more
    competent will respond to your message.
    ..........................
    if( _testOnBorrow && !_factory.validateObject(pair.value)) {
                    try {
                        _factory.passivateObject(pair.value);
                    } catch(Exception e) {
                        ; // ignored, we're throwing it out anyway
                    }
                    _factory.destroyObject(pair.value);
                } else {
    .............................................


--=-nG3zimbeWSl/0TSyVVNm--