Not able to access H2 Console in jhipster

Question

I am not able to open H2 console on the web browser. My jhipster application is running on 8088 port. In server logs I am getting that H2 database is available on port 18088.

Tried below. http://localhost:18088/h2-console

Getting Below response.

Below are the details in application-dev.yml.

devtools:
    restart:
      enabled: true
      additional-exclude: .h2.server.properties
    livereload:
      enabled: false # we use Webpack dev server + BrowserSync for livereload
  jackson:
    serialization:
      indent-output: true
  datasource:
    type: com.zaxxer.hikari.HikariDataSource
    url: jdbc:h2:mem:jhipstersampleapplication;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE
    username: jhipsterSampleApplication
    password:
    hikari:
      poolName: Hikari
      auto-commit: false
  h2:
    console:
      enabled: true
  jpa:
    database-platform: io.github.jhipster.domain.util.FixedH2Dialect
    database: H2
    show-sql: true
    properties:
      hibernate.id.new_generator_mappings: true
      hibernate.connection.provider_disables_autocommit: true
      hibernate.cache.use_second_level_cache: true
      hibernate.cache.use_query_cache: false
      hibernate.generate_statistics: false

Please Help me out with this.

Same problem, did you find a solution? – Alexy Mar 27 '21 at 19:15 — Alexy, Mar 27 '21 at 19:15

score 7 · Answer 1 · answered Mar 28 '21 at 13:08

7

Adding slash solved my problem http://localhost:8080/h2-console to http://localhost:8080/h2-console/

answered Mar 28 '21 at 13:08

Alexy

359
3
10

score 2 · Answer 2 · answered Aug 30 '19 at 15:43

2

There are 2 different ports:

HTTP port 8088 for h2 web console, it's served by your web app (same as your REST API)
TCP port 18088 that can be used by other applications using JDBC, it can't be used from a browser. This port is opened in DatabaseConfiguration.java in your project

answered Aug 30 '19 at 15:43

Gaël Marziou

16,028
4
38
49

I tried localhost:8088/h2-console, still it is not working. Can you please explain in detail what could be the problem – Rahul Sep 03 '19 at 07:41
Did you copy application properties file to the registry? – Gaël Marziou Sep 03 '19 at 09:22

score 0 · Answer 3 · answered Nov 18 '21 at 03:45

0

Ensure you are accessing the correct port (8088 in your case), and that you do not change jhipster's setting for h2.console.enabled.

http://localhost:8088/h2-console should work.

answered Nov 18 '21 at 03:45

gachokaeric

90
3

score -1 · Answer 4 · answered Sep 28 '20 at 19:55

-1

Go to root of the app url (Access Url that you see in the application start) then type "/h2-console" in the end.

localhost:8081/services//h2-console

answered Sep 28 '20 at 19:55

user2197572

1
2

Can you explain where `/services/` comes from? I don't see it in the configuration file that the Rahul posted. – Shafiq Jetha Sep 28 '20 at 20:32

Not able to access H2 Console in jhipster

4 Answers4