Spring Boot default H2 jdbc connection (and H2 console)

by

This is how I got the H2 console working in spring-boot with H2. I am not sure if this is right but since no one else has offered a solution then I am going to suggest this is the best way to do it.

In my case, I chose a specific name for the database so that I would have something to enter when starting the H2 console (in this case, “AZ”). I think all of these are required though it seems like leaving out the spring.jpa.database-platform does not hurt anything.

In application.properties:

spring.datasource.url=jdbc:h2:mem:AZ;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE
spring.datasource.driverClassName=org.h2.Driver
spring.datasource.username=sa
spring.datasource.password=
spring.jpa.database-platform=org.hibernate.dialect.H2Dialect

In Application.java (or some configuration):

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

Then you can access the H2 console at {server}/console/. Enter this as the JDBC URL: jdbc:h2:mem:AZ

More Related Contents:

  1. Spring Boot and multiple external configuration files
  2. Add context path to Spring Boot application
  3. Spring Boot – inject map from application.yml
  4. Java Spring Boot: How to map my app root (“/”) to index.html?
  5. Unable to get spring boot to automatically create database schema
  6. Read file from resources folder in Spring Boot
  7. Filter order in spring-boot
  8. No serializer found for class org.hibernate.proxy.pojo.bytebuddy.ByteBuddyInterceptor
  9. Change database schema used by Spring Boot
  10. Mapping list in Yaml to list of objects in Spring Boot
  11. Spring Boot and custom 404 error page
  12. Multipart File upload Spring Boot
  13. NamedParameterJdbcTemplate vs JdbcTemplate
  14. Run Spring-boot’s main using IDE
  15. SpringBoot – BeanDefinitionOverrideException: Invalid bean definition
  16. Spring Boot Externalizing properties not working
  17. Spring Boot Actuator without Spring Boot
  18. Spring: overriding one application.property from command line
  19. Spring Boot application.properties value not populating
  20. Spring-boot: required a bean named ‘entityManagerFactory’ that could not be found
  21. How to set SameSite and Secure attribute to JSESSIONID cookie
  22. Securing Spring Boot API with API key and secret
  23. How set up Spring Boot to run HTTPS / HTTP ports
  24. Spring-Boot How to properly inject javax.validation.Validator
  25. How to log all active properties of a spring boot application before the beans instantiation?
  26. How to re-create database before each test in Spring?
  27. How do you configure Embedded MongDB for integration testing in a Spring Boot application?
  28. Programmatically restart Spring Boot application / Refresh Spring Context
  29. What does Cookie CsrfTokenRepository.withHttpOnlyFalse () do and when to use it?
  30. Externalize query in spring boot application

Leave a Comment