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
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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
