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)