Hi, please excuse the rather general question, but I figured I might as well ask here as I'm using H2.
Basically, my question is when are tables locked and unlocked? Say, I start a transaction on a table, then select and update some stuff on it. For that it will be locked. Now my guess is, H2 will only unlock the table once I commit or rollback the transaction. Correct? I assume that once I commit, another waiting connection will be able to obtain the lock. Will it be *any* waiting connection or will it be the connection that has been waiting longest (FIFO)? In that context, what's the state of mvcc? Still beta and/or unstable? Thank you! -hendrik -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
