Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Multiple inserts in same transaction

 
Martin Lira
Ranch Hand
Posts: 97
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Guys,
I am looking for some jdbc transaction mechanism. I dont want to user JTA.
Here is my problem:
I need to make two inserts into two different tables.



I need to execute both inserts in same transaction. If the first is ok but second fails then the first insert must roll back.
Is there any way in jdbc you can control the transaction and roll back?

Thanks!
Martin
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic