From: Smita Marda <smitamarda@yahoo.co.uk>
To: pgsql-sql@postgresql.org
Subject: org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:143)
Date: Mon, 2 Aug 2004 07:51:25 +0100 (BST)
Message-ID: <20040802065125.3772.qmail@web53104.mail.yahoo.com> (raw)
Hi,
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(PreparedStatement.java:113)
at
com.salmonllc.sql.DSDataSourceJDBC.updateRow(DSDataSourceJDBC.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(contractChargeModel.java:426)
at
com.eq.model.operations.ContractWrapModel.update(ContractWrapModel.java:381)
at
com.eq.controller.operations.contractDefineVariableChargesController.submitPerformed(contractDefineVariableChargesController.java:153)
at
com.salmonllc.html.HtmlSubmitButton.executeEvent(HtmlSubmitButton.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:554)
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(JspServletWrapper.java:210)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.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.internalDoFilter(ApplicationFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at
com.eq.src.compressionFilters.CompressionFilter.doFilter(CompressionFilter.java:238)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666)
at java.lang.Thread.run(Thread.java:536)
___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: smitamarda@yahoo.co.uk
Subject: Re: org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:143)
In-Reply-To: <20040802065125.3772.qmail@web53104.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox