H2 Database not found error: 90146. H2 database is not created on start

Question

Just created a simple spring-boot project from the spring initializer. I went to add a local h2 db for testing and am unable to login. Seems that it cannot create the test db when starting up but cannot figure out why this may be the case.

spring:
  h2:
    console:
      enabled: true
      path: /h2
  datasource:
    url: jdbc:h2:mem:testdb;
    username: sa
    password:
    driver-class-name: org.h2.Driver
    platform: h2
  jpa:
    show-sql: true
    hibernate:
      ddl-auto: create
    properties:
      hibernate:
        dialect=org:
          hibernate:
            dialect:
              H2Dialect: org.hibernate.dialect.H2Dialect

Database "mem:testdb" not found, and IFEXISTS=true, so we cant auto-create it [90146-199] 90146/90146

Not sure if it matters but you got a semicolon in the datasource url — Stuck
– Stuck, Commented May 19, 2019 at 22:39

Ashwin Patil · Accepted Answer · 2020-07-03 07:35:38Z

25

In earlier version of spring, default url will be jdbc:h2:mem:testdb and testdb was created by default. from 2.3.0 onwards, if url is not mentioned it will auto generate database name. auto generated database name can be found in the spring logs.

answered Jul 3, 2020 at 7:35

Ashwin Patil

1,3572 gold badges26 silver badges29 bronze badges

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

3 Comments

Nate T Over a year ago

for me it is the twelfth message from the top (in the console). Message is as follows:

o.s.b.a.h2.H2ConsoleAutoConfiguration    : H2 console available at '/h2-console'. Database available at 'jdbc:h2:mem:36963133-9e0a-40bf-bac6-ed118afb3a97'

I just copied and pasted the location into the console and connected.

Paul Lewallen Over a year ago

Great tip! I found it in the log as well.

OhadR Jan 16 at 21:06

upvoted. thanks. is it possible to set a permanent name for h2 url? it changes every run...

Tarun Kolla · Accepted Answer · 2019-07-22 15:11:24Z

15

I had the same error and I found these to be helpful:

Adding a pre-2019 version to the pom.xml file as below:

<dependency>
        <groupId>com.h2database</groupId>
        <artifactId>h2</artifactId>
        <version>1.4.193</version>
</dependency>

This fixes the error but isn't the right way to do it. The newer version of H2 Database do not create a new database as it doesn't exist by default and are enabled to false for security purposes.

A better way would be adding making changes to url as:

jdbc:h2:mem:testdb;IFEXISTS=FALSE;

Hope it helps. I made changes in my application.properties file.

edited Jul 22, 2019 at 15:11

answered Jul 20, 2019 at 20:28

Tarun Kolla

1,0241 gold badge13 silver badges32 bronze badges

3 Comments

Gimnath Over a year ago

URL changing method worked for me. Thank you very much

Nallamachu Over a year ago

How to access from h2-console?

Baodi Di Over a year ago

The console works fine after change from 2.4.2 to 2.4.193 or change url to jdbc:h2:mem:testdb with 2.4.2, also work fine for me.

Hamza Abdaoui · Accepted Answer · 2020-12-28 19:06:55Z

6

just append this to your application.properties file.

spring.datasource.url=jdbc:h2:mem:testdb
spring.data.jpa.repositories.bootstrap-mode=default

edited Dec 28, 2020 at 19:06

Hamza Abdaoui

2,2274 gold badges26 silver badges39 bronze badges

answered Dec 28, 2020 at 7:50

Priyank

611 silver badge1 bronze badge

Comments

Simon Martinelli · Accepted Answer · 2019-05-20 07:43:22Z

4

As Stuck said.

Simply remove the semicolon:

wrong:    jdbc:h2:mem:testdb;
correct:  jdbc:h2:mem:testdb

answered May 20, 2019 at 7:43

Simon Martinelli

36.6k6 gold badges62 silver badges92 bronze badges

Comments

OhadR · Accepted Answer · 2025-01-16 21:11:56Z

4

I have the same problem with windows. I just change spring.datasource.url in application property file to jdbc:h2:file:C:/data/sample and run project. after that set JDBC URL to jdbc:h2:file:C:/data/sample. look like picture JDBC URL

edited Jan 16 at 21:11

OhadR

8,9593 gold badges49 silver badges57 bronze badges

answered May 24, 2020 at 16:00

Niloufar Vafaei

414 bronze badges

Comments

Ronald · Accepted Answer · 2019-05-25 06:07:42Z

2

I had a same problem and I changed the version of Spring Boot to 2.1.3 and it works

answered May 25, 2019 at 6:07

Ronald

3013 gold badges8 silver badges24 bronze badges

Comments

Dobromir Kirov · Accepted Answer · 2022-10-13 09:11:12Z

1

wrong:

spring.datasource.url=jdbc:h2:mem:testdb

This below solution worked for me

spring.datasource.url=jdbc:h2:file:~/test;

edited Oct 13, 2022 at 9:11

Dobromir Kirov

1,0611 gold badge9 silver badges19 bronze badges

answered Sep 29, 2022 at 17:30

Java lover

214 bronze badges

Comments

kylewelsby · Accepted Answer · 2021-01-04 23:00:37Z

0

If you are using spring boot in order to use h2 DB, make sure you have dependencies on your pom.xml file

<dependency>
     <groupId>org.springframework.boot</groupId>
     <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
     <groupId>com.h2database</groupId>
     <artifactId>h2</artifactId>
     <scope>runtime</scope>
</dependency>

Your application.yml makes it possible to access h2 DB by URI /h2-console preceded by server URL and to connect to DB named "testdb" with username "sa" and no password, after the application has been started on the server.

edited Jan 4, 2021 at 23:00

kylewelsby

4,1192 gold badges31 silver badges35 bronze badges

answered Jan 4, 2021 at 20:41

vit

1

Comments

mandoo · Accepted Answer · 2022-12-26 11:18:37Z

0

maybe you have to setting about h2.

In application.properties

spring.h2.console.enabled=true
spring.h2.console.settings.web-allow-others=true
spring.datasource.generate-unique-name = false 
spring.h2.console.path=/h2-console
spring.datasource.url=jdbc:h2:mem:testdb
spring.datasource.driverClassName=org.h2.Driver

when you put these codes in Application.properties you can see how it work!

answered Dec 26, 2022 at 11:18

mandoo

1

Collectives™ on Stack Overflow

H2 Database not found error: 90146. H2 database is not created on start

9 Answers 9

3 Comments

3 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

9 Answers 9

3 Comments

3 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Linked

Related