H2 database connecting to in memory instead of file database

Question

I am stuck in this, trying to change my h2 db from in memory to file based. But everytime on restart, it automatically connects to in memory.

Here is my application.properties

server.port=8010
spring.datasource.url=jdbc:h2:file:~/transactionsdb;AUTO_SERVER=TRUE
spring.datasource.driverClassName=org.h2.Driver
spring.datasource.username=user
spring.datasource.password=password
#spring.sql.init.continue-on-error=true
spring.jpa.database-platform=org.hibernate.dialect.H2Dialect
spring.jpa.show-sql=true
spring.h2.console.enabled=true
#spring.jpa.defer-datasource-initialization=true
spring.jpa.hibernate.ddl-auto=none

Please help me to progress. Thanks in advance

Rohit Agarwal · Accepted Answer · 2022-10-27 17:07:51Z

1

This is my application.yml file and on restart H2 database is connecting to the file database. I have created test1.mv.db file in /Users/rohit/ directory.

spring:
  h2:
    console:
      enabled: true
  datasource:
    url: jdbc:h2:file:/Users/rohit/test1
    username: sa
    password:
  data:
    jpa:
      repositories:
        bootstrap-mode: default

In application start-up logs also I can see the same information

answered Oct 27, 2022 at 17:07

Rohit Agarwal

1,0082 gold badges7 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Manoj Majumdar Over a year ago

HI @Rohit, this test1.mv.db file is created by you or is it automatically created?

Rohit Agarwal Over a year ago

It is automatically created.

Rohit Agarwal Over a year ago

@ManojMajumdar - If my answer helps request you to please accept it so that it helps others as well.

Manoj Majumdar Over a year ago

The problem was with my datasource configuration, I had another embedded datasource configuration in my @configuration file, which ignored the configuration of my properties file

Collectives™ on Stack Overflow

H2 database connecting to in memory instead of file database

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related