org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:143)
am 02.08.2004 08:51:25 von smitamardaHi,
I have been using SOFIA framework and postgres
database as a backend.
i noticed as the database started growing larger..
today
encountered some error while firing a query to save a
record. The table in which i am going to save the
record, has two columns having datatype text. the data
of these two column contains 2652 and 5817 characters.
If I reduce some characters from both columns, it
saves the record successfully. But i reduce some
characters from only single column(whether it has 2652
chars or 5817 chars whereas both have the same
datatype), it gives me the following error :--
[Stack Trace
The backend has broken the connection. Possibly the
action you have attempted has caused it to close.
at
org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:143)
at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java :68)
at
org.postgresql.Connection.ExecSQL(Connection.java:398)
at
org.postgresql.jdbc2.Statement.execute(Statement.java:130)
at
org.postgresql.jdbc2.Statement.executeUpdate(Statement.java: 73)
at
org.postgresql.jdbc2.PreparedStatement.executeUpdate(Prepare dStatement.java:113)
at
com.salmonllc.sql.DSDataSourceJDBC.updateRow(DSDataSourceJDB C.java:753)
at
com.salmonllc.sql.DataStore.update(DataStore.java:1965)
at
com.salmonllc.sql.DataStore.update(DataStore.java:1907)
at
com.eq.model.operations.contractChargeModel.update(contractC hargeModel.java:426)
at
com.eq.model.operations.ContractWrapModel.update(ContractWra pModel.java:381)
at
com.eq.controller.operations.contractDefineVariableChargesCo ntroller.submitPerformed(contractDefineVariableChargesContro ller.java:153)
at
com.salmonllc.html.HtmlSubmitButton.executeEvent(HtmlSubmitB utton.java:126)
at
com.salmonllc.jsp.JspForm.executeEvent(JspForm.java:270)
at
com.salmonllc.html.HtmlContainer.executeEvent(HtmlContainer. java:82)
at
com.salmonllc.html.HtmlPage.processParms(HtmlPage.java:1263)
at
com.salmonllc.jsp.JspController.doPost(JspController.java:55 4)
at
com.salmonllc.jsp.tags.PageTag.doStartTag(PageTag.java:188)
at
org.apache.jsp.contractDefineVariableCharges_jsp._jspx_meth_ salmon_page_0(contractDefineVariableCharges_jsp.java:164)
at
org.apache.jsp.contractDefineVariableCharges_jsp._jspService (contractDefineVariableCharges_jsp.java:130)
at
com.salmonllc.jsp.JspServlet.service(JspServlet.java:300)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServl etWrapper.java:210)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServl et.java:295)
at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java :241)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:193)
at
com.eq.src.compressionFilters.CompressionFilter.doFilter(Com pressionFilter.java:238)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:213)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:256)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.catalina.core.StandardContext.invoke(StandardCont ext.java:2417)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:180)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(Error DispatcherValve.java:171)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:172)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:174)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapte r.java:193)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:781)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:549)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndp oint.java:589)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:666)
at java.lang.Thread.run(Thread.java:536)
___________________________________________________________A LL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster