jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes A Transaction Question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "A Transaction Question" Watch "A Transaction Question" New topic

A Transaction Question

Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15302

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?

GenRocket - Experts at Building Test Data
I agree. Here's the link: http://aspose.com/file-tools
subject: A Transaction Question
jQuery in Action, 3rd edition