配置proxool连接池的步骤:
1、创建一个proxool.xml文件在web-inf下面:
内容为:
<?xml version="1.0" encoding="ISO-8859-1"?>
<something-else-entirely>
<proxool>
<alias>proxool</alias>
<driver-url>jdbc:oracle:thin:@219.232.241.14:1521:test</driver-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver-properties>
<property name="user" value="test" />
<property name="password" value="test" />
</driver-properties>
<house-keeping-sleep-time>90000</house-keeping-sleep-time>
<maximum-new-connections>50</maximum-new-connections>
<prototype-count>3</prototype-count>
<proxool.simultaneous-build-throttle>200</proxool.simultaneous-build-throttle>
<house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
<maximum-connection-count>200</maximum-connection-count>
<minimum-connection-count>20</minimum-connection-count>
</proxool>
</something-else-entirely>
说明:
(1)<alias>proxool</alias>这句是为文件起的别名,在程序中访问就是proxool.[color=red]proxool[/color],红色的后缀名就是起的别名。
(2)<load-on-startup>1</load-on-startup>志servlet加载顺序。中的值越小加载越早
2、在web.xml初始化
<servlet>
<servlet-name>ServletConfigurator</servlet-name>
<servlet-class> org.logicalcobwebs.proxool.configuration.ServletConfigurator
</servlet-class>
<init-param>
<param-name>xmlFile</param-name>
<param-value>WEB-INF/proxool.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
3、在程序中使用
public Connection getCon() {
logger.info("使用proxool连接池。。。");
Connection conn = null;
try {
Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
conn = DriverManager.getConnection("proxool.proxool");
} catch (Exception e) {
logger.error("", e);
}
return conn;
}
1、创建一个proxool.xml文件在web-inf下面:
内容为:
<?xml version="1.0" encoding="ISO-8859-1"?>
<something-else-entirely>
<proxool>
<alias>proxool</alias>
<driver-url>jdbc:oracle:thin:@219.232.241.14:1521:test</driver-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver-properties>
<property name="user" value="test" />
<property name="password" value="test" />
</driver-properties>
<house-keeping-sleep-time>90000</house-keeping-sleep-time>
<maximum-new-connections>50</maximum-new-connections>
<prototype-count>3</prototype-count>
<proxool.simultaneous-build-throttle>200</proxool.simultaneous-build-throttle>
<house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
<maximum-connection-count>200</maximum-connection-count>
<minimum-connection-count>20</minimum-connection-count>
</proxool>
</something-else-entirely>
说明:
(1)<alias>proxool</alias>这句是为文件起的别名,在程序中访问就是proxool.[color=red]proxool[/color],红色的后缀名就是起的别名。
(2)<load-on-startup>1</load-on-startup>志servlet加载顺序。中的值越小加载越早
2、在web.xml初始化
<servlet>
<servlet-name>ServletConfigurator</servlet-name>
<servlet-class> org.logicalcobwebs.proxool.configuration.ServletConfigurator
</servlet-class>
<init-param>
<param-name>xmlFile</param-name>
<param-value>WEB-INF/proxool.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
3、在程序中使用
public Connection getCon() {
logger.info("使用proxool连接池。。。");
Connection conn = null;
try {
Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
conn = DriverManager.getConnection("proxool.proxool");
} catch (Exception e) {
logger.error("", e);
}
return conn;
}