FATAL 1: Password authentication failed

Hi

I have tested some java code to connect to PostgreSQL database using 'trust'
relationship, which works.

quote:
----------------------------------------------------------------------------
----
[snathan@sip008 security]$ java Sample
DAtabase :PostGRESQL
Inside Main of Sample ####
Here
Database Driver rg.postgresql.Driver
Database Datasource :jdbcostgresql://192.168.66.3:5432/test
Database Login :u_test
Database Password :u_test
----------------------------------------------------------------------------
----



However, when I change the pg_hba.conf to have 'password' or 'md5' or
'crypt', the connection fails with the above error. But, I am able to
connect using 'psql' ...

quote:
----------------------------------------------------------------------------
----
[snathan@sip008 security]$ java Sample
DAtabase :PostGRESQL
Inside Main of Sample ####
Here
Database Driver rg.postgresql.Driver
Database Datasource :jdbcostgresql://192.168.66.3:5432/test
Database Login :u_test
Database Password :u_test
Something unusual has occured to cause the driver to fail. Please report
this exception: Exception: java.sql.SQLException: FATAL 1: Password
authentication failed for user "u_test"

Stack Trace:

java.sql.SQLException: FATAL 1: Password authentication failed for user
"u_test"

at org.postgresql.Connection.openConnection(Connection.java:178)
at org.postgresql.Driver.connect(Driver.java:149)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at Sample.getConnectionToDatabase(Sample.java:58)
at Sample.main(Sample.java:22)
End of Stack Trace

at org.postgresql.Driver.connect(Driver.java:166)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at Sample.getConnectionToDatabase(Sample.java:58)
at Sample.main(Sample.java:22)

----------------------------------------------------------------------------
----

Thanks for your valuable input.

Best Regards.

Godson R.
Chennai, India.