Re: jdbc connection - UnknownHostException

Yann-

Is it possible that some security software (firewall or such) is running on
myhostn.org which might regard activity on port 5432 suspicious & close the
connection? Sometimes when connections seem to work & then quickly stop,
this is the cause.

-Nick

> -----Original Message-----
> From: pgsql-jdbc-owner(at)postgresql(dot)org
> [mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Yann Calderara
> Sent: Monday, December 22, 2003 7:00 PM
> To: pgsql-jdbc(at)postgresql(dot)org
> Subject: [JDBC] jdbc connection - UnknownHostException
>
>
> Hello list,
> Can anyone help me with this issue?
> I'm trying to write a bean (used within the struts framwork) that
> gives some methods about managing the database, located on
http://myhost1.org. After some attempts, the connection succeded, but when a
tried it again, I received an UnknownHostException. I've then tried after
many things to connect through the db with another alias, http://myhost2.org
(which is the very same ip than myhost1.org), and it works a few times.

I've then written a small test class, which looks very like what is in the
bean, to connect on a postgresql:

Class.forName("org.postgresql.Driver"); //load the driver
db=DriverManager.getConnection("jdbc:postgresql://myhost1.org:5432/dbname",
"user", "pwd");
//...
db.close();

and it works fine, no exceptions (loading driver and connecting ok).
But in the same time, the connection in the bean does not succeed any
more...

The driver is always correctly loaded.
What am I missing? thanks for any answer :)
yann

--
Yann Calderara <cy(at)netlabs(dot)org>
OpenPGP: 8E31751C / 26EA EDA3 1671 CCCF 815D 89A4 307D 4B8E 8E31 751C