aspose file tools*
The moose likes JDBC and the fly likes how to apply transactional insert is a scenario that 3 tables are going to change?	Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to apply transactional insert is a scenario that 3 tables are going to change?	" Watch "how to apply transactional insert is a scenario that 3 tables are going to change?	" New topic
Author

how to apply transactional insert is a scenario that 3 tables are going to change?

raminaa niilian
Ranch Hand

Joined: Jul 14, 2005
Posts: 551
Hi thank you for reading my post
How i can apply transaction in a scenario like this :

In one of my web applicatinon page , i have 3 functions that each of them update/insert data to a table
I use connection pool to retrieve a connection in each of those functions (i can use one connection for all of functions but i do not know whether it is good or not).
Now the changes to database just should be applied if all of those functions insert data sucessfully.
my problem is that i do not know how i can use transaction in this case.

I need just the transaction over these inserts , which kind of commit mode i should use?
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336


(i can use one connection for all of functions but i do not know whether it is good or not

If you want to use JDBC transactions you will have to perform all three DB operations in one Connection. There isn't a way using JDBC alone to wrap the operations of three seperate Connections into one transaction.

If you can't change your code, you could wrap the call to these methods in a JTA transaction, presuming you have a transaction service you can use. It might be easier however (since this is a Servlet enviornment not an EJB environment) to fix your three methods to use one Connection.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
 
subject: how to apply transactional insert is a scenario that 3 tables are going to change?