网页等待响应
因为Liunx下用Mysql5.6 8小时无访问就关闭连接。配了个C3P0这个问题解决了。可是过了一天网页就无响应了,打开网页状态一直是等待响应。<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql://localhost/text</property>
<property name="connection.username">root</property>
<property name="connection.password">root</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="current_session_context_class">thread</property>
<!--C3P0连接池设定 -->
<property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
<property name="hbm2ddl.auto">update</property>
<!-- <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
<property name="connection.autoReconnect">true</property>
<property name="connection.autoReconnectForPools">true</property>
<property name="connection.is-connection-validation-required">true</property>
-->
<property name="c3p0.validate">true</property>
<property name="hibernate.c3p0.min_size">2</property>
<property name="hibernate.c3p0.max_size">10</property>
<!-- 每隔120秒检查连接池里的空闲连接 ,单位是秒-->
<property name="c3p0.idle_test_period">120</property>
<!--每18000秒检查所有连接池中的空闲连接。Default: 0 -->
<property name="hibernate.c3p0.idleConnectionTestPeriod ">18000</property>
<property name="bernate.c3p0.timeout">60</property>
<property name="hibernate.c3p0.acquire_increment">2</property>
<!--最大空闲时间,25000秒内未使用则连接被丢弃。若为0则永不丢弃。Default: 0 -->
<property name="hibernate.c3p0.maxIdleTime">19000</property>
<property name="show_sql">false</property>
<property name="format_sql">true</property>
<mapping class="com.ctjzz.model.Image"/>
<mapping class="com.ctjzz.model.Image"/>
<mapping class="com.ctjzz.model.News"/>
</session-factory>
</hibernate-configuration>
各位大虾帮看看吧! c3p0
补充:Java , Web 开发