c3p0连接池的配置
c3p0连接池配置其实主要就是c3p0-config.xml文件的配置,以及c3p0的jar包的导入。
*配置c3p0-config.xml文件要注意两点:
1.配置文件的命名一定不能改变,只能是“c3p0-config.xml”。
2.配置文件的存放位置只能在工程的src目录下。
c3p0-config.xml代码如下:
<span style="font-size:18px;"><?xml version="1.0" encoding="UTF-8" ?>
<c3p0-config>
<default-config>
<property name="jdbcUrl">jdbc:oracle:thin:@127.0.0.1:1521:ORCL</property>
<property name="driverClass">oracle.jdbc.driver.OracleDriver</property>
<property name="user">【替换内容:用户名】</property>
<property name="password">【替换内容:密码】</property>
<property name="acquireIncrement">1</property>
<property name="initialPoolSize">1</property>
<property name="minPoolSize">1</property>
<property name="maxPoolSize">5</property>
<property name="maxIdleTime">120</property>
<property name="acquireRetryAttempts">5</property>
<property name="maxStatements">0</property>
<property name="acquireRetryAttempts">10</property>
<property name="checkoutTimeout">10000</property>
</default-config>
</c3p0-config></span>
配置好文件后,测试一下配置文件是否有效:
<span style="font-size:18px;">package c3poTest;
import java.sql.Connection;
import java.sql.SQLException;
import com.mchange.v2.c3p0.ComboPooledDataSource;
public class Test {
public static void main(String[] args) throws SQLException {
ComboPooledDataSource cpds = new ComboPooledDataSource();
Connection conn = cpds.getConnection();
System.out.println(conn);
conn.close();
}
}</span>