Two Laptop Bag*
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "A Transaction Question" Watch "A Transaction Question" New topic
Author

A Transaction Question

Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15299
    
    6

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
 
It is sorta covered in the JavaRanch Style Guide.
 
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