执行报表时，一直处于正在执行状态，后台报错，请各位高手帮帮看看。

[青春微凉不离伤]

[13-11-5 9:15:47:123 CST] 00000060 SystemErr R org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.GenericJDBCException: could not load an entity: [cn.com.cis.acic.sales.schema.model.PrpReportSchedule#13254]
Caused by: org.hibernate.exception.GenericJDBCException: could not load an entity: [cn.com.cis.acic.sales.schema.model.PrpReportSchedule#13254]
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.loadEntity(Loader.java:1798)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:2977)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:393)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:374)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:137)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:193)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:101)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)
at org.springframework.orm.hibernate3.HibernateTemplate$1.doInHibernate(HibernateTemplate.java:460)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:362)
at org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:454)
at org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:448)
at ins.framework.dao.EntityDaoHibernate.get(EntityDaoHibernate.java:70)
at ins.framework.dao.GenericDaoHibernate.get(GenericDaoHibernate.java:52)
at cn.com.cis.acic.sales.report.service.spring.ReportScheduleServiceSpringImpl.findByPrimaryKey(ReportScheduleServiceSpringImpl.java:118)
at cn.com.cis.acic.sales.report.service.spring.ReportScheduleServiceSpringImpl$$FastClassByCGLIB$$381a74e6.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:714)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:162)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:652)
at cn.com.cis.acic.sales.report.service.spring.ReportScheduleServiceSpringImpl$$EnhancerByCGLIB$$ed04a4b8.findByPrimaryKey(<generated>)
at cn.com.cis.acic.sales.report.util.schedule.sdk.report.Report.generatorReportFile(Report.java:604)
at cn.com.cis.acic.sales.report.util.schedule.sdk.report.Report.generate(Report.java:543)
at cn.com.cis.acic.sales.report.util.schedule.sdk.report.ReportGroup.generate(ReportGroup.java:192)
at cn.com.cis.acic.sales.report.util.schedule.task.ReportGeneratorTask.generateReports(ReportGeneratorTask.java:59)
at cn.com.cis.acic.sales.report.util.schedule.task.ReportGeneratorTask.execute(ReportGeneratorTask.java:39)
at cn.com.cis.acic.sales.report.util.schedule.ScheduleTask.run(ScheduleTask.java:82)
at java.util.TimerThread.mainLoop(Timer.java:537)
at java.util.TimerThread.run(Timer.java:487)
Caused by: com.ibm.websphere.ce.cm.StaleConnectionException: Io 异常: Connection reset
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:67)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:522)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper(GenericDataStoreHelper.java:523)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:578)
at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:909)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:570)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1668)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1784)
... 34 more
---- Begin backtrace for Nested Throwables
java.sql.SQLException: Io 异常: Connection reset
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
at oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3675)
at oracle.jdbc.ttc7.TTC7Protocol.open(TTC7Protocol.java:618)
at oracle.jdbc.driver.OracleStatement.open(OracleStatement.java:575)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2803)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuery(WSJdbcPreparedStatement.java:878)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:559)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1668)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1784)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:2977)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:393)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:374)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:137)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:193)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:101)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)
at org.springframework.orm.hibernate3.HibernateTemplate$1.doInHibernate(HibernateTemplate.java:460)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:362)
at org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:454)
at org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:448)
at ins.framework.dao.EntityDaoHibernate.get(EntityDaoHibernate.java:70)
at ins.framework.dao.GenericDaoHibernate.get(GenericDaoHibernate.java:52)
at cn.com.cis.acic.sales.report.service.spring.ReportScheduleServiceSpringImpl.findByPrimaryKey(ReportScheduleServiceSpringImpl.java:118)
at cn.com.cis.acic.sales.report.service.spring.ReportScheduleServiceSpringImpl$$FastClassByCGLIB$$381a74e6.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:714)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:162)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:652)
at cn.com.cis.acic.sales.report.service.spring.ReportScheduleServiceSpringImpl$$EnhancerByCGLIB$$ed04a4b8.findByPrimaryKey(<generated>)
at cn.com.cis.acic.sales.report.util.schedule.sdk.report.Report.generatorReportFile(Report.java:604)
at cn.com.cis.acic.sales.report.util.schedule.sdk.report.Report.generate(Report.java:543)
at cn.com.cis.acic.sales.report.util.schedule.sdk.report.ReportGroup.generate(ReportGroup.java:192)
at cn.com.cis.acic.sales.report.util.schedule.task.ReportGeneratorTask.generateReports(ReportGeneratorTask.java:59)
at cn.com.cis.acic.sales.report.util.schedule.task.ReportGeneratorTask.execute(ReportGeneratorTask.java:39)
at cn.com.cis.acic.sales.report.util.schedule.ScheduleTask.run(ScheduleTask.java:82)
at java.util.TimerThread.mainLoop(Timer.java:537)
at java.util.TimerThread.run(Timer.java:487)

[oh_Maxy]

一般异常的第一个caused by是最重要的信息。这里异常大概是说cn.com.cis.acic.sales.schema.model.PrpReportSchedule类加载失败。这个entity对应的表，相关配置文件检查下看看有没有错误。

[青春微凉不离伤]

前面还有一部分错误信息，如下： [13-11-5 9:15:47:107 CST] 00000060 AbstractBatch W org.hibernate.jdbc.AbstractBatcher closeQueryStatement exception clearing maxRows/queryTimeout com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: 关闭 Statement。 at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.runtimeXIfNotClosed(WSJdbcStatement.java:1505) at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.getMaxRows(WSJdbcStatement.java:974) at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:272) at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:209) at org.hibernate.loader.Loader.getResultSet(Loader.java:1682) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.loadEntity(Loader.java:1784) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42) at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:2977) at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:393) at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:374) at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:137) at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:193) at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:101) at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878) at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815) at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808) at org.springframework.orm.hibernate3.HibernateTemplate$1.doInHibernate(HibernateTemplate.java:460) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:362) at org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:454) at org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:448) at ins.framework.dao.EntityDaoHibernate.get(EntityDaoHibernate.java:70) at ins.framework.dao.GenericDaoHibernate.get(GenericDaoHibernate.java:52) at cn.com.cis.acic.sales.report.service.spring.ReportScheduleServiceSpringImpl.findByPrimaryKey(ReportScheduleServiceSpringImpl.java:118) at cn.com.cis.acic.sales.report.service.spring.ReportScheduleServiceSpringImpl$$FastClassByCGLIB$$381a74e6.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:714) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:162) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185) at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:652) at cn.com.cis.acic.sales.report.service.spring.ReportScheduleServiceSpringImpl$$EnhancerByCGLIB$$ed04a4b8.findByPrimaryKey(<generated>) at cn.com.cis.acic.sales.report.util.schedule.sdk.report.Report.generatorReportFile(Report.java:604) at cn.com.cis.acic.sales.report.util.schedule.sdk.report.Report.generate(Report.java:543) at cn.com.cis.acic.sales.report.util.schedule.sdk.report.ReportGroup.generate(ReportGroup.java:192) at cn.com.cis.acic.sales.report.util.schedule.task.ReportGeneratorTask.generateReports(ReportGeneratorTask.java:59) at cn.com.cis.acic.sales.report.util.schedule.task.ReportGeneratorTask.execute(ReportGeneratorTask.java:39) at cn.com.cis.acic.sales.report.util.schedule.ScheduleTask.run(ScheduleTask.java:82) at java.util.TimerThread.mainLoop(Timer.java:537) at java.util.TimerThread.run(Timer.java:487) 而且这个问题是偶发性的，服务器是websphere。请教各位，会有什么原因导致连接重置呢？多谢。