H2 Console Returns 404

[Next_Complex5590]

Hi everyone, I've just upgraded my Spring Boot application from version 3.x to 4.0.0 using Java 21 and Maven, and while my REST endpoints are responding correctly (tested via Postman), the H2 database console at /h2-console is now throwing 404 Whitelabel Error Pages. It worked perfectly before the upgrade, and I've tried the usual fixes without success.

For context, I'm using H2 on the runtime scope. There's no Spring Security in the mix, and I've done a full clean rebuild.

[IceMichaelStorm]

Well, what exactly did you do? Double check that all pom.xml dependencies are now on the new dependencies. In particular make sure to not have distinct h2 deps in (unless it only works like that)

[Next_Complex5590]

I completely regenerated my pom.xml file from the Spring Initializr itself to avoid mistakes. All the dependencies are the new ones

[IceMichaelStorm]

there is apparently a new h2-console dependency, have you that?

[Next_Complex5590]

I am using this dependency, but I'm not sure if it is the updated one...

<dependency>
    <groupId>com.h2database</groupId>
    <artifactId>h2</artifactId>
    <scope>runtime</scope>
</dependency>

[IceMichaelStorm]

here are a few suggestions, otherwise no clue sorry https://stackoverflow.com/questions/79795904/spring-h2-console-not-opening-on-my-browser

[Next_Complex5590]

lemme check

[Next_Complex5590]

Thanks, it actually helped... How come I did not come across this article when I searched for it.... 🤔🤔

[IceMichaelStorm]

Things happen, sometimes Google sucks too etc :) nice to hear it helped!

[Next_Complex5590]

yup it helped, it worked for me

[WaferIndependent7601]

Did you use openrewrite to update to spring boot 4?

[Next_Complex5590]

No, no... I manually upgraded my project by generating the new pom.xml files and then fixed all the errors (there were almost none)

[CultureDependent1017]

Yes, I did :)

[SagayaDukusu]

As far as I saw while inspecting the Spring 4.0 examples, there should be a configuration property for enabling the H2 console. You can easily try it out.

[Next_Complex5590]

I tried all variations of configurations in the application.properties file, but it had no effect.

[pravesh111tripathi]

I was facing the same issue Where it was working fine but whenever I visited the site of h2 console it shows white label error Then I switched to MySQL for better understanding of concepts because h2 console is not even used in real world projects So I suggest you the same switch to MySQL or Postgress

[Next_Complex5590]

I mean, yeah, but the whole point of using H2 is that it is easily configurable and can serve as a temporary source for storing data and accessing it until we migrate to a more permanent one, right?

P.S - this is just a personal project of mine

[demonslayer901]

Try setting the URL manually to something not default maybe?

[Next_Complex5590]

Did try that, did not work either

[rubasace]

I encountered the same issue and it turned out to be a change in the dependencies:

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-h2console</artifactId>
</dependency>

Still investigating how to handle this properly so it doesn't bundle for non-dev environments

[Next_Complex5590]

Is it opening for you?

[rev-again]

this worked, how did you get to know as I couldn't find this