How to fix h2-databse not found

Question

This is my first spring boot application. I am trying to connect the database using h2-console. But when I trying to do it I am getting an error. The error is,

Database "/Users/MyName/test" not found, either pre-create it or allow remote database creation (not recommended in secure environments) [90149-200] 90149/90149 (Help)

I have shown h2-conosle image above. I did not use any code in application.property file. As well as I have used below mentioned dependency also.

<dependency>
    <groupId>com.h2database</groupId>
    <artifactId>h2</artifactId>
    <scope>runtime</scope>
</dependency>

First My port was 8080 Then also this not worked. After that, the port has been changed to 8082. even it not working.

Answer 1

First approach

1. Search for h2 in spring boot logs, there will be log like H2 console available at '/console'. Database available at 'jdbc :h2:mem:5bcffde7-27bd-4d59-9ad1-3bc12635f0bf'. Note: /console is the path, i chosen for h2-console in application.properties, this will vary according to the path you have chosen.
2. Copy the url without single quotes and no spaces between them i.e jdbc:h2:mem:5bcffde7-27bd-4d59-9ad1-3bc12635f0bf.
3. Enter this in the JDBC Url in h2-console.
4. Then you should be able to connect to it.

The second and simpler approach

Configuring the h2 database url in application.properties without the need of spring randomly generating it.

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

Answer 2

Try creating the file test.mv.db in your home directory - worked for me. Seems H2 sometimes has trouble creating files for an unknown reason. Please comment if you know why.

E.g.

PS> ni c:\users\<your user>\test.mv.db

Found here in unselected answer to a similar question.