Proxool线程池JAVA调用范例

使用：proxool-0.9.1.zip

http://ncu.dl.sourceforge.net/project/proxool/proxool/0.9.1/proxool-0.9.1.zip

需要加入的jar如下：

代码如下：

package yerasel;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.ResultSetMetaData;import java.sql.Statement;import org.logicalcobwebs.proxool.configuration.JAXPConfigurator;public class Test {int beginIndex = 0;// 待取记录起始数int endIndex = 10; // 待取得记录终止跳String MySQLdbTableName = "usrpsw";String MySQLreq = "select * from " + MySQLdbTableName + " limit " + beginIndex + ", " + endIndex;/** * proxool方式测试 *  * @throws Exception */public void test2() throws Exception {// Java应用中先要加载配置文件，否则谁知道你配置给谁用的JAXPConfigurator.configure("proxool.xml", false);// 1：注册驱动类，这次这个驱动已经不是Oracle的驱动了，是Proxool专用的驱动Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");// 2：创建数据库连接，这个参数是一个字符串，是数据源的别名，在配置文件中配置的timalias，参数格式为：proxool.数据源的别名Connection conn = DriverManager.getConnection("proxool.mysql");for(int i = 0; i< 20; i++) conn = DriverManager.getConnection("proxool.mysql");// 3：创建执行SQL的对象Statement stmt = conn.createStatement();// 4：执行SQL，并获取返回结果ResultSet res = stmt.executeQuery(MySQLreq);// 5：处理返回结果，此处打印查询结果ResultSetMetaData rsmd = res.getMetaData();int columnCount = rsmd.getColumnCount();int rowCount = 0;while (res.next()) {System.out.print(rowCount + " ");rowCount++;for (int j = 1; j <= columnCount; j++) {// 循环处理String strRes = res.getString(j);System.out.print(strRes + "|\t");}System.out.println();}// 6：关闭数据库连接conn.close();}public static void main(String[] args) throws Exception {Test obj = new Test();obj.test2();}}

proxool.xml如下：

<?xml version="1.0" encoding="UTF-8"?> <something-else-entirely>         <proxool>                 <alias>mysql</alias>                 <!--数据源的别名-->                 <driver-url>jdbc:mysql://127.0.0.1:3306/mysqlconn</driver-url>                 <!--url连接串-->                 <driver-class>com.mysql.jdbc.Driver</driver-class>                 <!--驱动类-->                 <driver-properties>                         <property name="user" value="root"/>                         <!--用户名-->                         <property name="password" value="123456"/>                         <!--密码-->                 </driver-properties>                 <!--最大连接数(默认5个),超过了这个连接数,再有请求时,就排在队列中等候,最大的等待请求数由maximum-new-connections决定 -->                 <maximum-connection-count>5</maximum-connection-count>                 <!--最小连接数(默认2个)-->                 <minimum-connection-count>1</minimum-connection-count>                 <!--proxool自动侦察各个连接状态的时间间隔(毫秒),侦察到空闲的连接就马上回收,超时的销毁 默认30秒-->                 <house-keeping-sleep-time>90000</house-keeping-sleep-time>                 <!--没有空闲连接可以分配而在队列中等候的最大请求数,超过这个请求数的用户连接就不会被接受-->                 <maximum-new-connections>6</maximum-new-connections>                 <!--最少保持的空闲连接数(默认2个)-->                 <prototype-count>5</prototype-count>                 <!--在使用之前测试-->                 <test-before-use>true</test-before-use>                 <!--用于保持连接的测试语句 -->                 <house-keeping-test-sql>show tables</house-keeping-test-sql>         </proxool> </something-else-entirely>

注意，在程序中发起了过多线程，目的就是检验线程限制是否有效。

数据库内容如下：

结果如下：

[DEBUG 2012-08-06 15:57:24] Configuring from xml file: proxool.xml[DEBUG 2012-08-06 15:57:24] SAXParserFactory class: com.sun.org.apache.xerces.internal.jaxp.SAXParserFactoryImpl[DEBUG 2012-08-06 15:57:24] sax parser classcom.sun.org.apache.xerces.internal.jaxp.SAXParserImpl[DEBUG 2012-08-06 15:57:24] XML reader class: com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser[DEBUG 2012-08-06 15:57:24] Setting sax feature: 'http://xml.org/sax/features/namespaces'. State: true.[DEBUG 2012-08-06 15:57:24] Setting sax feature: 'http://xml.org/sax/features/namespace-prefixes'. State: false.[DEBUG 2012-08-06 15:57:24] Adding driver property: user=root[DEBUG 2012-08-06 15:57:24] Adding driver property: password=*******[DEBUG 2012-08-06 15:57:24] Setting property 'proxool.maximum-connection-count' to value '5'.[DEBUG 2012-08-06 15:57:24] Setting property 'proxool.minimum-connection-count' to value '1'.[DEBUG 2012-08-06 15:57:24] Setting property 'proxool.house-keeping-sleep-time' to value '90000'.[DEBUG 2012-08-06 15:57:24] Setting property 'proxool.maximum-new-connections' to value '6'.[DEBUG 2012-08-06 15:57:24] Setting property 'proxool.prototype-count' to value '5'.[DEBUG 2012-08-06 15:57:24] Setting property 'proxool.test-before-use' to value 'true'.[DEBUG 2012-08-06 15:57:24] Setting property 'proxool.house-keeping-test-sql' to value 'show tables'.[DEBUG 2012-08-06 15:57:24] Created url: proxool.mysql:com.mysql.jdbc.Driver:jdbc:mysql://127.0.0.1:3306/mysqlconn[INFO 2012-08-06 15:57:24] Proxool 0.9.1 (23-Aug-2008 11:10)[DEBUG 2012-08-06 15:57:24] Recognised proxool property: proxool.driver=com.mysql.jdbc.Driver[DEBUG 2012-08-06 15:57:24] Recognised proxool property: proxool.url=jdbc:mysql://127.0.0.1:3306/mysqlconn[DEBUG 2012-08-06 15:57:24] Recognised proxool property: proxool.minimum-connection-count=1[DEBUG 2012-08-06 15:57:24] Recognised proxool property: proxool.test-before-use=true[WARN 2012-08-06 15:57:24] Use of proxool.maximum-new-connections is deprecated. Use more descriptive proxool.simultaneous-build-throttle instead.[DEBUG 2012-08-06 15:57:24] Recognised proxool property: proxool.maximum-new-connections=6[DEBUG 2012-08-06 15:57:24] Delegating property to driver: user=root[DEBUG 2012-08-06 15:57:24] Recognised proxool property: proxool.house-keeping-sleep-time=90000[DEBUG 2012-08-06 15:57:24] Recognised proxool property: proxool.prototype-count=5[DEBUG 2012-08-06 15:57:24] Delegating property to driver: password=********[DEBUG 2012-08-06 15:57:24] Recognised proxool property: proxool.maximum-connection-count=5[DEBUG 2012-08-06 15:57:24] Recognised proxool property: proxool.house-keeping-test-sql=show tables[DEBUG 2012-08-06 15:57:24] Registered shutdownHook[DEBUG 2012-08-06 15:57:24] Registering 'mysql' house keeper[DEBUG 2012-08-06 15:57:24] Starting a house keeper thread[DEBUG 2012-08-06 15:57:25] Remembering default value: getTransactionIsolation() = 4[DEBUG 2012-08-06 15:57:25] Remembering default value: getHoldability() = 2[DEBUG 2012-08-06 15:57:25] Remembering default value: getCatalog() = mysqlconn[DEBUG 2012-08-06 15:57:25] Remembering default value: isReadOnly() = false[DEBUG 2012-08-06 15:57:25] Remembering default value: getTypeMap() = {}[INFO 2012-08-06 15:57:25] Proxool statistics legend: "s - r  (a/t/o)" > s=served, r=refused (only shown if non-zero), a=active, t=total, o=offline (being tested)[INFO 2012-08-06 15:57:25] Proxool statistics legend: "s - r  (a/t/o)" > s=served, r=refused (only shown if non-zero), a=active, t=total, o=offline (being tested)[DEBUG 2012-08-06 15:57:25] 000000 (01/02/00) - Connection #2 created to keep 5 available = AVAILABLE[DEBUG 2012-08-06 15:57:25] 000000 (01/02/00) - Connection #1 created on demand = ACTIVE[DEBUG 2012-08-06 15:57:25] 000000 (01/02/00) - Connection #1 tested: OK[DEBUG 2012-08-06 15:57:25] 000001 (01/03/00) - Connection #3 created to keep 5 available = AVAILABLE[DEBUG 2012-08-06 15:57:25] 000001 (01/04/00) - Connection #4 created to keep 5 available = AVAILABLE[DEBUG 2012-08-06 15:57:25] 000001 (01/05/00) - Connection #5 created to keep 5 available = AVAILABLE[DEBUG 2012-08-06 15:57:25] Implementing interface java.sql.Connection[DEBUG 2012-08-06 15:57:25] Implementing interface java.sql.Wrapper[DEBUG 2012-08-06 15:57:25] 000001 (02/05/00) - Connection #2 tested: OK[DEBUG 2012-08-06 15:57:25] 000002 (03/05/00) - Connection #3 tested: OK[DEBUG 2012-08-06 15:57:25] 000003 (04/05/00) - Connection #4 tested: OK[DEBUG 2012-08-06 15:57:25] 000004 (05/05/00) - Connection #5 tested: OK[INFO 2012-08-06 15:57:25] 000005 -000001 (05/05/00) - Couldn't get connection because we are at maximum connection count and there are none availableException in thread "main" java.sql.SQLException: Couldn't get connection because we are at maximum connection count (5/5) and there are none availableat org.logicalcobwebs.proxool.Prototyper.quickRefuse(Prototyper.java:309)at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:152)at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)at java.sql.DriverManager.getConnection(DriverManager.java:582)at java.sql.DriverManager.getConnection(DriverManager.java:207)at yerasel.Test.test2(Test.java:36)at yerasel.Test.main(Test.java:60)[DEBUG 2012-08-06 15:57:25] Running ShutdownHook[INFO 2012-08-06 15:57:25] Shutting down 'mysql' pool immediately [Shutdown Hook][INFO 2012-08-06 15:57:25] Waiting until Mon Aug 06 15:57:25 CST 2012 for all connections to become inactive (active count is 5).[WARN 2012-08-06 15:57:25] Shutdown waited for 0 milliseconds for all the connections to become inactive but the active count is still 5. Shutting down anyway.[DEBUG 2012-08-06 15:57:25] 000005 -000001 (04/04/00) - #0005 removed because of shutdown.[DEBUG 2012-08-06 15:57:25] Connection #5 closed[DEBUG 2012-08-06 15:57:25] 000005 -000001 (03/03/00) - #0004 removed because of shutdown.[DEBUG 2012-08-06 15:57:25] Connection #4 closed[DEBUG 2012-08-06 15:57:25] 000005 -000001 (02/02/00) - #0003 removed because of shutdown.[DEBUG 2012-08-06 15:57:25] Connection #3 closed[DEBUG 2012-08-06 15:57:25] 000005 -000001 (01/01/00) - #0001 removed because of shutdown.[DEBUG 2012-08-06 15:57:25] Connection #1 closed[DEBUG 2012-08-06 15:57:25] 000005 -000001 (00/00/00) - #0002 removed because of shutdown.[DEBUG 2012-08-06 15:57:25] Connection #2 closed[INFO 2012-08-06 15:57:25] 'mysql' pool has been closed down by Shutdown Hook in 0 milliseconds.[INFO 2012-08-06 15:57:25] Stopping Prototyper thread[INFO 2012-08-06 15:57:25] Stopping HouseKeeper thread