new ComboPooledDataSource("c3p0-config.xml");
new ComboPooledDataSource();
都无效。
C3P0配置文件应该没有问题,也列在下面吧:
<c3p0-config>
<default-config>
<property name="driverClass">com.mysql.jdbc.Driver</property>
<property name="jdbcUrl">jdbc:mysql://192.168.0.254:3306/work1</property>
<property name="initialPoolSize">10</property>
<property name="maxPoolSize">20</property>
<property name="minPoolSize">10</property>
<property name="acquireIncrement">10</property>
<property name="checkoutTimeout">3000</property>
<property name="maxStatements">100</property>
<property name="autoCommitOnClose">true</property>
<property name="maxStatementsPerConnection">20</property>
<property name="numHelperThreads">8</property>
<property name="acquireRetryAttempts">10</property>
<property name="acquireRetryDelay">3000</property>
<property name="testConnectionOnCheckin">true</property>
<property name="preferredTestQuery">SELECT 1</property>
<property name="idleConnectionTestPeriod">6000</property>
<property name="maxIdleTime">7000</property>
<property name="maxAdministrativeTaskTime">300</property>
</default-config>
</c3p0-config>