users@glassfish.java.net

need pooled sqlconnection only for one usage --> after this close

From: <glassfish_at_javadesktop.org>
Date: Thu, 07 Jan 2010 05:49:15 PST

Hi forum,

for my own written connectionpooling I need a serialized SQLConnection. I can get this by an oracle Connection when I create it via oracle.jdbc.pool.OracleDataSource.

As far as I know I can get this only via resource got by applicationserver. But when I use this feature I used the build in connectionpooling from app server. This would be ok when the connection is really closed agains db and removed from the pool from appserver when I close the created connection via datasource.

My question is:

is it possible to force close(remove against app server pooling) a connection when this is a oracle.jdbc.pool.OracleDataSource connection or is it possible to setup the pooling to let all connections used only one time and then remove/close it from pool.

thanks for any hint

regards Dietmar
[Message sent by forum member 'oaspublic' (dietmar.mueller_at_eurotours.at)]

http://forums.java.net/jive/thread.jspa?messageID=379288