数据库连接池1

本人在学习hibernet时发现一个不错的连接池 : http://proxool.sourceforge.net/

配置方式如下：

chinaju.properties

jdbc-0.proxool.alias=chinaju
jdbc-0.proxool.driver-class=com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbc-0.proxool.driver-url=jdbc:microsoft:sqlserver://192.168.0.113:1433;DatabaseName=chinaju;user=sa;password=111

jdbc-0.proxool.maximum-connection-count=40
jdbc-0.proxool.prototype-count=4

jdbc-0.proxool.house-keeping-test-sql=select CURRENT_DATE
jdbc-0.proxool.verbose=true
jdbc-0.proxool.statistics=10s,1m,1d
jdbc-0.proxool.statistics-log-level=DEBUG

放到 tomcat 站点的classees目录下。就可以了，要吧放多个只要在web.xml指明就可以了。

<servlet>
  <servlet-name>ServletConfigurator1</servlet-name>
  <servlet-class>org.logicalcobwebs.proxool.configuration.ServletConfigurator</servlet-class>
  <init-param>
   <param-name>propertyFile</param-name>
   <param-value>WEB-INF/classes/bbs.properties</param-value>
  </init-param>
  <load-on-startup>1</load-on-startup>
 </servlet>
 <servlet>
  <servlet-name>ServletConfigurator2</servlet-name>
  <servlet-class>org.logicalcobwebs.proxool.configuration.ServletConfigurator</servlet-class>
  <init-param>
   <param-name>propertyFile</param-name>
   <param-value>WEB-INF/classes/chinaju.properties</param-value>
  </init-param>
  <load-on-startup>1</load-on-startup>
 </servlet>
 <servlet>
  <servlet-name>ServletConfigurator3</servlet-name>
  <servlet-class>org.logicalcobwebs.proxool.configuration.ServletConfigurator</servlet-class>
  <init-param>
   <param-name>propertyFile</param-name>
   <param-value>WEB-INF/classes/count.properties</param-value>
  </init-param>
  <load-on-startup>1</load-on-startup>
 </servlet>
 <servlet>
  <servlet-name>Admin</servlet-name>
  <servlet-class>org.logicalcobwebs.proxool.admin.servlet.AdminServlet</servlet-class>
 </servlet>

 <servlet-mapping>
  <servlet-name>Admin</servlet-name>
  <url-pattern>/Admin</url-pattern>
 </servlet-mapping>

使用方式如下:

conn = DriverManager.getConnection("proxool.chinaju");
  stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);