Cannot connect to h2 database in Intellij

Question

I´m trying to follow this tutorial tutorial in Intellij IDEA but when i try to connect to h2 database the console trowns me an error:

 Connection is broken: "java.net.ConnectException: Connection refused: connect: localhost:9092" 
        java.net.ConnectException: Connection refused: connect.

What i need to do to make the connection?

Thanks in advance

Answer 1

Change connection type from "Remote" to "In-memory"

Answer 2

The problem is with the url, it needs to path to your app: jdbc:h2:file:C:\Users\romul\IdeaProjects\raspberryAwards;MV_STORE=false;AUTO_SERVER=TRUE