当前页面: 开发资料首页 → JSP 专题 → 系统运行一段时间后，登陆系统，出现连接不上数据库的错误

系统运行一段时间后，登陆系统，出现连接不上数据库的错误

摘要: 系统运行一段时间后，登陆系统，出现连接不上数据库的错误

2006-09-18 10:59:39,924 WARN [org.hibernate.util.JDBCExceptionReporter] -
2006-09-18 10:59:39,931 ERROR [org.hibernate.util.JDBCExceptionReporter] -
2006-09-18 10:59:39,936 ERROR [com.zhcw.dx.mappings.Cx09DAO] -
org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2148)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1533)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
at com.zhcw.dx.mappings.Cx09DAO.findByProperty(Cx09DAO.java:116)
at com.zhcw.dx.mappings.Cx09DAO.findByCxi001_Cxi002(Cx09DAO.java:129)
at com.zhcw.dx.action.UserLoginAction.login(UserLoginAction.java:45)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:300)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:374)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:743)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:675)
at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:866)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Io 异常: Connection reset
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:815)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
... 46 more

---

没人碰到过麽？

---

配置文件有错误!

---

package com.zhcw.dx.mappings;

import java.util.List;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.Criteria;
import org.hibernate.LockMode;
import org.hibernate.Query;
import org.hibernate.criterion.Example;
import org.hibernate.criterion.Expression;

import com.zhcw.dx.base.BaseDAO;

/**
* Data access object (DAO) for domain model class Cx09.
*
* @see com.zhcw.dx.mappings.Cx09
* @author MyEclipse - Hibernate Tools
*/
public class Cx09DAO extends BaseDAO {

private static final Log log = LogFactory.getLog(Cx09DAO.class);

public static final String CXI001 = "id.cxi001";

public static final String CXI002 = "id.cxi002";

// property constants

public void save(Cx09 transientInstance) {
log.debug("saving Cx09 instance");
try {
getSession().save(transientInstance);
log.debug("save successful");
} catch (RuntimeException re) {
log.error("save failed", re);
throw re;
}
}

public void delete(Cx09 persistentInstance) {
log.debug("deleting Cx09 instance");
try {
getSession().delete(persistentInstance);
log.debug("delete successful");
} catch (RuntimeException re) {
log.error("delete failed", re);
throw re;
}
}

public Cx09 findById(com.zhcw.dx.mappings.Cx09Id id) {
log.debug("getting Cx09 instance with id: " + id);
try {
Cx09 instance = (Cx09) getSession().get(
"com.zhcw.dx.mappings.Cx09", id);
return instance;
} catch (RuntimeException re) {
log.error("get failed", re);
throw re;
} finally {
closeSession();
}
}

public List findByExample(Cx09 instance) {
log.debug("finding Cx09 instance by example");
try {
List results = getSession().createCriteria(
"com.zhcw.dx.mappings.Cx09").add(Example.create(instance))
.list();
log.debug("find by example successful, result size: "
+ results.size());
return results;
} catch (RuntimeException re) {
log.error("find by example failed", re);
throw re;
} finally {
closeSession();
}
}

public List findByProperty(String propertyName, Object value) {
log.debug("finding Cx09 instance with property: " + propertyName
+ ", value: " + value);
try {
String queryString = "from Cx09 as model where model."
+ propertyName + "= ?";
Query queryObject = getSession().createQuery(queryString);
queryObject.setParameter(0, value);
return queryObject.list();
} catch (RuntimeException re) {
log.error("find by property name failed", re);
throw re;
} finally {
closeSession();
}
}

public List findByProperty(String propertyName, Object value,
String propertyName2, Object value2) {
log.debug("finding Cx09 instance with property: " + propertyName
+ ", value: " + value);
try {
/*
* String queryString = "from Cx09 as model where model." +
* propertyName + "= ? and model." + propertyName2 + "= ?"; Query
* queryObject = getSession().createQuery(queryString);
* queryObject.setParameter(0, value); queryObject.setParameter(1,
* value2);
*/
Criteria criteria = getSession().createCriteria(Cx09.class);
criteria.add(Expression.eq(propertyName, value));
criteria.add(Expression.eq(propertyName2, value2));
List list = criteria.list();
return list;
} catch (RuntimeException re) {
log.error("find by property name failed", re);
throw re;
} finally {
log.error("findByProperty 关闭连接!!!!");
closeSession();
}
}

public List findByCxi001_Cxi002(Object cxi001, Object cxi002) {
// getSession().flush();
return findByProperty(CXI001, cxi001, CXI002, cxi002);
}

public static void main(String a[]) {
System.out.println(new Cx09DAO().findByCxi001_Cxi002("13810980591",
"111").size());
}

public Cx09 merge(Cx09 detachedInstance) {
log.debug("merging Cx09 instance");
try {
Cx09 result = (Cx09) getSession().merge(detachedInstance);
log.debug("merge successful");
return result;
} catch (RuntimeException re) {
log.error("merge failed", re);
throw re;
}
}

public void attachDirty(Cx09 instance) {
log.debug("attaching dirty Cx09 instance");
try {
getSession().saveOrUpdate(instance);
log.debug("attach successful");
} catch (RuntimeException re) {
log.error("attach failed", re);
throw re;
} finally {
closeSession();
}
}

public void attachClean(Cx09 instance) {
log.debug("attaching clean Cx09 instance");
try {
getSession().lock(instance, LockMode.NONE);
log.debug("attach successful");
} catch (RuntimeException re) {
log.error("attach failed", re);
throw re;
} finally {
closeSession();
}
}
}

---

配置文件有错误!

---

顶

---

配置文件有错误!
那为什么我刚启动tomcat 的时候，运行正常呢。
然后一段时间后，才出现这样的问题。

---

<?xml version="1.0"?>
hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">