dhtmlx tree issue in struts

Hi,



I am using struts, when I try change the tree’s single item means its working perfectly without any problem, able to update the databases easily.



But when I try to update multiple items at a time in tree I am getting the following errors, I am unable to solve this problem, can you kindly guide me how to solve this problem. Getting org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.



I am using Struts 2.0 and PostgreSQL.



Regards,

R. Subramanian







org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.

    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:201)

    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:392)

    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:330)

    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:240)

    at update.DataBase.Pastepeoples(DataBase.java:296)

    at update.DataBase.copyPastegroups(DataBase.java:266)

    at update.DataBase.insertNode(DataBase.java:469)

    at update.XmlGenerator.createUpdateXML(XmlGenerator.java:106)

    at org.apache.jsp.pages.update_jsp._jspService(update_jsp.java:58)

    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)

    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)

    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

    at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:413)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)

    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)

    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)

    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)

    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)

    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)

    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)

    at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)

    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)

    at java.lang.Thread.run(Thread.java:595)

Caused by: java.io.IOException: Stream closed

    at sun.nio.cs.StreamEncoder.ensureOpen(StreamEncoder.java:38)

    at sun.nio.cs.StreamEncoder.flush(StreamEncoder.java:151)

    at java.io.OutputStreamWriter.flush(OutputStreamWriter.java:213)

    at org.postgresql.core.PGStream.flush(PGStream.java:493)

    at org.postgresql.core.v3.QueryExecutorImpl.sendSync(QueryExecutorImpl.java:631)

    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:174)

    … 31 more

java.lang.NullPointerException

    at update.XmlGenerator.createUpdateXML(XmlGenerator.java:117)

    at org.apache.jsp.pages.update_jsp._jspService(update_jsp.java:58)

    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)

    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)

    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

    at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:413)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)

    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)

    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)

    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)

    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)

    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)

    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)

    at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)

    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)

    at java.lang.Thread.run(Thread.java:595)

The error which occurs in your case seems not related to client side code of component, most probably it caused by incorrect query against DB.
You can try to log the query which cause errors - it will give more info to detect why problem occurs.