struts2.0+spring2.5 配置proxool始终报 Attempt to refer to a unregistered pool by its alias 'DBPool'

Question

web.xml     <servlet>   
        <servlet-name>ServletConfigurator</servlet-name>   
        <servlet-class>   
            org.logicalcobwebs.proxool.configuration.ServletConfigurator    
        </servlet-class>   
        <init-param>   
            <param-name>xml</param-name>   
            <param-value>WEB-INF/proxool.xml</param-value>   
        </init-param>   
        <load-on-startup>1</load-on-startup>   
    </servlet> 
aplicationContext.xml<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">   
        <property name="driverClassName" value="org.logicalcobwebs.proxool.ProxoolDriver"/>   
        <property name="url" value="proxool.DBPool"/>   
    </bean>   
    <bean id="transactionManager"    
        class="org.springframework.jdbc.datasource.DataSourceTransactionManager">   
        <property name="dataSource">   
            <ref local="dataSource" />   
        </property>   
   </bean>  proxool.xml<?xml version="1.0" encoding="UTF-8"?>     
   
<!-- the proxool configuration can be embedded within your own application's. Anything outside the "proxool" tag is ignored. -->     
   
<something-else-entirely>   
    <proxool>   
        <!--连接池的别名-->   
        <alias>DBPool</alias>   
        <!--proxool只能管理由自己产生的连接-->   
        <driver-url>jdbc:oracle:thin:@localhost:1521:MANAGOOD</driver-url>   
        <!--JDBC驱动程序-->   
        <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>   
        <driver-properties>   
            <property name="user" value="xiaochun"/>   
            <property name="password" value="xiaochun"/>   
        </driver-properties>   
        <!-- proxool自动侦察各个连接状态的时间间隔(毫秒),侦察到空闲的连接就马上回收,超时的销毁-->   
        <house-keeping-sleep-time>90000</house-keeping-sleep-time>   
        <!-- 指因未有空闲连接可以分配而在队列中等候的最大请求数,超过这个请求数的用户连接就不会被接受-->     
        <maximum-new-connections>150</maximum-new-connections>   
        <!-- 最少保持的空闲连接数-->     
        <prototype-count>3</prototype-count>   
        <!-- 允许最大连接数,超过了这个连接，再有请求时，就排在队列中等候，最大的等待请求数由maximum-new-connections决定-->     
        <maximum-connection-count>100</maximum-connection-count>   
        <!-- 最小连接数-->   
        <minimum-connection-count>3</minimum-connection-count>   
    </proxool>   
</something-else-entirely> 这篇文章或许有用..但我试了一下,还是没有成功..
http://www.javaeye.com/post/696545   搞了一天了..伤心啊
   谢谢....

Answer 1

这里应该是xmlFile吧    <servlet> 
        <servlet-name>ServletConfigurator </servlet-name> 
        <servlet-class> 
            org.logicalcobwebs.proxool.configuration.ServletConfigurator   
        </servlet-class> 
        <init-param> 
            <param-name>xmlFile</param-name> 
            <param-value>WEB-INF/proxool.xml </param-value> 
        </init-param> 
        <load-on-startup>1 </load-on-startup> 
    </servlet> 

Answer 2

我开始也这么认为过...不过我改成xmlFILE 启动时TOMCAT就报错...

Answer 3

用dataSource方式在spring中配置proxool