From: | Peter T Mount <peter(at)retep(dot)org(dot)uk> |
---|---|
To: | Eric Marsden <emarsden(at)mail(dot)dotcom(dot)fr> |
Cc: | "Dr(dot) Herrera" <drherlams(at)diandel(dot)com>, pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: [INTERFACES] JDBC Connection |
Date: | 1998-08-24 16:59:58 |
Message-ID: | Pine.LNX.3.96.980824175848.493Y-100000@maidast.retep.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
On 24 Aug 1998, Eric Marsden wrote:
> >>>>> "DrH" == Herrera <drherlams(at)diandel(dot)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(at)retep(dot)org(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | John Sharp | 1998-08-24 18:44:00 | postgresql for sparc 2.5.1? |
Previous Message | Jouni Ahto | 1998-08-24 16:47:21 | Re: [INTERFACES] Convert PGconn, PGresult to opaque types? |