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