proxool配置连接池，超过一定时间出现连接超时的异常、server.xml如何配置tomcat在规定时间段内自动重启

Question

1、proxool配置连接池，超过一定时间出现连接超时的异常、异常：Communications link failure due to underlying exception: java.net.SocketException MESSAGE: Connection reset by peer: socket write error STACKTRACE:java.net.SocketException: Connection reset by peer: socket write error
如何配置proxool2、server.xml如何配置tomcat在规定时间段内自动重启

Answer 1

 jdbc-0.proxool.house-keeping-test-sql=SELECT SYSDATE FROM DUAL

Answer 2

我有这项配置，可能我没说清楚我遇到的问题：我的网站是放在别人的服务器上的，恰巧他们凌晨重启了数据库，这样对我连接池有没什么影响呢？网站在被访问之后日志就出这样的异常：Communications link failure due to underlying exception: java.net.SocketException MESSAGE: Connection reset by peer: socket write error STACKTRACE:java.net.SocketException: Connection reset by peer: socket write error，

Answer 3

proxool.xml
<something-else-entirely>
    <proxool>
        <alias>kmp_db</alias>
        <driver-url>jdbc:oracle:thin:@//127.0.0.1:1521/orcl</driver-url>
        <driver-class>oracle.jdbc.OracleDriver</driver-class>
        <driver-properties>
            <property name="user" value="kmp" />
            <property name="password" value="kmp" />
        </driver-properties>
        <house-keeping-sleep-time>36000</house-keeping-sleep-time>
        <test-before-use>true</test-before-use>
        <prototype-count>5</prototype-count>
        <maximum-connection-count>100</maximum-connection-count>
        <minimum-connection-count>10</minimum-connection-count>
        <proxool.simultaneous-build-throttle>20</proxool.simultaneous-build-throttle>
        <house-keeping-test-sql>select code from directory</house-keeping-test-sql>
    </proxool>
</something-else-entirely>  
web.xml
<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>proxool_Admin</servlet-name>
  <servlet-class>org.logicalcobwebs.proxool.admin.servlet.AdminServlet</servlet-class>
</servlet>
这应与重启没有关系.