我用struts2+hibernate+spring的框架,oracle10g数据库,启动tomcate可以正常运行程序,过一段时间以后大约一小时或两小时,刷新页面就会出现Connection reset这个错误,这应该怎么解决呢,我的连接数据库配置如下
hibernate.xml如下
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"><!-- Generated by MyEclipse Hibernate Tools. -->
<hibernate-configuration> <session-factory>
<property name="dialect">org.hibernate.dialect.OracleDialect</property>
<property name="hibernate.proxool.pool_alias">DBPool</property>
<property name="hibernate.proxool.xml">proxool.xml</property>
<property name="hibernate.connection.release_mode">auto</property>
<property name="hibernate.cglib.use_reflection_optimizer">true</property>
<property name="hibernate.connection.provider_class">org.hibernate.connection.ProxoolConnectionProvider</property>
<property name="hibernate.show_sql">false</property>
<property name="hibernate.connection.autocommit">true</property>
<mapping resource="com/zy/po/eventMng/Eventgpsinfo.hbm.xml" />
</session-factory></hibernate-configuration>
proxool.xml如下<?xml version="1.0" encoding="utf-8"?>
<something-else-entirely> <proxool>
<alias>DBPool</alias>
<driver-url>
jdbc:oracle:thin:@192.168.28.202:1521:orcl
</driver-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver-properties>
<property name="user" value="chinasos" />
<property name="password" value="chinasos098" />
</driver-properties>
<prototype-count>5</prototype-count>
<maximum-connection-count>5000</maximum-connection-count>
<minimum-connection-count>10</minimum-connection-count>
<simultaneous-build-throttle>100</simultaneous-build-throttle>
<!-- <maximum-active-time>5</maximum-active-time> -->
<trace>true</trace>
</proxool>
</something-else-entirely>
hibernate.xml如下
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"><!-- Generated by MyEclipse Hibernate Tools. -->
<hibernate-configuration> <session-factory>
<property name="dialect">org.hibernate.dialect.OracleDialect</property>
<property name="hibernate.proxool.pool_alias">DBPool</property>
<property name="hibernate.proxool.xml">proxool.xml</property>
<property name="hibernate.connection.release_mode">auto</property>
<property name="hibernate.cglib.use_reflection_optimizer">true</property>
<property name="hibernate.connection.provider_class">org.hibernate.connection.ProxoolConnectionProvider</property>
<property name="hibernate.show_sql">false</property>
<property name="hibernate.connection.autocommit">true</property>
<mapping resource="com/zy/po/eventMng/Eventgpsinfo.hbm.xml" />
</session-factory></hibernate-configuration>
proxool.xml如下<?xml version="1.0" encoding="utf-8"?>
<something-else-entirely> <proxool>
<alias>DBPool</alias>
<driver-url>
jdbc:oracle:thin:@192.168.28.202:1521:orcl
</driver-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver-properties>
<property name="user" value="chinasos" />
<property name="password" value="chinasos098" />
</driver-properties>
<prototype-count>5</prototype-count>
<maximum-connection-count>5000</maximum-connection-count>
<minimum-connection-count>10</minimum-connection-count>
<simultaneous-build-throttle>100</simultaneous-build-throttle>
<!-- <maximum-active-time>5</maximum-active-time> -->
<trace>true</trace>
</proxool>
</something-else-entirely>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货