How to set up datasource with Spring for HikariCP?

by

you need to write this structure on your bean configuration (this is your datasource):

<bean id="hikariConfig" class="com.zaxxer.hikari.HikariConfig">
    <property name="poolName" value="springHikariCP" />
    <property name="connectionTestQuery" value="SELECT 1" />
    <property name="dataSourceClassName" value="${hibernate.dataSourceClassName}" />
    <property name="maximumPoolSize" value="${hibernate.hikari.maximumPoolSize}" />
    <property name="idleTimeout" value="${hibernate.hikari.idleTimeout}" />

    <property name="dataSourceProperties">
        <props>
            <prop key="url">${dataSource.url}</prop>
            <prop key="user">${dataSource.username}</prop>
            <prop key="password">${dataSource.password}</prop>
        </props>
    </property>
</bean>

<!-- HikariCP configuration -->
<bean id="dataSource" class="com.zaxxer.hikari.HikariDataSource" destroy-method="close">
    <constructor-arg ref="hikariConfig" />
</bean>

This is my example and it is working. You just need to put your properties on hibernate.properties and set it before:

<bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
    <property name="locations">
        <list>
            <value>classpath:hibernate.properties</value>
        </list>
    </property>
</bean>

Obs.: the versions are
log4j: 1.2.16
springframework: 3.1.4.RELEASE
HikariCP: 1.4.0

Properties file (hibernate.properties):

hibernate.dataSourceClassName=oracle.jdbc.pool.OracleDataSource
hibernate.hikari.maximumPoolSize=10
hibernate.hikari.idleTimeout=30000
dataSource.url=jdbc:oracle:thin:@localhost:1521:xe
dataSource.username=admin
dataSource.password=

More Related Contents:

  1. NamedParameterJdbcTemplate vs JdbcTemplate
  2. How to execute IN() SQL queries with Spring’s JDBCTemplate effectively?
  3. Spring JDBC Template for calling Stored Procedures
  4. What does java:comp/env/ do?
  5. Spring Boot Remove Whitelabel Error Page
  6. Spring Boot Security CORS
  7. Handle spring security authentication exceptions with @ExceptionHandler
  8. How to pass an additional parameter with spring security login page
  9. Seeing the underlying SQL in the Spring JdbcTemplate?
  10. Spring Data optional parameter in query method
  11. How to test a spring controller method by using MockMvc?
  12. Hibernate Transactions and Concurrency Using attachDirty (saveOrUpdate)
  13. Spring injects dependencies in constructor without @Autowired annotation
  14. Spring Security configuration: HTTP 403 error
  15. How to set up Spring Security SecurityContextHolder strategy?
  16. Spring Batch: One reader, multiple processors and writers
  17. Process Spring Boot externalized property values
  18. Spring Expression Language (SpEL) with @Value: dollar vs. hash ($ vs. #)
  19. JSF View scope in Spring
  20. Spring’s overriding bean
  21. How to use Spring AbstractRoutingDataSource with dynamic datasources?
  22. HikariCP: What database level timeouts should be considered to set maxLifetime for Oracle 11g
  23. Spring: Difference of /** and /* with regards to paths
  24. Looking for a Simple Spring security example [closed]
  25. Spring MVC bean mapping to HTTP GET request parameters similar to @BeanParam
  26. Where to handle Exceptions in Spring Applications
  27. Where should I place my Vaadin 10+ static files?
  28. Is it possible to invalidate a spring security session?
  29. Unable to connect to Command Metric Stream. in Hystrix Dashboard issue
  30. How to add a custom health check in spring boot health?

Leave a Comment