Problem with connection-close without rollback or commit
843854Nov 27 2002 — edited Aug 1 2003Hi all,
Do I absolutely need to call commit() or rollback() on a connection (or statement) object before calling close()?
I thought an automatic rollback must be performed if I close it without calling commit (or rollback) on it first. But I encountered some problems which made me think that there may be a problem with driver.
(Some 'zomby' processes remained in the database server)
Is it necessary to call commit or rollback before closing a connection, or is it driver dependent? (I use oracle jdbc driver)
Thank you