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)







__________________________________________________ _________ALL-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

On Mon, 2 Aug 2004, [iso-8859-1] Smita Marda wrote:

This looks like it could be a server crash. Does the server's log show
anything informative? Also you don't mention what server and JDBC driver
version you are using, but the stacktrace tells me the driver must be from
the 7.2 or earlier release. If the server log doesn't reveal anything you
might try upgrading the JDBC driver to a later version.

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org