Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
- <!-- access configuration -->
- <property name="driverClass" value="${jdbc.driverclass}" />
- <property name="jdbcUrl" value="${jdbc.url}" />
- <property name="user" value="${jdbc.username}" />
- <property name="password" value="${jdbc.password}" />
- <!-- pool sizing -->
- <property name="initialPoolSize" value="9" />
- <property name="minPoolSize" value="6" />
- <property name="maxPoolSize" value="30" />
- <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="3600" /> <!-- 1h - be careful with this! -->
- <!-- timeouts e testing -->
- <property name="checkoutTimeout" value="5000" /> <!-- 5s -->
- <property name="idleConnectionTestPeriod" value="60" /> <!-- 60 -->
- <property name="testConnectionOnCheckout" value="true" />
- <property name="preferredTestQuery" value="SELECT 1+1" />
- </bean>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement