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.jav a:143)
at org.postgresql.core.QueryExecutor.execute(QueryExe cutor.java:68)
at org.postgresql.Connection.ExecSQL(Connection.java: 398)
at org.postgresql.jdbc2.Statement.execute(Statement.j ava:130)
at org.postgresql.jdbc2.Statement.executeUpdate(State ment.java:73)
at org.postgresql.jdbc2.PreparedStatement.executeUpda te(PreparedStatement.java:113)
at com.salmonllc.sql.DSDataSourceJDBC.updateRow(DSDat aSourceJDBC.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(C ontractWrapModel.java:381)
at com.eq.controller.operations.contractDefineVariabl eChargesController.submitPerformed(contractDefineV ariableChargesController.java:153)
at com.salmonllc.html.HtmlSubmitButton.executeEvent(H tmlSubmitButton.java:126)
at com.salmonllc.jsp.JspForm.executeEvent(JspForm.jav a:270)
at com.salmonllc.html.HtmlContainer.executeEvent(Html Container.java:82)
at com.salmonllc.html.HtmlPage.processParms(HtmlPage. java:1263)
at com.salmonllc.jsp.JspController.doPost(JspControll er.java:554)
at com.salmonllc.jsp.tags.PageTag.doStartTag(PageTag. java:188)
at org.apache.jsp.contractDefineVariableCharges_jsp._ jspx_meth_salmon_page_0(contractDefineVariableChar ges_jsp.java:164)
at org.apache.jsp.contractDefineVariableCharges_jsp._ jspService(contractDefineVariableCharges_jsp.java: 130)
at com.salmonllc.jsp.JspServlet.service(JspServlet.ja va:300)
at org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:210)
at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:193)
at com.eq.src.compressionFilters.CompressionFilter.do Filter(CompressionFilter.java:238)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(St andardContext.java:2417)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643)
at org.apache.catalina.valves.ErrorDispatcherValve.in voke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:641)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:641)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(Co yoteAdapter.java:193)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:781)
at org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.processConnection(Http11Protocol.jav a:549)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(P oolTcpEndpoint.java:589)
at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:666)
at java.lang.Thread.run(Thread.java:536)