springboot h2 fails to create db and to login into h2-console

Question

I am using spring boot and maven to build my user Onlineshop. I would like to access my h2-console database onlineshop but I am failing to login with everything left as default. Also the database onlineshop is not created. Spring Boot is not throwing any errors since am using embedded tomcat. Thanks in advance for your help.

Here is my dependency

<!-- https://mvnrepository.com/artifact/com.h2database/h2 -->
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<version>1.4.199</version>
<scope>runtime</scope>

application.properties

spring.h2.console.enabled=true
spring.datasource.platform=h2
spring.datasource.url=jdbc:h2:mem:onlineshop

Error

No, I am connecting to localhost:8080//h2-console but once it fails that url is generated automatically — Odwori
– Odwori, Commented Sep 5, 2019 at 15:44
I think you may remove the spring.datasource.url=jdbc:h2:mem:onlineshop from properties file because spring boot enables auto configuration — Brooklyn99
– Brooklyn99, Commented Sep 5, 2019 at 15:55

Romil Patel · Accepted Answer · 2019-09-05 16:14:38Z

2

Set below properties in the application.properties

spring.h2.console.enabled=true
spring.datasource.url=jdbc:h2:mem:onlineshop;IFEXISTS=FALSE;DB_CLOSE_DELAY=-1
spring.datasource.driverClassName=org.h2.Driver
spring.datasource.username=sa
spring.datasource.password=
spring.jpa.database-platform=org.hibernate.dialect.H2Dialect
spring.h2.console.path=/h2-console

IFEXISTS

By default, when an application calls DriverManager.getConnection(url, ...) with embedded URL and the database specified in the URL does not yet exist, a new (empty) database is created. In some situations, it is better to restrict creating new databases, and only allow to open existing databases. To do this, add ;IFEXISTS=TRUE to the database URL. In this case, if the database does not already exist, an exception is thrown when trying to connect

edited Sep 5, 2019 at 16:14

answered Sep 5, 2019 at 16:02

Romil Patel

14k9 gold badges54 silver badges84 bronze badges

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

5 Comments

Odwori Over a year ago

with this answer localhost:8080//h2-console displays error

Romil Patel Over a year ago

@Odwori please add spring.h2.console.enabled=true

Romil Patel Over a year ago

can you clean and rebuild the project if it does not help then remove spring.h2.console.path=/h2-console

Romil Patel Over a year ago

can you update the question with the application file to see updated properties with last error message or image

Odwori Over a year ago

I have solved it by simply going for lower version of com.h2databse <version>1.3.170</version>. Thanks all for your willingness to help

Odwori · Accepted Answer · 2019-09-05 16:41:12Z

0

I solved this by simply downgrading the com.h2database

<!-- https://mvnrepository.com/artifact/com.h2database/h2 -->
    <dependency>
        <groupId>com.h2database</groupId>
        <artifactId>h2</artifactId>
        <version>1.3.170</version>
        <scope>runtime</scope>
    </dependency>

answered Sep 5, 2019 at 16:41

Odwori

1,90019 silver badges14 bronze badges

Collectives™ on Stack Overflow

springboot h2 fails to create db and to login into h2-console

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related