File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Transaction isolation level

 
Giuseppa Cefalu
Ranch Hand
Posts: 121
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 20203
26
MySQL Database
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 121
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks! I use MySQL.
 
Paul Clapham
Sheriff
Pie
Posts: 20203
26
MySQL Database
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 121
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic