<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"
"http://www.springframework.org/dtd/spring-beans.dtd">

<beans>
         <bean id="dataSource" class = "com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
       <property name="driverClass" value="org.postgresql.Driver"/>

        <property name="jdbcUrl" value="jdbc:postgresql://localhost:5432/test"/>

        <property name="user" value="postgres"/>
        <property name="password" value="postgres"/>
           <!-- pool sizing -->
    <property name="initialPoolSize" value="20" />
        <property name="minPoolSize" value="20" />
        <property name="maxPoolSize" value="200" />
        <property name="acquireIncrement" value="3" />
        <property name="maxStatements" value="0" />

        <!-- retries -->
        <property name="acquireRetryAttempts" value="30" />
        <property name="acquireRetryDelay" value="1000" /> <!-- 1s -->
        <property name="breakAfterAcquireFailure" value="false" />

        <!-- refreshing connections -->
        <property name="maxIdleTime" value="180" /> <!-- 3min -->
        <property name="maxConnectionAge" value="10" /> <!-- 1h -->

        <!-- timeouts and testing -->
        <property name="checkoutTimeout" value="30000" /> <!-- 30s -->
        <property name="idleConnectionTestPeriod" value="60" /> <!-- 60 -->
        <property name="testConnectionOnCheckout" value="true" />
        <property name="preferredTestQuery" value="SELECT 1" />
        <property name="testConnectionOnCheckin" value="true" />

    </bean>
</beans>

2017-11-29 13:07:41,367 WARN  [org.hibernate.util.JDBCExceptionReporter] (ajp-0.0.0.0-8010-107) SQL Error: 0, SQLState: null
2017-11-29 13:07:41,367 WARN  [org.hibernate.util.JDBCExceptionReporter] (ajp-0.0.0.0-8010-126) SQL Error: 0, SQLState: null
2017-11-29 13:07:41,367 WARN  [org.hibernate.util.JDBCExceptionReporter] (ajp-0.0.0.0-8010-76) SQL Error: 0, SQLState: null
2017-11-29 13:07:41,367 ERROR [org.hibernate.util.JDBCExceptionReporter] (ajp-0.0.0.0-8010-76) An attempt by a client to checkout a Connection has timed out.
2017-11-29 13:07:41,367 ERROR [org.hibernate.util.JDBCExceptionReporter] (ajp-0.0.0.0-8010-107) An attempt by a client to checkout a Connection has timed out.
2017-11-29 13:07:41,367 WARN  [org.hibernate.util.JDBCExceptionReporter] (ajp-0.0.0.0-8010-76) SQL Error: 0, SQLState: null
2017-11-29 13:07:41,368 ERROR [org.hibernate.util.JDBCExceptionReporter] (ajp-0.0.0.0-8010-76) An attempt by a client to checkout a Connection has timed out.
2017-11-29 13:07:41,367 ERROR [org.hibernate.util.JDBCExceptionReporter] (ajp-0.0.0.0-8010-126) An attempt by a client to checkout a Connection has timed out.
2017-11-29 13:07:41,368 WARN  [org.hibernate.util.JDBCExceptionReporter] (ajp-0.0.0.0-8010-4) SQL Error: 0, SQLState: null
2017-11-29 13:07:41,368 WARN  [org.hibernate.util.JDBCExceptionReporter] (ajp-0.0.0.0-8010-80) SQL Error: 0, SQLState: null
2017-11-29 13:07:41,368 ERROR [org.hibernate.util.JDBCExceptionReporter] (ajp-0.0.0.0-8010-80) An attempt by a client to checkout a Connection has timed out.
2017-11-29 13:07:41,368 WARN  [org.hibernate.util.JDBCExceptionReporter] (ajp-0.0.0.0-8010-46) SQL Error: 0, SQLState: null
2017-11-29 13:07:41,368 ERROR [org.hibernate.util.JDBCExceptionReporter] (ajp-0.0.0.0-8010-46) An attempt by a client to checkout a Connection has timed out.
2017-11-29 13:07:41,368 WARN  [org.hibernate.util.JDBCExceptionReporter] (ajp-0.0.0.0-8010-46) SQL Error: 0, SQLState: null