日期:2014-05-16  浏览次数:20541 次

oracle数据库-使用proxool进行中断重连
 (1)proxool.xml配置项参数
<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
        <proxool>
                <alias>webDB</alias>
                <driver-url>jdbc:oracle:thin:@127.0.0.1:1521:web</driver-url>
                <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
                <driver-properties>
                        <property name="user" value="web"/>
                        <property name="password" value="123"/>
                        <property name="autoReconnect" value="true" />
                </driver-properties>
                <maximum-active-time>120000</maximum-active-time>
                <maximum-connection-count>10</maximum-connection-count>
                <minimum-connection-count>2</minimum-connection-count>
                <house-keeping-sleep-time>120000</house-keeping-sleep-time>
                <simultaneous-build-throttle>10</simultaneous-build-throttle>
                <prototype-count>5</prototype-count>
                <test-before-use>true</test-before-use>
                <house-keeping-sleep-time>60000</house-keeping-sleep-time> 
                <house-keeping-test-sql>select sysdate from dual</house-keeping-test-sql>
        </proxool>
</something-else-entirely>