proxool连接池的使用

 

 

 

在web.xml文件中添加配置信息：

    <!-- 在web.xml中配置proxool的配置信息 -->

    < servlet >

        < servlet-name > ServletConfiguratorXML </ servlet-name >

        < servlet-class >

            org.logicalcobwebs.proxool.configuration.ServletConfigurator

        </ servlet-class >

        < init-param >

            <!-- 数据库链接的相关属性都在这个配置文件中 -->

            <!--<param-name>xmlFile</param-name>-->

        <!--<param-value>WEB-INF/proxoolConfig/proxoolConf.xml</param-value>-->

            < param-name > propertyFile </ param-name >

            < param-value > WEB-INF/proxoolConfig/proxool2.properties </ param-value >

        </ init-param >

        < load-on-startup > 0 </ load-on-startup >

    </ servlet >

 

使用properties和xml文件进行配置

Properties ：

jdbc-0.proxool.alias= Develop

jdbc-0.proxool.driver-url= jdbc : oracle:thin:@210.51.173.94:1521:YDB

jdbc-0.proxool.driver-class= oracle.jdbc.driver.OracleDriver

jdbc-0.user= ydbuser

jdbc-0.password= ydbuser

jdbc-0.proxool.maximum-connection-count= 10

jdbc-0.proxool.minimum-connection-count= 3

jdbc-0.proxool.house-keeping-test-sql= select TYDB_XXFL

 

jdbc-1.proxool.alias= Develop2

jdbc-1.proxool.driver-url= jdbc : oracle:thin:@210.51.173.94:1521:YDB

jdbc-1.proxool.driver-class= oracle.jdbc.driver.OracleDriver

jdbc-1.user= ydbuser

jdbc-1.password= ydbuser

jdbc-1.proxool.maximum-connection-count= 10

jdbc-1.proxool.minimum-connection-count= 3

jdbc-1.proxool.house-keeping-test-sql= select TYDB_XXFL

 

xml 文件：

<? xml version = "1.0" encoding = "UTF-8" ?>

< something-else-entirely >

    < proxool >

        < alias > Develop </ alias >

        < driver-url >

            jdbc:oracle:thin:@210.51.173.94:1521:YDB

        </ driver-url >

        < driver-class > oracle.jdbc.driver.OracleDriver </ driver-class >

        < driver-properties >

            < property name = "user" value = "ydbuser" />

            < property name = "password" value = "ydbuser" />

        </ driver-properties >

        < maximum-connection-count > 500 </ maximum-connection-count >

        < minimum-connection-count > 5 </ minimum-connection-count >

        < house-keeping-test-sql >

            select TYDB_XXFL

        </ house-keeping-test-sql >

    </ proxool >

 

    < proxool >

        < alias > Develop2 </ alias >

        < driver-url >

            jdbc:oracle:thin:@210.51.173.94:1521:YDB

        </ driver-url >

        < driver-class > oracle.jdbc.driver.OracleDriver </ driver-class >

        < driver-properties >

            < property name = "user" value = "ydbuser" />

            < property name = "password" value = "ydbuser" />

        </ driver-properties >

        < maximum-connection-count > 500 </ maximum-connection-count >

        < house-keeping-test-sql >

            select TYDB_XXFL

        </ house-keeping-test-sql >

    </ proxool >

</ something-else-entirely >