my dog learned polymorphism
The moose likes JDBC and the fly likes A Transaction Question Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "A Transaction Question" Watch "A Transaction Question" New topic
Author

A Transaction Question

Gregg Bolinger
Ranch Hand

Joined: Jul 11, 2001
Posts: 15230

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?
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: A Transaction Question
 
Similar Threads
how analysts can make sure that some operation need isolation level or transaction?
Locking with JDBC
Protect AutoIncremented Row
Serializable isolation in EJB
JDBC multiple statements in prepatedStatement?