Java Spring-boot and in memory db H2. db not in h2 web console

Question

This is my embedded database:

   public void init() {
      EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder();
      db = builder
            .setType(EmbeddedDatabaseType.H2)
            .addScript("h2/create.sql")
            .addScript("h2/insert.sql")
            .build();
    }

When I launch JUnit tests, I don't see in web console, the db that was created during application context intialization.

@Before
public void initTest() throws SQLException {
    Server webServer = Server.createWebServer("-web", "-webAllowOthers", "-webPort", "8082");
    webServer.start();
}

What's wrong?

Did you try this? spring.h2.console.enabled=true

Habil
– Habil

2019-03-05 15:32:14 +00:00
Commented Mar 5, 2019 at 15:32 — Habil
– Habil, Commented Mar 5, 2019 at 15:32

Mikhail Kholodkov · Accepted Answer · 2019-03-05 16:23:43Z

1

Please refer: https://docs.spring.io/spring-boot/docs/current/reference/html/boot-features-sql.html#boot-features-sql-h2-console

You might want to use the following properties:

spring.h2.console.enabled=true
spring.h2.console.path=/path/to/console

Or start server programmatically:

@Bean
public ServletRegistrationBean h2servletRegistration() {
    ServletRegistrationBean registration = new ServletRegistrationBean(new WebServlet());
    registration.addUrlMappings("/console/*");
    registration.addInitParameter("webAllowOthers", "true");
    return registration;
}

answered Mar 5, 2019 at 16:23

Mikhail Kholodkov

25.4k17 gold badges64 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Java Spring-boot and in memory db H2. db not in h2 web console

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related