This week's book giveaway is in the Agile and Other Processes forum.
We're giving away four copies of The Little Book of Impediments (e-book only) and have Tom Perry on-line!
See this thread for details.
Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Invalid Transaction state

 
shobha satalkar
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,
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
Posts: 172
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic