声明:本文纯属个人随手笔记,如果对您有参考价值我十分开心,如果有存在错误,或者有更好的解决办法也麻烦您留言告诉我,大家共同成长,切勿恶言相。 欢迎加入资源共享QQ群:275343679,一起发现知识、了解知识、学习知识、分享知识。
个人网站:www.itlantian.top www.blueskyui.cn
=========================================================================================================
C3P0是一个开源的JDBC连接池,在spring中,C3P0的一些配置信息:
-
- <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
-
- <property name="user" value="${username}"/>
-
- <property name="password" value="${password}"/>
- <property name="driverClass" value="${driver_class}"/>
- <property name="jdbcUrl" value="${url}"/>
-
-
- <property name="maxPoolSize" value="20"/>
-
- <property name="minPoolSize" value="2"/>
-
- <property name="initialPoolSize" value="2"/>
-
-
- <property name="maxIdleTime">60</property>
-
-
- <property name="checkoutTimeout" value="3000"/>
-
-
- <property name="acquireIncrement" value="2"/>
-
-
- <property name="acquireRetryAttempts" value="0"/>
-
-
- <property name="acquireRetryDelay" value="1000" />
-
-
- <property name="autoCommitOnClose">false</property>
-
-
- <property name="automaticTestTable">Test</property>
-
-
- <property name="breakAfterAcquireFailure">false</property>
-
-
- <property name="idleConnectionTestPeriod">60</property>
-
- <property name="maxStatements">100</property>
-
- <property name="maxStatementsPerConnection"></property>
- </bean>