第一种基于标签:
文件名:c3p0-config.xml
A:
<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config>
<default-config>
<property name="jdbcUrl">jdbc:oracle:thin:@192.168.11.210:1521:orcl</property>
<property name="driverClass">oracle.jdbc.driver.OracleDriver</property>
<property name="user">root</property>
<property name="password">root</property>
<property name="checkoutTimeout">30000</property>
<property name="idleConnectionTestPeriod">30</property>
<property name="initialPoolSize">10</property>
<property name="maxIdleTime">30</property>
<property name="maxPoolSize">100</property>
<property name="minPoolSize">10</property>
<property name="maxStatements">200</property>
</default-config>
</c3p0-config>
测试类:
public class Main {
@Test
public void A() throws Exception{
DataSource ds = new ComboPooledDataSource("c3p0-config.xml");
System.out.println(ds.getConnection());
}
}
B:
<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config>
<named-config name="helloc3p0">
<property name="jdbcUrl">jdbc:oracle:thin:@192.168.11.210:1521:orcl</property>
<property name="driverClass">oracle.jdbc.driver.OracleDriver</property>
<property name="user">project</property>
<property name="password">project</property>
<property name="initialPoolSize">5</property>
<property name="maxPoolSize">10</property>
<property name="minPoolSize">5</property>
</named-config>
</c3p0-config>
测试类:
public class Main {
@Test
public void A() throws Exception{
DataSource ds = new ComboPooledDataSource("helloc3p0");
System.out.println(ds.getConnection());
}
}
第二种基于文件:
文件名:c3p0-config.properties
c3p0.jdbcUrl=jdbc:oracle:@thin:192.168.11.210:1521/orcl
c3p0.driverClass=oracle.jdbc.driver.OracleDriver
c3p0.user=root
c3p0.password=root
c3p0.initialPoolSize=10
c3p0.maxPoolSize=20
c3p0.minPoolSize=5