does java connectionpooled.close() will close the db session

Question

if the close of javax.sql.connectionpooled connection,it will not leave any INACTIVE SESSION in Database.in my case i can see many INACTIVE SESSIONS in DB(oracle), how to close it,programatically.

Mark Rotteveel · Accepted Answer · 2011-10-20 10:54:33Z

1

Are you talking about a javax.sql.PooledConnection implementation (which should not be used by you, but only by a connectionpool), or a Connection obtained from a connection pool?

If the first: closing a PooledConnection should close the physical connection, if the second: closing a (logical) connection obtained from the connectionpool should leave the physical connection open, because that is the whole point of the connectionpool.

Things get a bit more complicated when you abuse various layers of datasource which each do their own connectionpooling.

answered Oct 20, 2011 at 10:54

Mark Rotteveel

110k240 gold badges160 silver badges232 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

does java connectionpooled.close() will close the db session

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related