Search code examples
javaspring-bootspring-securityin-memory-database

No able to login in h2-console using inline memory database

I am getting localhost not able to connect after trying to connect through inline db,i am passing correct username password.It was working fine before.Someone else faced this issue?

enter image description here

Solution

  • Try with the following configurations in the properties file.

    spring.datasource.url=jdbc:h2:mem:home
spring.h2.console.enabled=true
server.port=8082

    Check the application startup logs for h2 enable by spring.h2.console.enabled

    eg: H2 console available at '/h2-console'. Database available at 'jdbc:h2:mem:home'

    Open the url: http://localhost:8082/h2-console

    Verify the jdbc url, and correct it to as per mentioned in properties file and displayed in logs.

    jdbc:h2:mem:home

    Test connection.