java.sql.SQLTransientConnectionException: spring HikariCP - Connection is not available, request timed out afte

Question

I've catched java.sql.SQLTransientConnectionException: springHikariCP - Connection is not available, request timed out after 30001ms.

First code block works well, second (CP) does not work.

What is wrong and how fix this?

JDK - 1.8.0_73.

HikariCP - 2.4.5.

Spring - 4.2.5.RELEASE.

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
   <property name="driverClassName" value="${connection.driverClassName}"/>
   <property name="username" value="${connection.userName}"/>
   <property name="password" value="${connection.password}"/>
   <property name="url" value="${connection.url}"/>
    </bean>

CP

   <bean id="hikariConfiguration" class="com.zaxxer.hikari.HikariConfig">
    <property name="poolName" value="springHikariCP"/>
    <property name="dataSourceClassName" value="${connection.dataSourceClassName}"/>
    <property name="maximumPoolSize" value="${connection.pool.maximumPoolSize}"/>
    <property name="idleTimeout" value="${connection.pool.idleTimeout}"/>
    <property name="dataSourceProperties">
   <props>
       <prop key="url">${connection.url}</prop>
       <prop key="user">${connection.userName}</prop>
       <prop key="password">${connection.password}</prop>
   </props>
  </property>
   </bean>
   <bean id="dataSource" class="com.zaxxer.hikari.HikariDataSource" destroy-  method="close">
  <constructor-arg ref="hikariConfiguration"/>
  </bean>
//...............
#CONNECTION
connection.dataSourceClassName=org.hsqldb.jdbc.JDBCDataSource
connection.url=jdbc:hsqldb:mem:dbtest-local
connection.userName=sa
connection.password=

#POOL
connection.pool.maximumPoolSize=1
connection.pool.idleTimeout=28500

#HIBERNATE
hibernate.hbm2ddl.auto=create-drop
hibernate.dialect=H2Dialect
hibernate.show_sql=true

In you HikariCP example you are setting the dataSourceClassName with the driverClassName. This may cause the problem? — ydemartino, Mar 24 '16 at 13:17
Sorry, fixed. Mentioned problem is for proper CP property call - dataSourceClassName. — Arthur, Mar 24 '16 at 13:25
Does [this answer](http://stackoverflow.com/questions/23369818/how-to-configure-hikari-cp-for-hsql-in-a-spring4-context) help? — brettw, Mar 24 '16 at 14:36

ydemartino · Answer 1 · 2016-03-24T16:21:08.350

1

If you use the dataSourceClassName, you should not provide the jdbc url.

Instead, you should add the host, dbname, etc. as properties. See the example on github:

dataSourceClassName=org.postgresql.ds.PGSimpleDataSource
dataSource.user=test
dataSource.password=test
dataSource.databaseName=mydb
dataSource.portNumber=5432
dataSource.serverName=localhost

Otherwise, you should not use the dataSourceClassName. Try with:

<bean id="hikariConfiguration" class="com.zaxxer.hikari.HikariConfig">
    <property name="poolName" value="springHikariCP" />
    <property name="maximumPoolSize" value="${connection.pool.maximumPoolSize}" />
    <property name="idleTimeout" value="${connection.pool.idleTimeout}" />
    <property name="jdbcUrl" value="${connection.url}" />
    <property name="dataSourceProperties">
        <props>
            <prop key="user">${connection.userName}</prop>
            <prop key="password">${connection.password}</prop>
        </props>
    </property>
</bean>

This is working for me in local.

edited Mar 24 '16 at 16:21

answered Mar 24 '16 at 13:33

ydemartino

242
5
10

No property portNumber for HSQL - exception. Without this property - same result - timeout. – Arthur Mar 24 '16 at 16:09
I edited my answer for an alternate way without dataSourceClassName, tell me if this works better – ydemartino Mar 24 '16 at 16:22
I think something is wrong on the part we cannot see, because I have been able to run a test project with this configuration – ydemartino Mar 24 '16 at 18:26
Yes with hsqldb 2.3.3 – ydemartino Mar 25 '16 at 08:07

java.sql.SQLTransientConnectionException: spring HikariCP - Connection is not available, request timed out afte

1 Answers1