论坛首页 入门技术论坛

流已关闭让我疯掉

浏览 3851 次
该帖已经被评为新手帖
作者 正文
   发表时间:2007-04-11  
   最近自己做个小系统玩 尝试下spring+webwork+hibernate,系统中还存在着一些问题,当然先把首要问题给解决掉,当我每次登录后,如果长时间没动作,再去点击新闻链接就会出现如下错误代码 一直修改 仔细检查都没找出错误 可能真的是学的太浅,所以希望有这方面经验的来帮忙解决下
09:25:15,140 ERROR [http-8562-Processor25] JDBCExceptionReporter:58 - 流已被关闭
09:25:15,218 ERROR [http-8562-Processor25] JDBCExceptionReporter:58 - 流已被关闭
09:25:15,265 ERROR [http-8562-Processor25] ServletDispatcher:281 - Could not execute action
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not load: [com.eric.java.ericzone.object.EricNews#502]; uncategorized SQLException for SQL []; SQL state [null]; error code [17027]; 流已被关闭; nested exception is java.sql.SQLException: 流已被关闭
java.sql.SQLException: 流已被关闭
	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:269)
	at oracle.jdbc.ttc7.LongTTCItem.getChars(LongTTCItem.java:189)
	at oracle.jdbc.dbaccess.DBDataSetImpl.getCharsStreamItem(DBDataSetImpl.java:1630)
	at oracle.jdbc.driver.OracleStatement.getCharsInternal(OracleStatement.java:3347)
	at oracle.jdbc.driver.OracleStatement.getStringValue(OracleStatement.java:3556)
	at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:434)
	at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1482)
	at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:224)
	at net.sf.hibernate.type.StringType.get(StringType.java:18)
	at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:62)
	at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:53)
	at net.sf.hibernate.type.AbstractType.hydrate(AbstractType.java:67)
	at net.sf.hibernate.loader.Loader.hydrate(Loader.java:690)
	at net.sf.hibernate.loader.Loader.loadFromResultSet(Loader.java:631)
	at net.sf.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:590)
	at net.sf.hibernate.loader.Loader.getRow(Loader.java:505)
	at net.sf.hibernate.loader.Loader.getRowFromResultSet(Loader.java:218)
	at net.sf.hibernate.loader.Loader.doQuery(Loader.java:285)
	at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
	at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:941)
	at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:961)
	at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:59)
	at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:51)
	at net.sf.hibernate.persister.EntityPersister.load(EntityPersister.java:413)
	at net.sf.hibernate.impl.SessionImpl.doLoad(SessionImpl.java:2131)
	at net.sf.hibernate.impl.SessionImpl.doLoadByClass(SessionImpl.java:2001)
	at net.sf.hibernate.impl.SessionImpl.load(SessionImpl.java:1930)
	at org.springframework.orm.hibernate.HibernateTemplate$2.doInHibernate(HibernateTemplate.java:419)
	at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:317)
	at org.springframework.orm.hibernate.HibernateTemplate.load(HibernateTemplate.java:413)
	at org.springframework.orm.hibernate.HibernateTemplate.load(HibernateTemplate.java:408)
	at com.eric.java.basecontainer.hibernate.AbstractService.load(AbstractService.java:31)
	at com.eric.java.ericzone.services.EricNewsService.getEricNews(EricNewsService.java:35)
	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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:292)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
	at $Proxy1.getEricNews(Unknown Source)
	at com.eric.java.ericzone.action.news.ListIndexNewsAction.execute(ListIndexNewsAction.java:28)
	at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:283)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:166)
	at com.eric.java.basecontainer.webwork.interceptor.ComponentAutowireInterceptor.intercept(ComponentAutowireInterceptor.java:22)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:164)
	at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:164)
	at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:164)
	at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:164)
	at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:164)
	at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116)
	at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:272)
	at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:237)
	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.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:172)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
	at com.eric.java.basecontainer.basetool.EncodingFilter.doFilter(EncodingFilter.java:36)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
	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.coyote.http11.Http11Processor.process(Http11Processor.java:799)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
	at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
	at java.lang.Thread.run(Thread.java:595)
09:28:56,843 ERROR [http-8562-Processor23] JDBCExceptionReporter:58 - 流已被关闭
09:28:56,859 ERROR [http-8562-Processor23] JDBCExceptionReporter:58 - 流已被关闭

我在AbstractService 文件中是通过这样获得对象
public class AbstractService extends HibernateDaoSupport{
......
	public Object load(Class classType, Serializable id)throws ServicesException {
		return (Object)this.getHibernateTemplate().load(classType, id);
	}
......
}

spring配置文件中我对事务等处理是这样配置的
	<bean id="baseTxProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean" abstract="true">
		<property name="transactionManager">
			<ref bean="transactionManager" />
		</property>
		<property name="transactionAttributes">
			<props>
				<prop key="insert*">PROPAGATION_REQUIRED</prop>
				<prop key="update*">PROPAGATION_REQUIRED</prop>
				<prop key="delete*">PROPAGATION_REQUIRED</prop>
			<prop key="get*">PROPAGATION_REQUIRED</prop>

			</props>
		</property>
	</bean>

每当我长时间没动作后再 调用这个语句的时候
ericnews=super.getEricnewsAware().getEricNews(new Integer(this.id));

就会出现上面我列出来的错误,我已经快被折磨的疯掉了
论坛首页 入门技术版

跳转论坛:
Global site tag (gtag.js) - Google Analytics