> > > It is actually a known "limitation". I saw an issue about it. You do not > support a combo of MVCC and queries with joins + for update. >
One thing that really hurts, that maybe you have some thoughts on dealing with, is that once I removed MVCC from the connection URL in one place other tests (mainly other subprojects) that still use the connection URL with MVCC start failing thinking I am trying to change the MVCC setting of an already existing database[1]. Really each can use its own database. Do you have any thoughts/suggestions on making sure one database is closed and another is opened around testsuites for a project? [1] Caused by: org.h2.jdbc.JdbcSQLException: Cannot change the setting "MVCC" when the database is already open; SQL statement: -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
