Hi, Looking at http://www.h2database.com/html/advanced.html#mvcc,
1. Does H2 only support table locks or MVCC? Or is there a way to get row locks without MVCC? 2. Using MVCC, do insert/delete operations wait until all open transactions complete? 3. Does this imply that open transactions will never experience insert/delete rows by other threads in mid-transaction? 4. What happens in the following scenario? Database contains a single row: count[value=1] T1: Open transaction T2: Open transaction T2: update count set value=2 where value=1 T2: commit T1: select value from count Will T1 see a value of 1 or 2? Thanks, Gili -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
