Hello everybody work for postgre:
I have a problem for i/o error when i using java programming.it happend
when I disconnect database.but ,i'm not sure its database'bug or my
programming'bug.I follow a text in attachment.
I hope your help!
thanks !
eagle shi from china
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from
fulfilling this request.
exception
javax.servlet.ServletException: Hibernate operation: could not execute query;
uncategorized SQLException for SQL [select tproductty0_.typeid as typeid9_,
tproductty0_.parentid as parentid9_, tproductty0_.isleaf as isleaf9_,
tproductty0_.typename as typename9_, tproductty0_.comments as comments9_,
tproductty0_.menuorder as menuorder9_ from public.t_product_type tproductty0_
where tproductty0_.parentid=? order by tproductty0_.menuorder desc]; SQL state
[08006]; error code [0]; An I/O error occured while sending to the backend.;
nested exception is org.postgresql.util.PSQLException: An I/O error occured
while sending to the backend.
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:545)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:486)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77)
com.auto.util.EncodingFilter.doFilter(EncodingFilter.java:34)
root cause
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could
not execute query; uncategorized SQLException for SQL [select
tproductty0_.typeid as typeid9_, tproductty0_.parentid as parentid9_,
tproductty0_.isleaf as isleaf9_, tproductty0_.typename as typename9_,
tproductty0_.comments as comments9_, tproductty0_.menuorder as menuorder9_ from
public.t_product_type tproductty0_ where tproductty0_.parentid=? order by
tproductty0_.menuorder desc]; SQL state [08006]; error code [0]; An I/O error
occured while sending to the backend.; nested exception is
org.postgresql.util.PSQLException: An I/O error occured while sending to the
backend.
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:97)
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:258)
org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:411)
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:371)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:844)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:840)
com.auto.dao.hibernate.TProductTypeDAO.findByParentid(TProductTypeDAO.java:99)
com.auto.business.service.ProductTypeBO.getTreeList(ProductTypeBO.java:211)
com.auto.business.service.ProductTypeBO.getTreeList(ProductTypeBO.java:227)
com.auto.business.service.ProductTypeBO.getTreeList(ProductTypeBO.java:227)
com.auto.business.service.ProductTypeBO.getTreeList(ProductTypeBO.java:227)
com.auto.business.service.ProductTypeBO.getTreeList(ProductTypeBO.java:227)
com.auto.business.service.ProductTypeBO.getTree(ProductTypeBO.java:207)
sun.reflect.GeneratedMethodAccessor232.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:165)
$Proxy10.getTree(Unknown Source)
com.auto.web.action.ProductTypeAction.getList(ProductTypeAction.java:429)
com.auto.web.action.ProductTypeAction.modi(ProductTypeAction.java:161)
sun.reflect.GeneratedMethodAccessor233.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77)
com.auto.util.EncodingFilter.doFilter(EncodingFilter.java:34)
root cause
org.postgresql.util.PSQLException: An I/O error occured while sending to the
backend.
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:217)
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255)
com.mchange.v2.sql.filter.FilterPreparedStatement.executeQuery(FilterPreparedStatement.java:68)
com.mchange.v2.c3p0.impl.C3P0PooledConnection$2.executeQuery(C3P0PooledConnection.java:567)
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
org.hibernate.loader.Loader.doQuery(Loader.java:662)
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
org.hibernate.loader.Loader.doList(Loader.java:2145)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
org.hibernate.loader.Loader.list(Loader.java:2024)
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
org.springframework.orm.hibernate3.HibernateTemplate$31.doInHibernate(HibernateTemplate.java:853)
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:844)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:840)
com.auto.dao.hibernate.TProductTypeDAO.findByParentid(TProductTypeDAO.java:99)
com.auto.business.service.ProductTypeBO.getTreeList(ProductTypeBO.java:211)
com.auto.business.service.ProductTypeBO.getTreeList(ProductTypeBO.java:227)
com.auto.business.service.ProductTypeBO.getTreeList(ProductTypeBO.java:227)
com.auto.business.service.ProductTypeBO.getTreeList(ProductTypeBO.java:227)
com.auto.business.service.ProductTypeBO.getTreeList(ProductTypeBO.java:227)
com.auto.business.service.ProductTypeBO.getTree(ProductTypeBO.java:207)
sun.reflect.GeneratedMethodAccessor232.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:165)
$Proxy10.getTree(Unknown Source)
com.auto.web.action.ProductTypeAction.getList(ProductTypeAction.java:429)
com.auto.web.action.ProductTypeAction.modi(ProductTypeAction.java:161)
sun.reflect.GeneratedMethodAccessor233.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77)
com.auto.util.EncodingFilter.doFilter(EncodingFilter.java:34)
root cause
java.io.IOException: Stream closed
sun.nio.cs.StreamEncoder.ensureOpen(StreamEncoder.java:38)
sun.nio.cs.StreamEncoder.flush(StreamEncoder.java:151)
java.io.OutputStreamWriter.flush(OutputStreamWriter.java:213)
org.postgresql.core.PGStream.flush(PGStream.java:507)
org.postgresql.core.v3.QueryExecutorImpl.sendSync(QueryExecutorImpl.java:675)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:190)
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255)
com.mchange.v2.sql.filter.FilterPreparedStatement.executeQuery(FilterPreparedStatement.java:68)
com.mchange.v2.c3p0.impl.C3P0PooledConnection$2.executeQuery(C3P0PooledConnection.java:567)
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
org.hibernate.loader.Loader.doQuery(Loader.java:662)
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
org.hibernate.loader.Loader.doList(Loader.java:2145)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
org.hibernate.loader.Loader.list(Loader.java:2024)
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
org.springframework.orm.hibernate3.HibernateTemplate$31.doInHibernate(HibernateTemplate.java:853)
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:844)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:840)
com.auto.dao.hibernate.TProductTypeDAO.findByParentid(TProductTypeDAO.java:99)
com.auto.business.service.ProductTypeBO.getTreeList(ProductTypeBO.java:211)
com.auto.business.service.ProductTypeBO.getTreeList(ProductTypeBO.java:227)
com.auto.business.service.ProductTypeBO.getTreeList(ProductTypeBO.java:227)
com.auto.business.service.ProductTypeBO.getTreeList(ProductTypeBO.java:227)
com.auto.business.service.ProductTypeBO.getTreeList(ProductTypeBO.java:227)
com.auto.business.service.ProductTypeBO.getTree(ProductTypeBO.java:207)
sun.reflect.GeneratedMethodAccessor232.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:165)
$Proxy10.getTree(Unknown Source)
com.auto.web.action.ProductTypeAction.getList(ProductTypeAction.java:429)
com.auto.web.action.ProductTypeAction.modi(ProductTypeAction.java:161)
sun.reflect.GeneratedMethodAccessor233.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77)
com.auto.util.EncodingFilter.doFilter(EncodingFilter.java:34)
note The full stack trace of the root cause is available in the Apache
Tomcat/5.5.25 logs.
--------------------------------------------------------------------------------
Apache Tomcat/5.5.25
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
