We added db_close_delay because we have tests that open a Hibernate Session (connection), do some work, close that Session (thus closing that connection), open a new Session and try to do some work with the stuff done in the initial Session. But H2 had dropped the database in between.
On Wed, Apr 8, 2015 at 11:02 AM, Thomas Mueller < [email protected]> wrote: > 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]> 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]> >>> 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]. >>>> 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. >>>> >>> >>> -- >>> 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]. >>> 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. >>> >> >> -- >> 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. >> > -- > 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]. > 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. > -- 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.
