Torque 用作数据库连接池

1.下载 :在 Torque 的使用过程中，很多的工作都是通过 ant 来完成的，所以先下载并安装 ant。然后在 http://db.apache.org/torque/ 网站上下载 torque。

2.把 %Torque_home%/lib下面的所有.jar文件,放入测试项目classpath中

3.Torque.properties设置

torque.applicationRoot = .
log4j.category.org.apache.torque = ALL, org.apache.torque
log4j.appender.org.apache.torque = org.apache.log4j.ConsoleAppender
log4j.appender.org.apache.torque.file = ${torque.applicationRoot}/logs/torque.log
log4j.appender.org.apache.torque.layout = org.apache.log4j.PatternLayout
log4j.appender.org.apache.torque.layout.conversionPattern = %d [%t] %-5p %c - %m%n
log4j.appender.org.apache.torque.append = false

torque.database.default=test
torque.database.mdclub.adapter=oracle
torque.database.vcmsdb.adapter=oracle

## Using Jdbc2Pool源
torque.dsfactory.test.factory=org.apache.torque.dsfactory.Jdbc2PoolDataSourceFactory
torque.dsfactory.test.pool.defaultMaxActive=10
torque.dsfactory.test.pool.testOnBorrow=true
torque.dsfactory.test.pool.validationQuery=SELECT * from dual
torque.dsfactory.test.connection.driver = oracle.jdbc.driver.OracleDriver
torque.dsfactory.test.connection.url = jdbc:oracle:thin:@192.168.0.110:1521:ora10
torque.dsfactory.test.connection.user = test 
torque.dsfactory.test.connection.password = test

torque.idbroker.cleverquantity=true

torque.manager.useCache = true

4.Torque的使用(只使用其连接池)

    java.sql.Connection conn = Torque.getConnection();
        String sql =
                "select pid from person where  phone_number = '"+phone_number+"'";
              Statement  stmt = conn.createStatement();
               ResultSet rs = stmt.executeQuery(sql);
               while (rs.next()) {
                   pid = (int)rs.getInt("pid");
                   break;
               }
        if (conn != null) {
            Torque.closeConnection(conn);
        }

5.   测试500次数据库连接，未用Torque连接池：所需时间：30s
       用Torque连接池：9s

6.  总结:也可以用hibernate的连接池,自己写连接池编写,调试可能出错,配置tomcat连接池则可能与服务器变动而不能使用,使用Torque连接池简单,与应用服务器无关