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