given that the new engine is MVCC, I can't see how that is going to work.
You'd need to lock the whole table (which we don't currently support) or use SERIALIZABLE transaction mode, which we also don't support with the MVSTore engine
If you need that kind of thing in the latest H2, your only option is to use the old PageStore engine, by passing in MVSTORE=FALSE in the connection URL
-- 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 https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
