Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
Date: Mon, 15 Aug 2005 09:38:14 -0700
From: David Van Couvering <David.Vancouvering@Sun.COM>
Subject: Re: PooledConnection being closed
In-reply-to: <wjo8oe7z8m2y.fsf@sun.com>
To: Derby Discussion <derby-user@db.apache.org>
Message-id: <4300C4F6.4010208@sun.com>
MIME-version: 1.0
Content-type: multipart/mixed; boundary="Boundary_(ID_6xN1hxUSZzxpW333SNsSaA)"
User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716)
References: <1121180210.30679.ezmlm@db.apache.org>
 <43007598.8000808@cibecs.com> <wjo8oe7z8m2y.fsf@sun.com>

This is a multi-part message in MIME format.

--Boundary_(ID_6xN1hxUSZzxpW333SNsSaA)
Content-type: text/plain; charset=ISO-8859-1; format=flowed
Content-transfer-encoding: 7BIT

With the Connection.toString() that was just checked into the trunk (and 
I think Tomohito backported into the 10.1 branch) you can see if the 
underlying "physical" connection is the same...

David

Knut Anders Hatlen wrote:

>Tony Seebregts <tonys@cibecs.com> writes:
>
>  
>
>>Hi,
>>
>>I'm writing a connection pool manager using the
>>EmbeddedConnectionPoolDatasource class. The requesting object gets the
>>Connection object from a PooledConnection  getConnection() , executes
>>a SQL statement and then closes the Connection.
>>
>>This correctly invokes the ConnectionEventListener.close() method -
>>which simply marks the pooled connection as available for reused. But
>>when I try to resuse the connection originally supplied by the
>>PooledConnection getConnection() method the connection is
>>closed. Calling getConnection returns me a new Connection which is
>>(AFAIK) not the idea.
>>    
>>
>
>Well, the point with pooled connections is that you use
>getConnection() and close() as with ordinary connections, but the
>underlying physical connection is kept open. The Connection object
>returned by getConnection() is a logical connection, and you cannot
>use it after it is closed. If you call getConnection() again, you will
>get a new logical connection, and therefore a new Connection
>object. However, the new logical connection might still use the same
>physical connection.
>
>  
>

--Boundary_(ID_6xN1hxUSZzxpW333SNsSaA)
Content-type: text/x-vcard; charset=utf-8; name=david.vancouvering.vcf
Content-transfer-encoding: 7BIT
Content-disposition: attachment; filename=david.vancouvering.vcf

begin:vcard
fn:David Van Couvering
n:Van Couvering;David
org:Sun Microsystems, Inc.;Database Technology Group
email;internet:david.vancouvering@sun.com
title:Senior Staff Software Engineer
tel;work:510-550-6819
tel;cell:510-684-7281
x-mozilla-html:TRUE
version:2.1
end:vcard


--Boundary_(ID_6xN1hxUSZzxpW333SNsSaA)--