my dog learned polymorphism*
The moose likes JDBC and the fly likes A Transaction Question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "A Transaction Question" Watch "A Transaction Question" New topic

A Transaction Question

Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15299

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:
subject: A Transaction Question
Similar Threads
Locking with JDBC
how analysts can make sure that some operation need isolation level or transaction?
Protect AutoIncremented Row
JDBC multiple statements in prepatedStatement?
Serializable isolation in EJB