Spring boot 2 does not work with Postgres

Question

I have a Spring Boot JPA application with spring boot 2.0.3.RELEASE and connects to PostgreSQL, when i run the application i get the error message below:

Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured.
Reason: Failed to determine a suitable driver class

Database connection properties:

spring:
  datasource:
    url: jdbc:postgresql://localhost:5432/testS
    username: postgres
    password: postgres123
    driver-class-name: org.postgresql.Driver

Dependencies:

    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-jpa</artifactId>
    </dependency>
    <dependency>
        <groupId>org.postgresql</groupId>
        <artifactId>postgresql</artifactId>
    </dependency>

Stacktrace:

Caused by: org.springframework.boot.autoconfigure.jdbc.DataSourceProperties$DataSourceBeanCreationException: Failed to determine a suitable driver class

How can I solve this problem?

try using attribute inside datasource: `dataSourceClassName=org.postgresql.ds.PGSimpleDataSource` — Ori Marko, Jun 17 '18 at 12:18
Take a look at this post: https://stackoverflow.com/a/33324144/967808 — Thiru, Jun 17 '18 at 12:41
The error message `Failed to configure a DataSource: 'url' attribute is not specified` indicates that your `application.yml` file isn't read at all — Markus Pscheidt, Jun 18 '18 at 10:26

score 0 · Answer 1 · answered Jun 17 '18 at 12:27

0

You just changed the dependency as below. Include version and scope element in dependency.

<dependency>
    <groupId>postgresql</groupId>
    <artifactId>postgresql</artifactId>
    <version>9.1-901.jdbc4</version>
    <scope>runtime</scope>
</dependency>

answered Jun 17 '18 at 12:27

Gaurav Srivastav

2,381
1
15
18

it still the same problem – Aymen Kanzari Jun 17 '18 at 12:44
What your's postgres version, jar should be compatible to it. One more thing check is the dependency download or not. – Gaurav Srivastav Jun 17 '18 at 12:46

score 0 · Answer 2 · answered Sep 20 '18 at 14:04

I had this problem when using spring profiles in my application.yml. I only defined the spring.datasource.* properties in the profile's section of the yaml. However, when I moved those properties to the MAIN section (i.e. the default profile), the problem disappeared.

Spring boot 2 does not work with Postgres

2 Answers2