The DB URL is like this: jdbc:h2:tcp://localhost:<port>/<path-to-db-file>;USER=<user>;PASSWORD=<password>;...
Basically I have two Maven modules that each create their own independent H2 in embedded mode. There is no interaction between the modules, each one spins-up a H2 embedded database referring to a file on disk, does its own thing and in the end it closes the database. There are no leftover H2 DBs running once each module finishes its work. Other than that all the other modules do not use H2 in any way. Regarding the tests - no, see my previous paragraph. In fact, these are not tests, rather kind of a load & query that is used for generating some build-time related artifacts. Regarding contention - the module that uses H2 is the only one that is accessing it, and is the only one querying the database at that time. When I execute it alone, As described in my initial post: normally it takes 2-3 minutes. Together with other unrelated modules in parallel - ~1 hour. On Saturday, April 29, 2017 at 2:21:50 PM UTC+3, Noel Grandin wrote: > > Another thing: are all your tests perhaps sharing the same db? > Could be this is just contention on one table. > On Sat, 29 Apr 2017 at 07:29, Noel Grandin <[email protected] > <javascript:>> wrote: > >> shouldnt be, but h2 has lots of features and options, could be an >> unexpected interaction >> >> On 28 April 2017 at 22:57, Silvio <[email protected] >> <javascript:>> wrote: >> >>> Why do you ask that? Is multiple dbs inside one jvm a possible reason >>> for poor performance? If that is the case we are in serious trouble... >>> >>> -- >>> 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] <javascript:>. >>> To post to this group, send email to [email protected] >>> <javascript:>. >>> Visit this group at https://groups.google.com/group/h2-database. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- 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.
