This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Multiple inserts in same transaction Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Multiple inserts in same transaction" Watch "Multiple inserts in same transaction" New topic
Author

Multiple inserts in same transaction

Martin Lira
Ranch Hand

Joined: May 26, 2004
Posts: 97
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

Joined: Aug 13, 2004
Posts: 1081



Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
 
jQuery in Action, 2nd edition
 
subject: Multiple inserts in same transaction
 
Similar Threads
Can i batch preparedStatements?
Displaying record not exists
How to get a blank ResultSet to do update?
Error using SCOPE_IDENTITY in java code
Performance Issues with database insert !!