Why I can't find my tables in H2 schema / How can I validate which H2 schema my Spring boot app is working with?

Question

I'm running a spring boot app

didn't have any setting for h2 other than maven

when i'm connecting to the h2 console i can see the tables that were supposed to be created for two entities

i connected with the JDBC URL: jdbc:h2:mem:testdb (which is supposed to be the default)

Is there a way to make sure what schemas is H2 currently running/ or some log file for H2 ?

in my application.properties i have this:

spring.h2.console.enabled=true
spring.h2.console.path=/h2

I read somewhere that H2 initializing itself upon login, but a demo i was watching these were the exact steps taken , so not sure that is the case.

these are the settings in the H@ console:

Answer 1

You can explicitly instruct spring boot to create and connect to a particular schema in H2 with config as below.

spring.datasource.url=jdbc:h2:~/test;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE
spring.datasource.driverClassName=org.h2.Driver
spring.datasource.username=sa
spring.datasource.password=sa

This creates a datasource of name test database in h2 in file mode. There would be a file called test.db in your home folder which would be the data file for the database.

DB_CLOSE_ON_EXIT property decides to recreate the database on every restart.