Re: Exception "The connection attempt failed." (didn't find - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Exception "The connection attempt failed." (didn't find
Date
Msg-id 42570D82.5070201@opencloud.com
Whole thread Raw
In response to Exception "The connection attempt failed." (didn't find anything elsewhere)  ("Pedro n/a" <napalmblood@hotmail.com>)
List pgsql-jdbc
Pedro n/a wrote:

>  I'm quite new at java and I was just following a tutorial when I bumped
> with a horrible exception. [...]

> Caused by: java.net.UnknownHostException: localhost
>        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:153)

This is the underlying problem. If you do not specify a host to connect
to, the JDBC driver defaults to connecting to localhost, but for some
reason your system cannot resolve localhost.

The solution is to fix hostname resolution on your system. I can't give
you any suggestions as to how to do this as you didn't say anything
about the OS that you are using, but something is pretty broken if you
can't resolve localhost.

A workaround might be to provide an explicit IP address in the driver
URL, e.g. instead of 'jdbc:postgresql:databasename' use something like
'jdbc:postgresql://127.0.0.1/databasename'.

-O

pgsql-jdbc by date:

Previous
From: "Pedro n/a"
Date:
Subject: Exception "The connection attempt failed." (didn't find anything elsewhere)
Next
From: Kris Jurka
Date:
Subject: Re: Version 8.0-310 and PreparedStatement.getParameterMetaData()