Postgres 8.3.7 -- EOF on client connection
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.
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:
Show quoted text
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.
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:
Show quoted text
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,
SaurabhOn 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.