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=selectTYDB_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=selectTYDB_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>