spring boot cant connect spring boot to postgresql database

Question

I am trying to connect Spring Boot back-end to PostgreSQL but get this error

***************************
APPLICATION FAILED TO START
***************************
Description:

Parameter 0 of constructor in 
org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaAutoConfiguration 
required a bean of type 'javax.sql.DataSource' that could not be found.
- Bean method 'dataSource' not loaded because @ConditionalOnProperty 
(spring.datasource.jndi-name) did not find property 'jndi-name'
- Bean method 'dataSource' not loaded because @ConditionalOnBean (types: 
org.springframework.boot.jta.XADataSourceWrapper; SearchStrategy: all) did 
not find any beans


Action:

Consider revisiting the conditions above or defining a bean of type 
'javax.sql.DataSource' in your configuration.

I have been struggling with this error for 2 days till this moment

I have these dependencies in my pom.xml

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

    <dependency>
        <groupId>org.postgresql</groupId>
        <artifactId>postgresql</artifactId>
        <version>9.4-1206-jdbc42</version>
    </dependency>

and this is my application.yml

spring:
 jpa:
  database: POSTGRESQL
  show-sql: true
  hibernate:
    ddl-auto: create-drop
 datasource:
  platform: postgres
  url: jdbc:postgresql://localhost:5432/H4E
  username: postgres
  password: 123456

I am using PostgreSQL 10 with pgAdmin 3 LTS

Try adding a connection pool like Apache DBCP2 as a dependency in your POM, I think it should already come with one in the dependencies of the JPA starter but maybe they changed that. — Nyamiou The Galeanthrope
– Nyamiou The Galeanthrope, Commented Feb 28, 2018 at 18:34
looks like issue with with your package strcture. Can you please share package tree diagram? — Vinay Prajapati
– Vinay Prajapati, Commented Feb 28, 2018 at 18:52
change postgresql JDBC driver version. Try to use 42.2.1 instead of 9.4-1206-jdbc42. — naXa stands with Ukraine
– naXa stands with Ukraine, Commented Feb 28, 2018 at 18:56
also (just in case) append quotes to your DB connection string url: "jdbc:postgresql://localhost:5432/H4E" — naXa stands with Ukraine
– naXa stands with Ukraine, Commented Feb 28, 2018 at 19:03

naXa stands with Ukraine · Accepted Answer · 2018-02-28 19:12:16Z

2

Add driverClassName property under the spring.datasource. You should get something like this

spring:
    jpa:
        database: POSTGRESQL
        show-sql: true
        hibernate:
            ddl-auto: create-drop
    datasource:
        platform: postgres
        url: "jdbc:postgresql://localhost:5432/H4E"
        username: postgres
        password: 123456
        driverClassName: org.postgresql.Driver

answered Feb 28, 2018 at 19:12

naXa stands with Ukraine

38.6k25 gold badges208 silver badges279 bronze badges

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

Collectives™ on Stack Overflow

spring boot cant connect spring boot to postgresql database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related