How to access *.mv.db file of H2 database?

java persistence h2 dbvisualizer
Suzan Cioc picture Suzan Cioc · Nov 24, 2014 · Viewed 26.3k times · Source

I have created database with my own program and it appeared as mydatabase.mv.db file.

But when I tried to access the same database with DbVisualizer, with apparently same parameters, it created two files mydatabase.lock.db and celebrity.h2.db and didn't see tables, created in the program.

What was the incompatibility?

UPDATE

both setups are follows:

enter image description here

enter image description here

Answer

Thomas Mueller picture Thomas Mueller · Nov 24, 2014

In H2 version 1.3.x, the database file <databaseName>.h2.db is the default. (The storage engine "PageStore" is used).

In H2 version 1.4.x, the database file <databaseName>.mv.dbis the default. (The storage engine "MVStore" is used). The MVStore is still beta right now (November 2014). But you can disable the MVStore by appending ;mv_store=false to the database URL.

Related questions

Spring: H2 Database persistence

My application.properties: spring.datasource.driverClassName=org.h2.Driver spring.datasource.url=jdbc:h2:./src/main/resources/asnDB;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE spring.datasource.user=sa spring.datasource.password= spring.h2.console.enabled=true spring.…

Read More
No Persistence provider for EntityManager named

I have my persistence.xml with the same name using TopLink under the META-INF directory. Then, I have my code calling it with: EntityManagerFactory emfdb = Persistence.createEntityManagerFactory("agisdb"); Yet, I got the following error message: 2009-07-21 09:22:41,018 [main] ERROR - …

Read More
Hibernate: "Field 'id' doesn't have a default value"

I'm facing what I think is a simple problem with Hibernate, but can't solve it (Hibernate forums being unreachable certainly doesn't help). I have a simple class I'd like to persist, but keep getting: SEVERE: Field 'id' doesn't have a …

Read More