Postgres Pro
Downloads
Home   >   mailing lists

Thread: Postgres 8.3.7 -- EOF on client connection

Postgres 8.3.7 -- EOF on client connection

From
CM J
Date:
Hi ,

      I installed postgres 8.3.7-1 in my windows machine. The server starts all right.However when i attempt a JDBC connection(Driver used: postgresql-8.3-604.jdbc4.jar), the following error is thrown:

2009-06-24 17:55:03.564 ISTERROR:  relation "befailover" does not exist
2009-06-24 17:55:03.564 ISTSTATEMENT:  SELECT HOSTADDRESS,RMIREGISTRYPORT FROM BEFAILOVER WHERE SERVERROLE='PRIMARY'
2009-06-24 17:55:03.580 ISTERROR:  relation "befailover" does not exist
2009-06-24 17:55:03.580 ISTSTATEMENT:  DELETE  FROM BEFAILOVER WHERE SERVERROLE='STANDBY'
2009-06-24 17:55:12.639 ISTLOG:  could not receive data from client: No connection could be made because the target machine
actively refused it.
2009-06-24 17:55:12.639 ISTLOG:  unexpected EOF on client connection

        I attempt the JDBC connection from the machine as the postgres server. There are no anti-virus server software or firewall involved. Can someone tell me what could be wrong with my setup.

Thanks.

Re: Postgres 8.3.7 -- EOF on client connection

From
Saurabh Dave
Date:
Hi CMJ,

If you are using WebNMS framework with hibernate, can you check if you have done this:

            ConfigReader configReader = ConfigReader.getInstance();
            configReader.modifyHbmToDdl(true);


Thanks,
Saurabh

On Wed, Jun 24, 2009 at 6:06 PM, CM J <postgres.newbie@gmail.com> wrote:
Hi ,

      I installed postgres 8.3.7-1 in my windows machine. The server starts all right.However when i attempt a JDBC connection(Driver used: postgresql-8.3-604.jdbc4.jar), the following error is thrown:

2009-06-24 17:55:03.564 ISTERROR:  relation "befailover" does not exist
2009-06-24 17:55:03.564 ISTSTATEMENT:  SELECT HOSTADDRESS,RMIREGISTRYPORT FROM BEFAILOVER WHERE SERVERROLE='PRIMARY'
2009-06-24 17:55:03.580 ISTERROR:  relation "befailover" does not exist
2009-06-24 17:55:03.580 ISTSTATEMENT:  DELETE  FROM BEFAILOVER WHERE SERVERROLE='STANDBY'
2009-06-24 17:55:12.639 ISTLOG:  could not receive data from client: No connection could be made because the target machine
actively refused it.
2009-06-24 17:55:12.639 ISTLOG:  unexpected EOF on client connection

        I attempt the JDBC connection from the machine as the postgres server. There are no anti-virus server software or firewall involved. Can someone tell me what could be wrong with my setup.

Thanks.

Re: Postgres 8.3.7 -- EOF on client connection

From
CM J
Date:
Hi,

       The problem turned out to be not with postgres but my JDBC connection code.

Thanks !

On Thu, Jun 25, 2009 at 5:25 PM, Saurabh Dave <saurabhdave@gmail.com> wrote:
Hi CMJ,

If you are using WebNMS framework with hibernate, can you check if you have done this:

            ConfigReader configReader = ConfigReader.getInstance();
            configReader.modifyHbmToDdl(true);


Thanks,
Saurabh


On Wed, Jun 24, 2009 at 6:06 PM, CM J <postgres.newbie@gmail.com> wrote:
Hi ,

      I installed postgres 8.3.7-1 in my windows machine. The server starts all right.However when i attempt a JDBC connection(Driver used: postgresql-8.3-604.jdbc4.jar), the following error is thrown:

2009-06-24 17:55:03.564 ISTERROR:  relation "befailover" does not exist
2009-06-24 17:55:03.564 ISTSTATEMENT:  SELECT HOSTADDRESS,RMIREGISTRYPORT FROM BEFAILOVER WHERE SERVERROLE='PRIMARY'
2009-06-24 17:55:03.580 ISTERROR:  relation "befailover" does not exist
2009-06-24 17:55:03.580 ISTSTATEMENT:  DELETE  FROM BEFAILOVER WHERE SERVERROLE='STANDBY'
2009-06-24 17:55:12.639 ISTLOG:  could not receive data from client: No connection could be made because the target machine
actively refused it.
2009-06-24 17:55:12.639 ISTLOG:  unexpected EOF on client connection

        I attempt the JDBC connection from the machine as the postgres server. There are no anti-virus server software or firewall involved. Can someone tell me what could be wrong with my setup.

Thanks.