proxool数据源访问

使用JNDI连接数据库连接池

 

1、tomcat中配置JNDI数据源：

 

<Resource  name="jdbc/sid"
     auth="Container"    
     type="javax.sql.DataSource"
     factory="org.logicalcobwebs.proxool.ProxoolDataSource"    
     proxool.alias="orale10g"    
     user="uername"  
     password="pwd"    
     delegateProperties="foo=1,bar=true"
     proxool.jndi-name="myjndi"   
     proxool.driver-url="jdbc:oracle:thin:@127.0.0.1:1521:sid"    
     proxool.driver-class="oracle.jdbc.driver.OracleDriver"
     proxool.house-keeping-sleep-time="60000"  
     proxool.maximum-active-time="60000"
     proxool.prototype-count="2"
     proxool.statistics="1m,15m,1d"
     proxool.minimum-connection-count="10"
     proxool.maximum-connection-count="50"
     proxool.simultaneous-build-throttle="10"
     proxool.house-keeping-test-sql="select CURRENT_DATE from dual" 
     proxool.test-before-use="true"/>

 

并且tomcat的lib目录中要包含【proxool-0.9.1.jar】和【proxool-cglib.jar】。

 

 

2、在web.xml中添加

 <resource-ref>
  <description>tour online Connection</description>
  <res-ref-name>jdbc/sid</res-ref-name>
  <res-type>javax.sql.DataSource</res-type>
  <res-auth>Container</res-auth>
 </resource-ref>

 

 3、使用http://feijian8.iteye.com/blog/1758129来访问数据源。