Re: [INTERFACES] JDBC Connection - Mailing list pgsql-interfaces

From Peter T Mount
Subject Re: [INTERFACES] JDBC Connection
Date
Msg-id Pine.LNX.3.96.980824175848.493Y-100000@maidast.retep.org.uk
Whole thread Raw
In response to Re: [INTERFACES] JDBC Connection  (Eric Marsden <emarsden@mail.dotcom.fr>)
List pgsql-interfaces
On 24 Aug 1998, Eric Marsden wrote:

> >>>>> "DrH" == Herrera  <drherlams@diandel.com> writes:
>
>   DrH> I am trying to connect to PostgreSQL from Java (JDK 1.1.6)
>   DrH> under RedHat Linux 5.1 using the JDBC interface. I have
>   DrH> compiled the driver and tried to run the examples this way:
>   DrH>
>   DrH> java -Djdbc.drivers=postgresql.Driver example.basic jdbc:postgresql:prueba
>   DrH> postgres postgres
>   DrH>
>   DrH> where 'prueba' is the name of an existing database.
>   DrH> But I always get a 'Connection refused' error in
>   DrH> DriverManager.getConnection("jdbc:postgresql:prueba")
>   DrH>
>   DrH> I have modified pg_hba.conf to allow any user on any host
>   DrH> access to any database but the error still remains.
>
> Possible solution: have you started the database with the `-i' option
> (to allow TCP/IP connections, which are used by the JDBC interface)?

Yes. Java doesn't support Unix domain sockets (without using native code),
so TCP is the only option. When ever "Connection refused" occurs, it's
because there is nothing listening on the port, so -i is the culprit.

> Read the postmaster manual page for more details.
>
> --
> Eric Marsden
> emarsden @ mail.dotcom.fr
> It's elephants all the way down
>

--
       Peter T Mount peter@retep.org.uk
      Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
 Java PDF Generator: http://www.retep.org.uk/pdf


pgsql-interfaces by date:

Previous
From: Jouni Ahto
Date:
Subject: Re: [INTERFACES] Convert PGconn, PGresult to opaque types?
Next
From: "John Sharp"
Date:
Subject: postgresql for sparc 2.5.1?