c3p0---oracle连接池配置

原文链接：http://blog.163.com/yangchenhui21@126/blog/static/622862942007911494126/

 

<!--  c3p0连接池的配置 -->
 <bean id="dataSource"
  class="com.mchange.v2.c3p0.ComboPooledDataSource">
   <property name="driverClass"><value>oracle.jdbc.driver.OracleDriver</value></property>
         <property name="jdbcUrl"><value>jdbc:oracle:thin:@192.168.5.25:1521:表名</value></property>               
         <property name="user"><value>shinco</value></property>
         <property name="password"><value>shinco</value></property> 
         <property name="minPoolSize"><value>1</value></property>
         <property name="maxPoolSize"><value>50</value></property>
         <property name="maxIdleTime"><value>1800</value></property>
         <property name="acquireIncrement"><value>2</value></property>
         <property name="maxStatements"><value>0</value></property>
         <property name="initialPoolSize"><value>5</value></property>
         <property name="idleConnectionTestPeriod"><value>1800</value></property>
         <property name="acquireRetryAttempts"><value>30</value></property>
         <property name="breakAfterAcquireFailure"><value>true</value></property>
         <property name="testConnectionOnCheckout"><value>false</value></property>
 </bean>