After Spring Boot 2.0 migration: jdbcUrl is required with driverClassName

by

As this post gets a bit of popularity I edited it a bit.
Spring Boot 2.x.x changed default JDBC connection pool from Tomcat to faster and better HikariCP. Here comes incompatibility, because HikariCP uses different property of jdbc url. There are two ways how to handle it:

OPTION ONE

There is very good explanation and workaround in spring docs:

Also, if you happen to have Hikari on the classpath, this basic setup does not work, because Hikari has no url property (but does have a jdbcUrl property). In that case, you must rewrite your configuration as follows:

app.datasource.jdbc-url=jdbc:mysql://localhost/test
app.datasource.username=dbuser
app.datasource.password=dbpass

OPTION TWO

There is also how-to in the docs how to get it working from “both worlds”. It would look like below. ConfigurationProperties bean would do “conversion” for jdbcUrl from app.datasource.url

@Configuration
public class DatabaseConfig {
    @Bean
    @ConfigurationProperties("app.datasource")
    public DataSourceProperties dataSourceProperties() {
        return new DataSourceProperties();
    }

    @Bean
    @ConfigurationProperties("app.datasource")
    public HikariDataSource dataSource(DataSourceProperties properties) {
        return properties.initializeDataSourceBuilder().type(HikariDataSource.class)
                .build();
    }
}

More Related Contents:

  1. Spring Boot Configure and Use Two DataSources
  2. Filter invoke twice when register as Spring bean
  3. Spring Boot, Spring Data JPA with multiple DataSources
  4. How can I log SQL statements in Spring Boot?
  5. Difference between @Mock, @MockBean and Mockito.mock()
  6. Spring Boot Adding Http Request Interceptors
  7. POSTing a @OneToMany sub-resource association in Spring Data REST
  8. Java Spring Boot: How to map my app root (“/”) to index.html?
  9. Spring boot @ResponseBody doesn’t serialize entity id
  10. Read file from resources folder in Spring Boot
  11. Filter order in spring-boot
  12. No serializer found for class org.hibernate.proxy.pojo.bytebuddy.ByteBuddyInterceptor
  13. How to disable ‘X-Frame-Options’ response header in Spring Security?
  14. Spring-Boot: How do I set JDBC pool properties like maximum number of connections?
  15. Spring Boot: Unable to start EmbeddedWebApplicationContext due to missing EmbeddedServletContainerFactory bean
  16. While using Spring Data Rest after migrating an app to Spring Boot, I have observed that entity properties with @Id are no longer marshalled to JSON
  17. How to reinitialize a Spring Bean?
  18. Websocket Authentication and Authorization in Spring
  19. Hot swapping in Spring Boot
  20. java.lang.IllegalArgumentException: No converter found for return value of type
  21. Configuration using annotation @SpringBootApplication
  22. Spring-boot: required a bean named ‘entityManagerFactory’ that could not be found
  23. How to re-create database before each test in Spring?
  24. Table ‘DBNAME.hibernate_sequence’ doesn’t exist
  25. Spring’s @RequestParam with Enum
  26. How do you configure Embedded MongDB for integration testing in a Spring Boot application?
  27. Programmatically restart Spring Boot application / Refresh Spring Context
  28. What does Cookie CsrfTokenRepository.withHttpOnlyFalse () do and when to use it?
  29. Externalize query in spring boot application
  30. disabling spring security in spring boot app [duplicate]

Leave a Comment