Spring boot fails to load DataSource using PostgreSQL driver

Question

I have successfully developed a prototype using Spring Boot 1.0.2.RELEASE (was 1.0.1.RELEASE until today).

I have searched and searched and tried solutions like: Spring Boot jdbc datasource autoconfiguration fails on standalone tomcat Spring Boot / Spring Data import.sql doesn't run Spring-Boot-1.0.0.RC1

They all suggests to let Spring Boot do the job. When using H2, everything works, but when I try to switch to PostgreSQL, i get:

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaAutoConfiguration.class]: Instantiation of bean failed; nested exception is org.springframework.beans.factory.BeanDefinitionStoreException: Factory method [public org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean org.springframework.boot.autoconfigure.orm.jpa.JpaBaseConfiguration.entityManagerFactory(org.springframework.orm.jpa.JpaVendorAdapter)] threw exception; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type [javax.sql.DataSource] is defined

My build.gradle is as follow:

loadConfiguration()

def loadConfiguration() {
def environment = hasProperty('env') ? env : 'dev'
project.ext.envrionment = environment
println "Environment is set to $environment"

def configFile = file('config.groovy')
def config = new ConfigSlurper("$environment").parse(configFile.toURL())
project.ext.config = config
}

buildscript {
ext {
    springBootVersion = '1.0.2.RELEASE'
}
repositories {
    mavenCentral()
}
dependencies {
    classpath("org.springframework.boot:spring-boot-gradle-   plugin:${springBootVersion}")
}
}

apply plugin: 'java'
apply plugin: 'eclipse'
apply plugin: 'idea'
apply plugin: 'spring-boot'
apply plugin: 'war'
apply plugin: 'groovy'

war {
baseName = 'test'
version =  '0.0.1-SNAPSHOT'
}

configurations {
providedRuntime
}

repositories {
mavenCentral()
}

dependencies {
compile("org.springframework.boot:spring-boot-starter-web:${springBootVersion}")
compile("org.springframework.boot:spring-boot-starter-thymeleaf:${springBootVersion}")

compile("org.springframework.boot:spring-boot-starter-jdbc:${springBootVersion}")
compile("org.springframework.boot:spring-boot-starter-data-jpa:${springBootVersion}")
compile("postgresql:postgresql:9.1-901.jdbc4")
//compile("com.h2database:h2")

testCompile("org.springframework.boot:spring-boot-starter-test:${springBootVersion}")

}

task wrapper(type: Wrapper) {
gradleVersion = '1.11'
}

application.properties:

spring.jpa.database=POSTGRESQL
spring.jpa.show-sql=false
spring.jpa.hibernate.ddl-auto=update

spring.database.driverClassName=org.postgresql.Driver
spring.datasource.url=jdbc:postgresql://localhost/cms
spring.datasource.username=cms
spring.datasource.password=NA

Removing application.properties and changing the dependency back to H2 and everything is OK.

I can't find where I am doing wrong :-(

Dave Syer · Accepted Answer · 2014-04-25 08:57:38Z

53

Where did this come from: database.driverClassName=org.postgresql.Driver? Don't you mean spring.datasource.driverClassName?

edited Apr 25, 2014 at 8:57

answered Apr 25, 2014 at 8:38

Dave Syer

58.3k10 gold badges161 silver badges147 bronze badges

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

2 Comments

mamruoc Over a year ago

Absolutely. Copy-n-paste typo! Question updated. Thanks!

mamruoc Over a year ago

WHAT A TYPO MISTAKE! Ok, datasource and not database sigh

Jat Torres · Accepted Answer · 2021-05-07 03:32:50Z

21

spring.datasource.driver-class-name=org.postgresql.Driver

Make sure to reload your project if you recently just added postgres to your dependencies.

answered May 7, 2021 at 3:32

Jat Torres

3212 silver badges2 bronze badges

Comments

Vitalii Dmitriev · Accepted Answer · 2020-03-27 07:03:59Z

5

some time try re-import your mvn project if dependencies are not refreshed , also add following to your pom.xml

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

Or to your build.gradle

implementation "postgresql:postgresql:9.1-901.jdbc4"

edited Mar 27, 2020 at 7:03

Vitalii Dmitriev

8091 gold badge11 silver badges21 bronze badges

answered Jun 16, 2018 at 22:11

Pravin Bansal

4,7291 gold badge33 silver badges20 bronze badges

2 Comments

Markus Streicher Over a year ago

he has a gradle project!

theprogrammer Over a year ago

You can try this site to convert maven to gradle sagioto.github.io/maven2gradle

Dharman · Accepted Answer · 2021-12-29 12:31:58Z

1

I had a similar issue, that required me to check my pom.xml and I had left the H2 dep in, replacing it with

<dependency>
<groupId>org.postgresql</groupId>
<artifactId>postgresql</artifactId>
</dependency>

Seems to have fixed it for me.

edited Dec 29, 2021 at 12:31

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

answered Dec 29, 2021 at 12:26

Mike Glabay

212 bronze badges

Comments

Parameshwar · Accepted Answer · 2024-09-03 13:38:37Z

for me it was the dialect and the jpavendor configuration

import javax.persistence.EntityManagerFactory;
import javax.sql.DataSource;

import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.boot.orm.jpa.EntityManagerFactoryBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.data.jpa.repository.config.EnableJpaRepositories;
import org.springframework.orm.jpa.JpaTransactionManager;
import org.springframework.orm.jpa.JpaVendorAdapter;
import org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean;
import org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;

@Configuration
@EnableTransactionManagement
@EnableJpaRepositories(
    basePackages = "com.xyz.Inquery.db.repo.oracle",
    entityManagerFactoryRef = "oracleEntityManagerFactory",
    transactionManagerRef = "oracleTransactionManager"
)
public class OracleConfig {

    @Bean(name = "oracleDataSource")
    @ConfigurationProperties(prefix = "spring.datasource.oracle")
    public DataSource dataSource() {
        return DataSourceBuilder.create().build();
    }

    @Bean(name = "oracleEntityManagerFactory")
    public LocalContainerEntityManagerFactoryBean entityManagerFactory(
            EntityManagerFactoryBuilder builder,
            @Qualifier("oracleDataSource") DataSource dataSource) {
        LocalContainerEntityManagerFactoryBean em = builder
                .dataSource(dataSource)
                .packages("com.xyz.Inquery.oracle.entity")
                .persistenceUnit("oracle")
                .build();
        
        // Customize the JpaVendorAdapter
        em.setJpaVendorAdapter(jpaVendorAdapter());
        
        return em;
    }

    @Bean
    public JpaVendorAdapter jpaVendorAdapter() {
        HibernateJpaVendorAdapter adapter = new HibernateJpaVendorAdapter();
        adapter.setShowSql(true); // Set to true to log SQL queries
        adapter.setGenerateDdl(true); // Set to true to generate DDL statements
        adapter.setDatabasePlatform("org.hibernate.dialect.Oracle10gDialect"); // Specify the correct dialect this helped me
        return adapter;
    }

    @Bean(name = "oracleTransactionManager")
    public PlatformTransactionManager transactionManager(
            @Qualifier("oracleEntityManagerFactory") EntityManagerFactory entityManagerFactory) {
        return new JpaTransactionManager(entityManagerFactory);
    }
}

and the postgres as

import javax.persistence.EntityManagerFactory;
import javax.sql.DataSource;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.boot.orm.jpa.EntityManagerFactoryBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.data.jpa.repository.config.EnableJpaRepositories;
import org.springframework.orm.jpa.JpaTransactionManager;
import org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;

@Configuration
@EnableTransactionManagement
@EnableJpaRepositories(
    basePackages = "com.xyz.Inquery.db.repo.postgres",
    entityManagerFactoryRef = "postgresEntityManagerFactory",
    transactionManagerRef = "postgresTransactionManager"
)
public class PostgresConfig {

    @Primary
    @Bean(name = "postgresDataSource")
    @ConfigurationProperties(prefix = "spring.datasource.postgres")
    public DataSource dataSource() {
        return DataSourceBuilder.create().build();
    }

    @Primary
    @Bean(name = "postgresEntityManagerFactory")
    public LocalContainerEntityManagerFactoryBean entityManagerFactory(
            EntityManagerFactoryBuilder builder,
            @Qualifier("postgresDataSource") DataSource dataSource) {
        return builder
                .dataSource(dataSource)
                .packages("com.xyz.Inquery.postgres.entity")
                .persistenceUnit("postgres")
                .build();
    }

    @Primary
    @Bean(name = "postgresTransactionManager")
    public PlatformTransactionManager transactionManager(
            @Qualifier("postgresEntityManagerFactory") EntityManagerFactory entityManagerFactory) {
        return new JpaTransactionManager(entityManagerFactory);
    }
}

earlier i had missed out the em.setJpaVendorAdapter(jpaVendorAdapter()); part and the setDatabasePlatform part

finally my pom dependency looks like as below :

<dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-tomcat</artifactId>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <!-- Spring Boot Starter Web -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <!-- Spring Boot Starter Data JPA -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>

        <!-- PostgreSQL Driver -->
        <dependency>
            <groupId>org.postgresql</groupId>
            <artifactId>postgresql</artifactId>
        </dependency>
        <dependency>
            <groupId>com.oracle</groupId>
            <artifactId>ojdbc8</artifactId>
            <version>12.2.0.1.0</version>
       </dependency>

    </dependencies>

with application prop as following

spring.datasource.postgres.url=jdbc:postgresql://xyz/nsdl_insta_dmat
spring.datasource.postgres.username=abc
spring.datasource.postgres.password=abc
spring.datasource.postgres.driver-class-name=org.postgresql.Driver
spring.datasource.postgres.remove-abandoned=true
spring.datasource.postgres.initialSize=20
spring.datasource.postgres.maxActive=20

#oracle configuration
spring.datasource.oracle.jdbcUrl=jdbc:oracle:thin:@ip:port/AGG
spring.datasource.oracle.url=jdbc:oracle:thin:@ip:port/AGG
spring.datasource.oracle.username=avg
spring.datasource.oracle.password=abc
spring.datasource.oracle.driver-class-name=oracle.jdbc.OracleDriver
spring.datasource.oracle.default-schema=yourwish

I realized without configuring jpavendor it was throwing exception of jdbcurl. Hope this might help someone.

Thank you for this solution. But I have to mention that I had to declare spring.datasource.postgres.jdbcUrl too. Otherwise I was getting: Failed to instantiate [org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean]: Factory method 'entityManagerFactory' threw exception with message: jdbcUrl is required with driverClassName.

jumping_monkey · Accepted Answer · 2020-06-27 05:10:00Z

0

I have this in my build.gradle:

implementation 'org.postgresql:postgresql:version-number'

but, no matter what i did, the jar was never downloaded.

As a work-around, i downloaded the jar from here(Clicked on Jar(...)), and added it in my Java Build Path - Libraries manually. Not ideal, but that's the only thing that works in 2 minutes!

answered Jun 27, 2020 at 5:10

jumping_monkey

8,1152 gold badges60 silver badges75 bronze badges

Comments

FoldFence · Accepted Answer · 2022-12-27 14:01:06Z

0

I just came over this thread but it doesent helped me, for me the problem was also in a false configured pom.xml, I just had to add JPA:

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

Hope that Helps!

answered Dec 27, 2022 at 14:01

FoldFence

2,8005 gold badges36 silver badges58 bronze badges

Comments

Shrinivasa Uppunda · Accepted Answer · 2023-02-02 16:19:41Z

0

I have encountered this issue when our project migrated to Java 17 and gradle 7.5

below steps I have followed to resolve the issue.

gradle import upgraded to : implementation 'org.postgresql:postgresql:42.2.27'

then clean build the project: ./gradlew clean build then ./gradlew bootRun

solved the issue.

answered Feb 2, 2023 at 16:19

Shrinivasa Uppunda

1031 silver badge7 bronze badges

Comments

Shreyansh Jain · Accepted Answer · 2023-04-03 23:49:19Z

0

For anyone landing here while looking for plain JDBC solution:

Use jdbc:postgresql://localhost:5432/myDatabase?currentSchema=mySchema

The following works when using Hibernate as JPA provider: spring.jpa.properties.hibernate.default_schema=mySchema

answered Apr 3, 2023 at 23:49

Shreyansh Jain

4451 gold badge6 silver badges14 bronze badges

Comments

Markus W Mahlberg · Accepted Answer · 2024-05-05 00:07:13Z

0

For me it was:

spring.datasource.url=jdbc:postgresql//server/port/database?currentSchema=myschema
spring.jpa.properties.hibernate.default_schema=myschema

edited May 5, 2024 at 0:07

Markus W Mahlberg

21k6 gold badges70 silver badges97 bronze badges

answered May 3, 2024 at 9:19

Sifiso Mkoko

1

Collectives™ on Stack Overflow

Spring boot fails to load DataSource using PostgreSQL driver

10 Answers 10

2 Comments

Comments

2 Comments

Comments

1 Comment

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

10 Answers 10

2 Comments

Comments

2 Comments

Comments

1 Comment

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related