Hello. Multi-threaded mode had some issues with concurrent reading and modification. If you definitely don't use concurrent queries and updates in the same table you can add ;MULTI_THREADED=TRUE to your database URL, and remove ;LOCK_MODE=0 because these settings will conflict with each other.
These issues that were resolved recently. Multi-threaded mode was also enabled by default for MVStore and it may be used with LOCK_MODE=0. So it's may be safer to download current sources from the GitHub: https://github.com/h2database/h2database Building instructions are here, you need the jar target: http://www.h2database.com/html/build.html#building With current database there is no need to enable multi-threading explicitly but LOCK_MODE=0 may cause own surprises, make sure that you really need it. Also make sure that you create a separate Connection (not only a separate Statement) for each concurrent query. Single connection cannot perform concurrent queries by itself. All these information are only for default MVStore mode. -- 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.
