spring集成数据库连接池

我项目中使用的是proxool数据库连接池，

首先在web.xml中配置：

<!-- 配置数据库链接池 -->
    <display-name>proxool</display-name>
    <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>2</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>/webadmin</url-pattern>
    </servlet-mapping>

 

配置完成后，在spring中可以直接集成该连接池，该连接池既可以再WEB中单独使用，也可以在spring 中使用，非常方便

<!-- 数据库连接池proxool -->
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">  
      <property name="driverClassName" value="org.logicalcobwebs.proxool.ProxoolDriver"/>  
      <property name="url" value="proxool.BossTYService"/>  
    </bean> 
    <!--红色部分是我出错的地方，因为我连接池中配置的别名是BossTYService,所以这里的固定写法是proxool.+别名的配置-->
    <!-- jdbc模板配置 -->
    <bean id="jdbcTemplate"
        class="org.springframework.jdbc.core.JdbcTemplate" abstract="false"
        lazy-init="false" autowire="default" dependency-check="default">
        <property name="dataSource">
            <ref bean="dataSource" />
        </property>
    </bean>

 

 

proxoo.xml写法

<?xml   version="1.0"   encoding="gbk"?>
    <!--
        the proxool configuration can be embedded within your own
        application's. Anything outside the "proxool" tag is ignored. utf-8
        ISO8859_1
    -->
<something-else-entirely>
   
    <proxool>
        <alias>BossTYService</alias>
        <driver-url> jdbc:jtds:sqlserver://localhost:1370/BossTYService
        </driver-url>
        <driver-class>net.sourceforge.jtds.jdbc.Driver
        </driver-class>
        <driver-properties>
            <property name="user" value="sa" />
            <property name="password" value="111111" />
        </driver-properties>
        <maximum-active-time>60000</maximum-active-time>
        <simultaneous-build-throttle>20</simultaneous-build-throttle>
        <!--
            pool max number, more no create new
        -->
        <prototype-count>2</prototype-count><!-- pool free number -->
        <maximum-connection-count>200</maximum-connection-count>
        <!--
            pool max number,more can create new
        -->
        <minimum-connection-count>50</minimum-connection-count>
        <!--
            pool min number
        -->
        <house-keeping-test-sql> select top 1 ID from [User]
        </house-keeping-test-sql>
    </proxool>
</something-else-entirely>