This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Invalid Transaction state Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Invalid Transaction state" Watch "Invalid Transaction state" New topic

Invalid Transaction state

shobha satalkar

Joined: Aug 20, 2005
Posts: 1
I am using Oracle ODBC for my application, while performing some operation it gives be exception : [Microsoft][Oracle ODBC]Invalid Transaction state.

Can any one tell me that is the cause of this exception?

I want that if data is inserted in database the it slould be reflected in all tables, and if any exception occur then no change should be reflected i any table. So, before starting insertion statement I have made connection.setAutoCommit(false);

And, if all process works fine (i.e. no exception occured then I set connection.commit() ).

Can anyone give me a solution?
Annie Smith
Ranch Hand

Joined: Mar 05, 2005
Posts: 172
YOur approach sounds okay. It might have something to do with the way the code has been written. Could you post it to give some idea?

Cheers!<br /><b>Annie</b>
I agree. Here's the link:
subject: Invalid Transaction state
It's not a secret anymore!