SpringBoot DataSource configuration

Question

I'm trying to use the application.properties file to configure the datasource Spring Boot will have to use.

I've put the following properties inside :

spring.datasource.driverClassName=org.postgresql.Driver
spring.datasource.user=test
spring.datasource.password=test
spring.datasource.jdbcUrl=jdbc:postgresql://localhost:5432/test

The application.properties file is well used by other systems. But I can't get it to work for the automatic datasource configuration.

I'm still getting this Exception :

org.springframework.beans.factory.BeanCreationException: Cannot determine embedded database url for database type NONE.

The postgresql driver is included and loaded. And I can configure the datasource using a Configuration class, and the same parameters as above.

I've also added the @EnableAutoConfiguration and @EnableJpaRepositories to my Application.class.

Any clues?

Do you have one of the supported DataSource implementations on the classpath (e.g. Tomcat JDBC)? — Dave Syer
– Dave Syer, Commented Nov 27, 2014 at 17:35
Yes I have them. When I manually configure the datasource it works like a charm. — mrik974
– mrik974, Commented Nov 28, 2014 at 7:36

Andy Wilkinson · Accepted Answer · 2014-11-27 20:46:23Z

23

You should use spring.datasource.url to configure the JDBC URL rather than spring.datasource.jdbcUrl.

spring.datasource.jdbcUrl will work if the specific DataSource implementation that you're using has a setJdbcUrl method (HikariCP, for example) where as spring.datasource.url will work with any of the supported datasources.

Using spring.datasource.url also has the added benefit that you don't need to specify spring.datasource.driverClassName as it will be inferred from the url.

answered Nov 27, 2014 at 20:46

Andy Wilkinson

117k25 gold badges279 silver badges259 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

saran3h Over a year ago

Spring jpa 2+ uses hicari connection pool by default so this property doesn’t work anymore for pople who want to use a connection pool. Instead ‘spring.datasource.jdbc-url’ is the one which works.

Collectives™ on Stack Overflow

SpringBoot DataSource configuration

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related