Re: jdbc connection - UnknownHostException

Nick,

Thanks for your answer. But no, no security application can be disturbing that connection. Strange is that it worked for myhost2 and no more with myhost1...
When it worked, it worked great (different select).
If postgresql wasn't accepting connections (pg configuration / firewall), should I not receive another exception than this UnknownHostException?

yann

On Mon, 22 Dec 2003 19:57:39 -0500
"Nick Fankhauser" <nickf(at)ontko(dot)com> wrote:

> 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
>
>
>
>

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