Spring Boot default H2 jdbc connection and H2 console

Question

I am simply trying to see the H2 database content for an embedded H2 database which spring-boot creates when I don t specify anything in my application properties and start with mvn spring run  I can see hibernate JPA creating the tables but if I try to access the h2 console at the URL below the database has no tables  http   localhost 8080 console   I see suggestions like this one  View content of embedded H2 database started by Spring But I don t know where to put the suggested XML in spring-boot and even if I did  I don t want the h2console to be available anymore when an external database is configured so it is more likely that I need to handle this with some kind of conditional code  or maybe just allow spring to automatically handle it in the most ideal case where I only include H2 when a maven profile is activated   Does anyone have some sample code showing how to get the H2 console working in boot  and also the way to find out what the jdbc connection string that spring is using is

User · Answer

A similar answer with Step by Step guide.

Add Developer tools dependency to your pom.xml or build.gradle

Maven

<dependencies>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-devtools</artifactId>
        <optional>true</optional>
    </dependency>
</dependencies>

Gradle

dependencies {
    compile("org.springframework.boot:spring-boot-devtools")
}

Access the db from http://localhost:8080/h2-console/
Specify jdbc:h2:mem:testdb as JDBC URL
You should see the entity you specified in your project as a table.

User · Answer

In order to get the tables all you need to do is create 2 sql files schema sql for table creation  and data sql data for the created tables   These files to be put in src main resources folder  Spring boot auto detects them and takes care of the rest during runtime  If your using more than 2 DB in your project ensure to use specific files like  schema-h2 sql -- for h2 DB   schema-oracle sql -- for oracle DB   The same to be followed for data sql too  Also ensure that you drop tables by adding drop table statement in your schema sql as first statement  To avoid appending of duplicate records  The link for spring boot is here  My application properties is as follows  spring datasource url jdbc h2   file Shiva DB CLOSE DELAY -1 DB CLOSE ON EXIT FALSE spring datasource driver-class-name org h2 Driver spring datasource username sa spring datasource password  spring datasource platform h2 spring jpa database-platform org hibernate dialect H2Dialect spring h2 console enabled true spring datasource initialize true  spring error whitelabel enabled true spring h2 console path  console spring datasource continue-on-error true spring jpa hibernate ddl-auto create spring hibernate hbm2ddl auto update spring hibernate show sql true  You can follow the steps in the below link  https   springframework guru using-the-h2-database-console-in-spring-boot-with-spring-security

User · Answer

I have found a nice tutorial about this topic   https   springframework guru using-the-h2-database-console-in-spring-boot-with-spring-security    Basically the correct JDBC URL for me was  jdbc h2 mem testdb

User · Answer

Check spring application properties     spring datasource url jdbc h2 mem testdb DB CLOSE DELAY -1 DB CLOSE ON EXIT FALSE   here testdb is database defined  Make sure h2 console have same value while connecting other wise it will connect to default db

User · Answer

For Spring Boot 2 3 3 RELEASE straight from Spring Initialzr  POM  data jpa  h2  web application properties   spring h2 console enabled true When you run the application look for line like below in the run console  2020-08-18 21 12 32 664  INFO 63256 ---             main  o s b a h2 H2ConsoleAutoConfiguration      H2 console available at   h2-console   Database available at  jdbc h2 mem eaa9d6da-aa2e-4ad3-9e5b-2b60eb2fcbc5   Now use the above JDBC URL for h2-console and click on Connect

User · Answer

From http   docs spring io spring-boot docs current reference html common-application-properties html   H2 Web Console  H2ConsoleProperties    spring h2 console enabled true   Enable the console  spring h2 console path  h2-console   Path at which the console will be available    Adding the above two lines to my application properties file was enough to access the H2 database web console  using the default username  sa  and password  empty  as in don t enter a password when the ui prompts you

User · Answer

I found that with  spring boot 2 0 2 RELEASE  configuring spring-boot-starter-data-jpa and com h2database in the POM file is not just enough to have H2 console working  You must configure spring-boot-devtools as below  Optionally you could follow the instruction from Aaron Zeckoski in this post     lt dependency gt           lt groupId gt org springframework boot lt  groupId gt           lt artifactId gt spring-boot-devtools lt  artifactId gt           lt optional gt true lt  optional gt    lt  dependency gt

User · Answer

Use jdbc h2 mem testdb as your path when logging into the H2 console     Obviously if you have altered Spring Boot properties your datasource may be different  but it seems like you re struggling with how to find the default   That s all there is to it   You ll see your schema after logging in to H2

User · Answer

As of Spring Boot 1 3 0 M3  the H2 console can be auto-configured    The prerequisites are    You are developing a web app Spring Boot Dev Tools are enabled H2 is on the classpath   Even if you don t use Spring Boot Dev Tools  you can still auto-configure the console by setting spring h2 console enabled to true  Check out this part of the documentation for all the details   Note that when configuring in this way the console is accessible at  http   localhost 8080 h2-console

User · Answer

I had only below properties in  resources application properties  After running spring boot  using this URL http   localhost 8080 h2-console    the table in H2 console was visible and read to view the table data  also you can run simple SQL commands  One thing  in your java code  while fetching data  the column names are upper-case  even though schema sql is using lower-case names     spring datasource initialize true spring datasource url jdbc h2 mem testdb DB CLOSE DELAY - 1 DB CLOSE ON EXIT FALSE spring datasource driverClassName org h2 Driver spring datasource username sa spring datasource password  spring h2 console enabled true

User · Answer

I had made a very stupid mistake when I had this same problem  I had added H2 DB for running unit test cases and hence I had set the scope to test in pom xml  While running the application using mvn spring run I removed the scope and it works fine now

User · Answer

If you use Spring Boot s developer tools  it comes with H2 Console enabled by default  It can be accessed from  h2-console   On the login interface  for input JDBC URL use value jdbc h2 mem testdb  Pay attention to mem string   If you don t use Spring Boot s developer tools  you can enable the console in application properties using spring h2 console enabled true  This will enable console under  h2-console  If you want to change the URL then you can add another entry with spring h2 console path my console path   The default schema name is testdb   More details in Spring Boot Documentation

User · Answer

This is how I got the H2 console working in spring-boot with H2  I am not sure if this is right but since no one else has offered a solution then I am going to suggest this is the best way to do it   In my case  I chose a specific name for the database so that I would have something to enter when starting the H2 console  in this case   AZ    I think all of these are required though it seems like leaving out the spring jpa database-platform does not hurt anything    In application properties   spring datasource url jdbc h2 mem AZ DB CLOSE DELAY -1 DB CLOSE ON EXIT FALSE spring datasource driverClassName org h2 Driver spring datasource username sa spring datasource password  spring jpa database-platform org hibernate dialect H2Dialect   In Application java  or some configuration     Bean public ServletRegistrationBean h2servletRegistration         ServletRegistrationBean registration   new ServletRegistrationBean new WebServlet         registration addUrlMappings   console          return registration      Then you can access the H2 console at  server  console   Enter this as the JDBC URL  jdbc h2 mem AZ

User · Answer

For Spring Boot 2 1 1 straight from Spring Initialzr    Default with devtools is http   127 0 0 1 8080 h2-console    POM  spring-boot-starter  h2  spring-boot-starter-web  spring-boot-devtools  Without devtools - you need to set it in properties  spring h2 console enabled true spring h2 console path  h2-console     POM  spring-boot-starter  h2  spring-boot-starter-web    Once you get there - set JDBC URL  jdbc h2 mem testdb  The default one will not work

[java] Spring Boot default H2 jdbc connection (and H2 console)

Examples related to java

Examples related to spring

Examples related to spring-boot

Examples related to h2

Examples related to spring-jdbc