Thread: JDBC Error wtih 6.3

JDBC Error wtih 6.3

From
"Schlough, Mark"
Date:
     Hi,

     I just installed PostgreSQL 6.3 two days ago. After getting the
     postmaster to run without getting the Memory errors that complain
     about the IPC stuff, I tried to get my java application running
again.

     I was using 6.2.1 and was able to get some of the database
     functionality working.  But when I run the SAME CODE with the 6.3
data
     base I get an SQLException error.  Connection Refused.

     I am able to look at the database with the psql interface and
create a
     table, when I run my java program to create a database I get the
     "Connection Refused" stuff.  I made sure that the postgresql.jar
files
     were replaced with the 6.3 versions.  No go.

     Any advice about this situation.  The "Java in a Nutshell" book
     suggested looking to see if the port was "on" or "listening."  I
know
     that its configured to use port 5432 (the default), but I don't
have
     any way of confirming that the port is listening.

     Can anybody help?

     Mark


RE: [INTERFACES] JDBC Error wtih 6.3

From
Larry Anderson
Date:
Many people, myself included, had problems in that the -i option was not
included on the startup of the postmaster.  Without the -i option TCP/IP
sockets are not running.  Try the -i option if you haven't already.

Larry

On 05-Mar-98 Schlough, Mark wrote:
>      Hi,
>
>      I just installed PostgreSQL 6.3 two days ago. After getting the
>      postmaster to run without getting the Memory errors that complain
>      about the IPC stuff, I tried to get my java application running
> again.
>
>      I was using 6.2.1 and was able to get some of the database
>      functionality working.  But when I run the SAME CODE with the 6.3
> data
>      base I get an SQLException error.  Connection Refused.
>
>      I am able to look at the database with the psql interface and
> create a
>      table, when I run my java program to create a database I get the
>      "Connection Refused" stuff.  I made sure that the postgresql.jar
> files
>      were replaced with the 6.3 versions.  No go.
>
>      Any advice about this situation.  The "Java in a Nutshell" book
>      suggested looking to see if the port was "on" or "listening."  I
> know
>      that its configured to use port 5432 (the default), but I don't
> have
>      any way of confirming that the port is listening.
>
>      Can anybody help?
>
>      Mark
>

Re: JDBC Error wtih 6.3

From
Peter T Mount
Date:
On Thu, 5 Mar 1998, Schlough, Mark wrote:

>      Hi,
>
>      I just installed PostgreSQL 6.3 two days ago. After getting the
>      postmaster to run without getting the Memory errors that complain
>      about the IPC stuff, I tried to get my java application running
> again.
>
>      I was using 6.2.1 and was able to get some of the database
>      functionality working.  But when I run the SAME CODE with the 6.3
> data
>      base I get an SQLException error.  Connection Refused.
>
>      I am able to look at the database with the psql interface and
> create a
>      table, when I run my java program to create a database I get the
>      "Connection Refused" stuff.  I made sure that the postgresql.jar

If the driver reports "Connection Refused" then there is nothing listening
on the server. Check the -i option to postmaster.

--
Peter T Mount  petermount@earthling.net or pmount@maidast.demon.co.uk
Main Homepage: http://www.demon.co.uk/finder
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk