Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> oracle JDBC - how to detect uncommitted work on an open Connection ?

oracle JDBC - how to detect uncommitted work on an open Connection ?

From: Edoardo <e.comar.no.spam_at_no.spam.btinternet.com>
Date: Thu, 30 Oct 2003 22:30:09 +0000 (UTC)
Message-ID: <bns3dh$ckk$2@hercules.btinternet.com>


Hi

is there a way, using Oracle's JDBC drivers to find out if a given java.sql.Connection has uncommitted work pending on it ???

the reason is, close() will commit work if there is any - while if the close happens as a cleanup action after an error, it would be desirable to rollback (but I don't want to rollback always before close).

TIA.
Edoardo Comar
www.choreology.com Received on Thu Oct 30 2003 - 16:30:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US