使用HikariDataSource的Springboot

Question

我尝试将Spring Boot与HikariDataSource配合使用，但出现了错误。断管怎么配置比较好还是用c3p0比较好？我正在使用这个配置

spring.jpa.properties.hibernate.enable_lazy_load_no_trans=true
spring.datasource.type=com.zaxxer.hikari.HikariDataSource
spring.datasource.maxLifetime=200000
spring.datasource.idleTimeout=200000
spring.jpa.database=POSTGRESQL
spring.datasource.maximumPoolSize=5
spring.datasource.maxActive=5
spring.datasource.platform=postgres
spring.jpa.show-sql=false
spring.jpa.database-platform=org.hibernate.dialect.PostgreSQLDialect
spring.datasource.driver-class-name=org.postgresql.Driver
#spring.datasource.url=jdbc:postgresql://localhost:5432/db_dnaso
spring.datasource.url=jdbc:postgresql://172.16.1.10:5432/db_dnaso
#spring.datasource.url=jdbc:postgresql://ci.lumera.com.br:5432/db_dnaso
spring.datasource.username=postgres
spring.datasource.password=dna44100

我使用：

<dependency>
            <groupId>com.zaxxer</groupId>
            <artifactId>HikariCP</artifactId>
            <version>2.5.1</version>
        </dependency>

和 springboot 版本 1.4.2.RELEASE

Answer 1

尝试使用此配置来定义数据源

 @Configuration
@EnableTransactionManagement
@EnableJpaRepositories(
        entityManagerFactoryRef = "eaEntityManagerFactory",
        transactionManagerRef = "eaTransactionManager",
        basePackages = {"com.core.persistance.xx" 
            
                 })
public class EaDbConfig {

    @Bean(name = "eaDataSourceProperties")
    @ConfigurationProperties("spring.datasource-ea")
    public DataSourceProperties eaDataSourceProperties() {
        return new DataSourceProperties();
    }

    @Bean(name = "eaDataSource")
    @ConfigurationProperties("spring.datasource-ea.configuration")
    public DataSource eaDataSource(@Qualifier("eaDataSourceProperties") DataSourceProperties eaDataSourceProperties) {
        return eaDataSourceProperties.initializeDataSourceBuilder().type(HikariDataSource.class).build();
    }

    @Bean(name = "eaEntityManagerFactory")
    public LocalContainerEntityManagerFactoryBean eaEntityManagerFactory(
            EntityManagerFactoryBuilder eaEntityManagerFactoryBuilder, @Qualifier("eaDataSource") DataSource eaDataSource) {

        Map<String, String> eaJpaProperties = new HashMap<>();
    /*    eaJpaProperties.put("hibernate.dialect", "org.hibernate.dialect.H2Dialect");
        eaJpaProperties.put("hibernate.hbm2ddl.auto", "create-drop");*/

        return eaEntityManagerFactoryBuilder
                .dataSource(eaDataSource)
                .packages("com.core.persistance.xx.domain"
                         
                         )
                .persistenceUnit("eaDataSource")
                .properties(eaJpaProperties)
                .build();
    }

    @Bean(name = "eaTransactionManager")
    public PlatformTransactionManager eaTransactionManager(
            @Qualifier("eaEntityManagerFactory") EntityManagerFactory eaEntityManagerFactory) {

        return new JpaTransactionManager(eaEntityManagerFactory);
    }
}

---------------
config properties :
#  source configuration

 - spring.datasource-ea.url=url
 - spring.datasource-ea.username=username
 - spring.datasource-ea.password=password
 - spring.datasource-ea.driverClassName=oracle.jdbc.OracleDriver

Answer 2

尝试将@bean添加到配置类中。

@Bean(name = "hikariDataSource")
@Qualifier("hikariDataSource")
@ConfigurationProperties(prefix = "spring.datasource.hikari")
public DataSource hikariDataSource() {
    log.info("Building hikariDataSource......");
    return DataSourceBuilder.create().type(com.zaxxer.hikari.HikariDataSource.class).build();
}

以及配置属性文件。

spring.datasource.hikari.jdbc-url=jdbc:mysql://127.0.0.1:3306/test
spring.datasource.hikari.username=root
spring.datasource.hikari.password=root
spring.datasource.hikari.driver-class-name=com.mysql.jdbc.Driver