Tomcat 6中proxool+jndi的配置

plantegg

简单使用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目录中