tomcat连接mysql 8小时没有数据库操作就会断开连接！！！

Question

8个小时之后如果有活动连接还能恢复吗？如果可以就别管了，这个样子也好。我建议你看看mysql是否还有休眠的进程，只要不造成死锁，那么这是好事情。

Answer 1

<!-- global_stock Context -->
        <Context path="/myweb" docBase="myweb" debug="5"
                 reloadable="true" crossContext="true">
          <Logger className="org.apache.catalina.logger.FileLogger"
                     prefix="localhost_devoinfo_log." suffix=".txt"
           timestamp="true"/>
          <Ejb   name="ejb/EmplRecord" type="Entity"
                 home="com.wombat.empl.EmployeeRecordHome"
               remote="com.wombat.empl.EmployeeRecord"/>
          <Environment name="maxExemptions" type="java.lang.Integer"
                      value="15"/>
          <Parameter name="context.param.name" value="context.param.value"
                     override="false"/>
          <Resource name="jdbc/dbconnection" auth="Container"
                    type="javax.sql.DataSource"/>
          <ResourceParams name="jdbc/mydbconnection">
   <parameter>
    <name>factory</name>
    <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
  </parameter>   <parameter>
     <name>username</name><value>root</value>
  </parameter>
          <parameter>
      <name>password</name><value>password</value>
  </parameter>
          <parameter>
    <name>driverClassName</name>
              <value>org.gjt.mm.mysql.Driver</value>
  </parameter>
          <parameter>
      <name>url</name>
              <value>jdbc:mysql://localhost:3306/mydb?autoReconnect=true</value>
   </parameter>          <parameter>
              <name>maxActive</name>
                <value>100</value>
          </parameter>
          <parameter>
             <name>maxIdle</name>
             <value>50</value>
          </parameter>
          <parameter>
                 <name>maxWait</name>
                 <value>10000</value>
          </parameter>
          <parameter>
              <name>removeAbandoned</name>
              <value>true</value>
          </parameter>            <parameter>
              <name>removeAbandonedTimeout</name>
              <value>30</value>
            </parameter>     <!--
    <parameter>
              <name>logAbandoned</name>
              <value>true</value>
            </parameter>
-->
          </ResourceParams>
        
  <Resource name="mail/Session" auth="Container"
                    type="javax.mail.Session"/>
          <ResourceParams name="mail/Session">
            <parameter>
              <name>mail.smtp.host</name>
              <value>localhost</value>
            </parameter>
          </ResourceParams>
        </Context>