'JHipster connect to H2 DB with external SQL editor

I can connect to my H2 DB in my browser:

http://localhost:8081/h2-console/login.jsp?jsessionid=649273874cf6ca550067b7f4bc033497

With Dbvisualizer I can connect but my schema and tables are not there?

Connect string for browser:

jdbc:h2:file:./target/h2db/db/my;DB_CLOSE_DELAY=-1

I have tried:

jdbc:h2:file:./target/h2db/db/my;DB_CLOSE_DELAY=-1
jdbc:h2:file:<absolute path>/my;DB_CLOSE_DELAY=-1
jdbc:h2:tcp://localhost:9092/my;DB_CLOSE_DELAY=-1
jdbc:h2:tcp://localhost:9092/<absolute path>/my;DB_CLOSE_DELAY=-1

What JDBC string should I use for an external tool?



Solution 1:[1]

You should use http:\localhost:h2-consol and connect to your database.

Link to connect h2 DB JHipster:

link to connect h2 DB JHipster

Solution 2:[2]

Here you go!

Here is how to configure it in IntelliJ Idea.

Here is how to configure in IntelliJ

enter image description here

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 m4n0
Solution 2 Khaled Algelowb