posted 18 years ago
We are running Websphere 5.1 on a Mainframe and connecting to DB2 7.0 on O/S 390 using a type 2 driver.
When I obtain a connection, create a statement on it, use it and forget to close the statement, when i release the connection using connection.close(), will websphere close any remaining statements/resultsets before returning the connection back to the pool?
I could really make sure all my statements get closed by giving my programmers my own connection object, track what all statements were created, and close any open statements them when the connection is closed (returned back to the pool), but if websphere is already doing it for me, I might as well get a free ride :-)
SJCP, SCBCD, SJCD, SCDJWS, SCEA (Part I)