H2 db not accessible at localhost:8080/h2-console when using webflux

Question

H2 db is not accessible at localhost:8080/h2-console when using webflux. I read somewhere that this is available only when developing a Servlet based application. But I am using Webflux with Netty. So is there a way to see the h2 console in such an application?

Answer 1

I had the same issue, I ended up booting the console server manually on another port:

@Component
@Profile("test") // <-- up to you
public class H2 {

    private org.h2.tools.Server webServer;

    private org.h2.tools.Server tcpServer;

    @EventListener(org.springframework.context.event.ContextRefreshedEvent.class)
    public void start() throws java.sql.SQLException {
        this.webServer = org.h2.tools.Server.createWebServer("-webPort", "8082", "-tcpAllowOthers").start();
        this.tcpServer = org.h2.tools.Server.createTcpServer("-tcpPort", "9092", "-tcpAllowOthers").start();
    }

    @EventListener(org.springframework.context.event.ContextClosedEvent.class)
    public void stop() {
        this.tcpServer.stop();
        this.webServer.stop();
    }

}

Then navigate to http://localhost:8082 (without /h2-console).

Answer 2

I found a library that does exactly the same sp00m described, it may be helpful for somebody. It works out of the box.

https://mvnrepository.com/artifact/me.yaman.can/spring-boot-webflux-h2-console

And github page: https://github.com/canyaman/spring-boot-webflux-h2-console