Error 08S01 (COMMUNICATION_ERROR)

[Jaime Vizán <jvizan(at)seglan(dot)com>]

Hi,

 

I’m using PostgresSQL 7.4.7, pg74.215.jdbc3.jar in a computer which has Debian GNU/Linux 3.1. Sometimes, when the database’s connection is going to close I get the next PSQLException:

 

org.postgresql.util.PSQLException: An I/O error has occured while flushing the output - Exception: java.net.SocketException:

Socket closed

Stack Trace:

 

java.net.SocketException: Socket closed

        at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:99)

        at java.net.SocketOutputStream.write(SocketOutputStream.java:136)

        at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:66)

        at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:124)

        at org.postgresql.core.PGStream.flush(PGStream.java:411)

        at org.postgresql.jdbc1.AbstractJdbc1Connection.closeV3(AbstractJdbc1Connection.java:1147)

        at org.postgresql.jdbc1.AbstractJdbc1Connection.close(AbstractJdbc1Connection.java:1133)

            ………

 

End of Stack Trace

 

        at org.postgresql.core.PGStream.flush(PGStream.java:415)

        at org.postgresql.jdbc1.AbstractJdbc1Connection.closeV3(AbstractJdbc1Connection.java:1147)

        at org.postgresql.jdbc1.AbstractJdbc1Connection.close(AbstractJdbc1Connection.java:1133)

        at com.seglan.helena.BDConn.close(BDConn.java:112)

        at com.seglan.helena.aplicaciones.DownloadDevolD.finalize(DownloadDevolD.java:154)

        at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)

        at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)

        at java.lang.ref.Finalizer.access$100(Finalizer.java:14)

        at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160)

 

I have catch this exception and I have got…

 

PSQLException's error code: 0

PSQLException's cause: null

PSQLException's sql state: 08S01

 

The PSQLException’s sql state tell me about COMMUNICATION ERROR but PSQLException’s error code tell me about Successful Completion. I dont know whether there is an error. I am confuse.

Does anyone explain me why happen this?

 

Thanks in advance.