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

A Transaction Question

 
Gregg Bolinger
Ranch Hand
Posts: 15304
6
Chrome IntelliJ IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ok, I haven't recieved very many responses to a couple of other questions, so I thought I would post another one that is similar but still different and may make more sense.
MySQL-MAX - innoDB table types
Connector/J V3
If I begin a transaction with a serilaizable isolation level and then move my result set to a new record, will my AutoIncremented ID be protected from other writes to the same table as long as I have not commited the transaction?
Also, which isolation level will protect only a single record from being writable, or is that even possible? Do isolation levels affect the entire table?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic