When MV_STORE is not set explicitely, H2 may create the database without the MV_STORE (it creates a file .h2.db)

[Axel Maumont]

Hello,

First thank you for your amazing work on H2 :-)

I'm using h2-1.4.185.jar

I noticed something which looks like to a bug, the problem is that in at least one particular case H2 does creates the database H2 store despite I expect a MV_STORE because this is the default one.

I was able to reproduce the problem with the following steps:

• start H2 in server mode
• (optional) create a database with url jdbc:h2:myDb;AUTO_SERVER=TRUE
  => file "myDb.mv.db" is created
• (optional) disconnect from db
• (optional) remove file "myDb.mv.db"
• create a database with url: jdbc:h2:myDb;MV_STORE=FALSE;MVCC=FALSE;AUTO_SERVER=TRUE
  => file "myDb.h2.db" is created
• disconnect from db
• reconnect to database with url: jdbc:h2:myDb;AUTO_SERVER=TRUE
• it is connected to "myDb.h2.db"
• disconnect from db
• remove file "myDb.h2.db"
• create a database with same url: jdbc:h2:myDb;AUTO_SERVER=TRUE

  => file "myDb.h2.db" is created instead of expected default "myDb.mv.db"

What do you think about this behavior ?

It works well if I set explicitely the MV_STORE.

Thank you.

[Thomas Mueller]

Hi,

I think I (independently) found and fixed the problem now in the trunk. If it was the same problem (this I will still need to test).

Regards,

Thomas

--
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 h2-database...@googlegroups.com.
To post to this group, send email to h2-da...@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

[Axel Maumont]

Hello Thomas,

ok, I will test with a latest not released build asap.

Thank you !

[Axel Maumont]

I tested with success the version 1.4.186.

Thanks again !