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_at_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 - 23:30:09 CET

This message: [ Message body ]
Next message: Jug Ray: "Re: optimum datatype for primary key column O9i"
Previous message: mcstock: "Re: Oracle Sql Optimalization"
Next in thread: mcstock: "Re: oracle JDBC - how to detect uncommitted work on an open Connection ?"
Reply: mcstock: "Re: oracle JDBC - how to detect uncommitted work on an open Connection ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message