Re: Question about JDBC?

Alex-

Other developers have gotten this message when Firewall or other security
software breaks a connection that has already been established. Apparently
some security software thinks that activity on port 5432 is suspicious.
Regardless of what is causing it, the important piece of information is
"java.net.SocketException: Broken pipe", which is telling you that either
the back end disapppeared unexpectedly, or the network connection was
broken.

Regards,

-Nick

> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Alejandro Vergara
> Sent: Wednesday, August 14, 2002 2:11 PM
> To: pgsql-jdbc@postgresql.org; alexvt@ife.org.mx
> Subject: [JDBC] Question about JDBC?
>
>
> Hi sometimes I catch this exceptions in my aplications:
> *************************************************
> java.sql.SQLException: IOError while reading from backend:
> java.net.SocketException: Broken pipe
>         at postgresql.PG_Stream.ReceiveChar(PG_Stream.java:183)
>         at postgresql.Connection.ExecSQL(Connection.java:668)
>         at postgresql.Connection.setAutoCommit(Connection.java:377)
>         at actas2003.partidos.Partidos.doGet(PartidosPoliticos.java:45)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:499)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
>         at
> org.apache.jserv.JServConnection.processRequest(JServConnection.java:335)
>
>         at
> org.apache.jserv.JServConnection.run(JServConnection.java:197)
>         at java.lang.Thread.run(Thread.java)
> java.sql.SQLException: Error flushing output: java.io.IOException:
> Broken pipe
>         at postgresql.PG_Stream.flush(PG_Stream.java:370)
>         at postgresql.Connection.ExecSQL(Connection.java:659)
>         at postgresql.Connection.setAutoCommit(Connection.java:377)
>         at
> actas2003.funcionarios.catalogo.BuscaFun.doGet(BuscaFun.java:67)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:499)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
>         at
> org.apache.jserv.JServConnection.processRequest(JServConnection.java:335)
>
>         at
> org.apache.jserv.JServConnection.run(JServConnection.java:197)
>         at java.lang.Thread.run(Thread.java)
> java.sql.SQLException: Error flushing output: java.io.IOException:
> Broken pipe
>         at postgresql.PG_Stream.flush(PG_Stream.java:370)
>         at postgresql.Connection.ExecSQL(Connection.java:659)
>         at postgresql.Connection.setAutoCommit(Connection.java:377)
>         at
> actas2003.funcionarios.catalogo.DatosFun.doGet(DatosFun.java:68)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:499)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
>         at
> org.apache.jserv.JServConnection.processRequest(JServConnection.java:335)
>
>         at
> org.apache.jserv.JServConnection.run(JServConnection.java:197)
>         at java.lang.Thread.run(Thread.java)
> **********************************************************
> We don't know if the error is in the driver or is our aplications, the
> extrange is that is not common error, and when ocurred is solved by
> restarting postgres...
>
> The thing that we want to know is if someone can help us to found the
> reason to this error to take actions about it.
>
> Thanks for all.
>
> Alex...
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>