Thank you so much Evgenij Ryazanov. I'm using a set of reports (created in Microsoft Report Builder) which execute queries on H2 database. So, when I am running one report, other reports are blocked. Other reports have to wait till the execution of running report finishes. All reports creates a separate connection with H2. So, I believe your solution should work for me. In this case can I use ; MULTI_THREADED=TRUE?
On Thursday, July 5, 2018 at 7:44:54 AM UTC+5:30, Evgenij Ryazanov wrote: > > 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.
