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 Transaction isolation level 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 "Transaction isolation level" Watch "Transaction isolation level" New topic
Author

Transaction isolation level

Giuseppa Cefalu
Ranch Hand

Joined: Jul 15, 2011
Posts: 121
Hi,

For the 3 isolation levels 1.- SET GLOBAL TRANSACTION ISOLATION LEVEL SERIALIZABLE, 2.-
SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE and 3.- SET SESSION ISOLATIOn LEVEL SERIALIZABLE.
When should I used each one?

thank you
Paul Clapham
Sheriff

Joined: Oct 14, 2005
Posts: 19747
    
  10

Well, here's somebody's explanation of what that means to MySQL; I expect it applies to other databases as well: SET TRANSACTION.
Giuseppa Cefalu
Ranch Hand

Joined: Jul 15, 2011
Posts: 121
Thanks! I use MySQL.
Paul Clapham
Sheriff

Joined: Oct 14, 2005
Posts: 19747
    
  10

I found that by using "SET GLOBAL TRANSACTION ISOLATION LEVEL SERIALIZABLE" as my Google keywords, by the way. However most of the first page of results weren't quite about that exact string, just resources talking about transaction isolation level in general.
Giuseppa Cefalu
Ranch Hand

Joined: Jul 15, 2011
Posts: 121
Here is a link a found useful: http://dev.mysql.com/doc/refman/5.0/en/set-transaction.html
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Transaction isolation level
 
jQuery in Action, 3rd edition