Tomcat 6中proxool+jndi的配置

简单使用proxool数据源参考：http://qhhhn.iteye.com/admin/blogs/294039

Tomcat 6中proxool+jndi的配置：

tomcat\conf\context.xml

<Context>
<Resource name="jdbc/mysql"
     auth="Container"    
     type="javax.sql.DataSource"
     factory="org.logicalcobwebs.proxool.ProxoolDataSource"    
     proxool.alias="testDB"    
     user="root"  
     password="password"    
     delegateProperties="foo=1,bar=true"
     proxool.jndi-name="mysqljndi"   
     proxool.driver-url="jdbc:mysql://127.0.0.1:3306/test"    
     proxool.driver-class="com.mysql.jdbc.Driver"  
     proxool.house-keeping-sleep-time="900000"  
     proxool.maximum-active-time="5"
     proxool.prototype-count="3"
     proxool.statistics="1m,15m,1d"
     proxool.simultaneous-build-throttle="10"
     proxool.minimum-connection-count="5"
     proxool.maximum-connection-count="15"
     proxool.house-keeping-test-sql="select CURRENT_DATE from dual" 
     proxool.test-before-use="true"/>
</Context>

web.xml

<servlet>
		<servlet-name>proxooladmin</servlet-name>
		<servlet-class> org.logicalcobwebs.proxool.admin.servlet.AdminServlet 
		</servlet-class>
	</servlet>
	<servlet-mapping>
		<servlet-name>proxooladmin</servlet-name>
		<url-pattern>/proxooladmin</url-pattern>
	</servlet-mapping>

此配置中不须要proxool.xml

java代码

Context ctx = new InitialContext();
DataSource dataSource = (DataSource) ctx.lookup("java:comp/env/jdbc/mysql");

Spring配置

<bean id="jndiDataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName">
<value>java:comp/env/jdbc/mysql</value>
</property>
</bean>

对持久化层进行依赖注入时，给dataSource属性注入jndiDataSource即可。如：
<property name=”dataSource” ref=”jndiDataSource”/>

注意要将proxool-0.9.1.jar,proxool-cglib.jar 复制到Tomcat\lib目录中