C3P0 connection pool configuration

<bean id="oracle.dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="driverClass" value="oracle.jdbc.driver.OracleDriver"></property> <property name="jdbcUrl" value="jdbc:oracle:thin:testdb"/> <property name="user" value="sa"/> <property name="password" value=""/> <property name="initialPoolSize" value="5"></property> <property name="minPoolSize" value="5"></property> <property name="maxPoolSize" value="15"/> <property name="checkoutTimeout" value="1000"/> <property name="preferredTestQuery" value="select 1 from dual"/> <property name="maxStatements" value="50"></property> <property name="testConnectionOnCheckin" value="true"></property> <property name="idleConnectionTestPeriod" value="60"></property> </bean>