I am tring to refresh a Connection without closing it phsically from db.
We are using a simple connection pool(hand-made ,and not mine
How can i do that with out creating a new connection?
I googled for it in the net and in this site ; http://www.lc.leidenuniv.nl/awcourse/oracle/java.920/a96654/connpoca.htm#1057365
They say ;
"Closing a connection instance that was obtained from a pooled connection does not close the physical database connection. It does, however, free the resources of the connection instance, clear the state, close statement objects created from the connection instance, and restore the defaults for the next connection instance that will be created."
When i saw that i felt so happy then.
But at the next paragraph says;
"To actually close the physical connection, you must invoke the close() method of the pooled connection..."
I am confused.
How can i refresh a connection resources without reopening a new Connection to db?
[ June 01, 2006: Message edited by: sinasi susam ]