i done connection.setAutoCommit(false) and done some operation in my connection like select some columns and update some table after all this operations i like to know weather my connection object is commitable, ie i want to know weather i need to execute connection.commit() or connection.rollback()
Measure twice cut once carpenter theory <br /> <br />Baiju <br />SCJCP, SCBCD, IBM-486, IBM-484, SCEA Part I
Baiju, Whether to commit or rollback is usually a business decision. If a call threw a SQLException, you would almost certaintly want to rollback. But that would have been handled by autocommit and a transaction. Think back to why you set autocommit to false. What problem were you trying to solve?
hi Jeanne, Thank you. I want to do a two-phase commit for a connection, (it is already provided by JTA, reinvent the wheel). I want to write a connection manager that handles N number of connection in a transaction. i want to know all the statements in all the connection object is executed fine then i want to fire the commit on all the connection object or else i want to fire rollback. if there is any exception raised at the time of commiting i want to do the rollback on all the other connection.
author & internet detective
Baiju, You could write a wrapper around the connection to track whether it should rollback. This object could run all queries on the user's behalf and therefore tell whether an exception occurred. Or provide a setRollbackOnly() method for callers to do this explicitly.