org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:143) - Mailing list pgsql-sql

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