How do I enable h2 console in application.yml for SpringBoot?

spring boot jpa + h2 example
spring boot h2 database example mkyong
h2 in-memory database spring example
spring boot h2 console not working
spring boot h2 create schema
spring boot h2 unit test
spring boot h2 database crud example
h2 console localhost refused to connect

I have an application.yml file where I want to enable h2-console but on searching over google I got results only for application.properties file. Can anyone help?

You can use below configuration.

spring:
  h2:
    console:
      enabled: true
      path: /h2-console

Refer this for more : https://github.com/khoubyari/spring-boot-rest-example/blob/master/src/main/resources/application.yml

AND

https://docs.spring.io/spring-boot/docs/current-SNAPSHOT/reference/htmlsingle/#boot-features-sql-h2-console

By default, the H2 console is not enabled in Spring. So to enable it, we need to add the following property to application.properties: ? 1. To enable access to the H2 database console under Spring Security you need to change three things: Allow all access to the url path /console/*. Disable CRSF (Cross-Site Request Forgery). By

you need to use this structure

###
#   H2 Settings
###
  h2:
    console:
      enabled: true
      path: /console
      settings:
        trace: false
        web-allow-others: false

Accessing H2 console. Start the spring boot application and access the console in browser with URL : http://localhost:8080/h2 . We can see the console like this. Now enter the configured username and password. Spring Boot will automatically pick up the data.sql and run it against our configured H2 database during application startup. This is a good way to seed the database for testing or other purposes. This is a good way to seed the database for testing or other purposes.

for properties and yml use the following (application.yml)

spring:
 h2:
    console:
      enabled: true

(application.properties)

   spring.h2.console.enabled = true

If you've enabled Spring Security in your Spring Boot application, you will not be able to access the H2 database console. With its default settings  To enable access to the H2 database console under Spring Security you need to change three things: Allow all access to the url path /console/*. Disable CRSF (Cross-Site Request Forgery). By default, Spring Security will protect against CRSF attacks.

In the application.properties file, add the below line to enable the H2 database: # H2. spring.h2.console.enabled=true. spring.h2.console.path=/  How to use H2 embeded database in spring application. H2, as a embeded memory database, is mainly used for development and test phase. H2 also has a web console which is very convenient. 1. Use H2 in Spring boot application. Spring boot has almost everything done for you. You need to do 2 steps, first inluce H2 in you pom.xml. 1. 2.

Recall that we did enable the H2 console in the application. properties file. You may see different value in the JDBC URL so change the Database URL to jdbc:h2:mem:testdb in the login screen as this is the default URL configured by Spring Boot. In this tutorial, we will be integrating the H2 database in your Spring Boot application. Note that the H2 database is in the embedded mode. You have created a Spring Boot application and would

Spring Boot and H2 Magic​​ Let's enable h2 console in the application. properties. When you start the application up now, you would see a lot of magic unfold! When you reload the application, you can launch up H2 Console at http://localhost:8080/h2-console. 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.

Comments