Обсуждение: pq_recvbuf: recv() failed: Connection reset by peer

Hello!

I have a problem with a connection between java and postgresql:

I always get the error message: pq_recvbuf: recv() failed: Connection reset
by peer


Here is my java-code:

public void open() throws Exception {
        try {
         Class.forName( "org.postgresql.Driver" );
         con = DriverManager.getConnection
               ("jdbc:postgresql:ticketline", "Beant", "masterkey");
        }
        catch(ClassNotFoundException e) {
            System.err.println("Failed to load Driver");
            System.exit(1);
        }
        catch(SQLException e) {
            System.err.println("Sql-State "+e.getSQLState());
            System.err.println("ErrorCode: "+ e.getErrorCode());
            e.printStackTrace();
        }

I have updated my classpath and postmaster is running with �-i�. Here are
also the last lines of the pg_hba.conf:

local      all                                 trust
host       all         10.1.52.61 255.255.255.0                trust
host         all        127.0.0.1   255.255.255.255        trust

I have tried to change these settings, but i didnt get a connection�





_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com

Bernd,

This error would (usually) indicate that the connection was successfully
completed, but that the client didn't close the connection before
exiting.  I don't seen in your example below where you are closing the
connection.  And also it would appear that you are not getting any
exception when you create the connection since you don't indicate in
your message any exceptions being thrown on the client side, but only
the warning being reported on the server side.

thanks,
--Barry

Bernd Brenner wrote:
>
> Hello!
>
> I have a problem with a connection between java and postgresql:
>
> I always get the error message: pq_recvbuf: recv() failed: Connection
> reset by peer
>
>
> Here is my java-code:
>
> public void open() throws Exception {
>        try {
>         Class.forName( "org.postgresql.Driver" );
>         con = DriverManager.getConnection
>               ("jdbc:postgresql:ticketline", "Beant", "masterkey");
>        }
>        catch(ClassNotFoundException e) {
>            System.err.println("Failed to load Driver");
>            System.exit(1);
>        }
>        catch(SQLException e) {
>            System.err.println("Sql-State "+e.getSQLState());
>            System.err.println("ErrorCode: "+ e.getErrorCode());
>            e.printStackTrace();
>        }
>
> I have updated my classpath and postmaster is running with “-i”. Here
> are also the last lines of the pg_hba.conf:
>
> local      all                                 trust
> host       all         10.1.52.61 255.255.255.0                trust
> host         all        127.0.0.1   255.255.255.255        trust
>
> I have tried to change these settings, but i didnt get a connection…
>
>
>
>
>
> _________________________________________________________________
> Join the world’s largest e-mail service with MSN Hotmail.
> http://www.hotmail.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

that's it. i've forgotten to close the connection...

thanks
bernd



>From: Barry Lind <barry@xythos.com>
>To: Bernd Brenner <bernd_brenner@hotmail.com>
>CC: pgsql-jdbc@postgresql.org
>Subject: Re: [JDBC] pq_recvbuf: recv() failed: Connection reset by peer
>Date: Fri, 11 Oct 2002 09:35:21 -0700
>
>Bernd,
>
>This error would (usually) indicate that the connection was successfully
>completed, but that the client didn't close the connection before exiting.
>I don't seen in your example below where you are closing the connection.
>And also it would appear that you are not getting any exception when you
>create the connection since you don't indicate in your message any
>exceptions being thrown on the client side, but only the warning being
>reported on the server side.
>
>thanks,
>--Barry
>
>Bernd Brenner wrote:
>>
>>Hello!
>>
>>I have a problem with a connection between java and postgresql:
>>
>>I always get the error message: pq_recvbuf: recv() failed: Connection
>>reset by peer
>>
>>
>>Here is my java-code:
>>
>>public void open() throws Exception {
>>        try {
>>         Class.forName( "org.postgresql.Driver" );
>>         con = DriverManager.getConnection
>>               ("jdbc:postgresql:ticketline", "Beant", "masterkey");
>>        }
>>        catch(ClassNotFoundException e) {
>>            System.err.println("Failed to load Driver");
>>            System.exit(1);
>>        }
>>        catch(SQLException e) {
>>            System.err.println("Sql-State "+e.getSQLState());
>>            System.err.println("ErrorCode: "+ e.getErrorCode());
>>            e.printStackTrace();
>>        }
>>
>>I have updated my classpath and postmaster is running with �-i�. Here are
>>also the last lines of the pg_hba.conf:
>>
>>local      all                                 trust
>>host       all         10.1.52.61 255.255.255.0                trust
>>host         all        127.0.0.1   255.255.255.255        trust
>>
>>I have tried to change these settings, but i didnt get a connection�
>>
>>
>>
>>
>>
>>_________________________________________________________________
>>Join the world�s largest e-mail service with MSN Hotmail.
>>http://www.hotmail.com
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>>




_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx