Hi, Well, the "db_close_delay=-1" will ensure the database is kept even if you close the last connection.
Could you just use different database names? That should solve the problem: jdbc:h2:mem:db1;DB_CLOSE_DELAY=-1;MVCC=TRUE jdbc:h2:mem:db2;DB_CLOSE_DELAY=-1;MVCC=FALSE Or with version 1.4.x: jdbc:h2:mem:db1;DB_CLOSE_DELAY=-1 jdbc:h2:mem:db2;DB_CLOSE_DELAY=-1;MVCC=FALSE Maybe you can even get rid of the "db_close_delay". Regards, Thomas On Wednesday, April 8, 2015, Steve Ebersole <[email protected]> wrote: > We had originally used jdbc:h2:mem:db1;DB_CLOSE_DELAY=-1;MVCC=TRUE > > I had to change that everywhere to instead > use jdbc:h2:mem:db1;DB_CLOSE_DELAY=-1 > > On Wed, Apr 8, 2015 at 7:37 AM, Thomas Mueller < > [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: > >> Hi, >> >> What database URLs do you currently use? >> >> Maybe we should add a way to auto-delete the database file if it is >> closed? This could be done in the file system abstraction, for example >> using the prefix "autoDelete:", so that a database URL would look like >> "jdbc:h2:autoDelete:./target/db/test" (using a relative path in this case, >> which should be OK for unit tests). >> >> Regards, >> Thomas >> >> >> >> On Wed, Apr 8, 2015 at 9:20 AM, Noel Grandin <[email protected] >> <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: >> >>> >>> >>> On 2015-04-07 10:32 PM, Steve Ebersole wrote: >>> >>>> 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? >>>> >>> >>> We run a deleteDb() command at the end of every test to make sure there >>> is nothing left lying around to trip up the next test. >>> >>> >>> -- >>> 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:_e(%7B%7D,'cvml','h2-database%[email protected]');> >>> . >>> To post to this group, send email to [email protected] >>> <javascript:_e(%7B%7D,'cvml','[email protected]');>. >>> Visit this group at http://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 a topic in the >> Google Groups "H2 Database" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/h2-database/dQaB7-9yYG8/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> [email protected] >> <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> >> . >> To post to this group, send email to [email protected] >> <javascript:_e(%7B%7D,'cvml','[email protected]');>. >> Visit this group at http://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] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at http://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 http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
