How are you determining that the connection is closed and that you are getting a new connection?

David

Tony Seebregts wrote:

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.

Any ideas ?

regards

Tony Seebregts


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

Reply via email to