Re: DriverManager.getConnection() fails sometimes but succeeds other times

Michael E Mercer <mmercer@lboard.com> wrote in message

news:<3C960A14.B45611B@lboard.com>...

Hello,

I have a java program running as root and tries to connect to database
as user
'A' with password 'A'.

The pg_hba.conf is set to allow users to connect from any host with md5
authentication.

The java program uses the same method to connect to the database,
however
sometimes authentication
succeeds and sometimes it fails. The user and password are hard coded,
so there
is no probable error there.

I have the very same problem here - Postgres 7.2 on RH 7.2, JDBC driver is
[PostgreSQL 7.2b5 JDBC2] from the official site

getConnection seems to fail when called after some period of inactivity, but
if a subsequent attempt is made then it is successful

a sample code would look like:

Connection conn =
DriverManager.getConnection("jdbc:postgresql://192.168.128.208:5432/gate09?u
ser=gateadmin&password=gate");

the pg_hba.conf contains:

=============
host all 192.168.128.42 255.255.255.255 md5
host all 212.50.14.155 255.255.255.255 md5
=============

...where the above are the two IPs of my machine (the JDBC client)

the log file contains:

==========
FATAL 1: Password authentication failed for user "gateadmin"
DEBUG: pq_recvbuf: recv() failed: Connection reset by peer
==========

any hints?

thanx,

Marin

----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "