Re: jdbc connection problem

From: Kris Jurka <books(at)ejurka(dot)com>
To: david(at)mediagonal(dot)ch
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: jdbc connection problem
Date: 2007-02-01 17:33:39
Message-ID: Pine.BSO.4.64.0702011232170.7805@leary2.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Thu, 1 Feb 2007, david(at)mediagonal(dot)ch wrote:

> i have a problem connecting to postgres using the jdbc driver.
>
> String url = "jdbc:postgresql://localhost/testdb";
> String user = "username";
> String pass = "password";
>
>
> i get the exception org.postgresql.util.PSQLException: Connection
> Refused. Check that the hostname and port are correct and that the
> postmaster is accepting TCP/IP connections.
>
> however, using psql -h localhost -U username -W and then specifying the
> password works. so i do not see how this could be a general problem with
> postgresql listening on the wrong interface or not accepting connections
> from the local host.
>
> btw, i use psql 8.1.4 on ubuntu, jdbc is postgresql-8.1-408.jdbc2.jar
>

Debian variants often have multiple servers installed on multiple ports.
Try adding explicit port numbers to both psql and jdbc connections to
ensure that you're getting the same thing.

Kris Jurka

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2007-02-01 17:52:45 Re: getArray() and char[]
Previous Message Kris Jurka 2007-02-01 17:32:05 Re: Any reason for PSQLState not to be Serializable?