Thread: JDBC bug?

Dear List,

I found the following bug:
Connect to database with password that contains special chars (E.g.:
Nyárfa10)  DriverManager.getConnection( dbUrl,   user,  pwd); will fail
with:
org.postgresql.util.PSQLException: FATAL: password authentication failed
for user "xy"

jdbc driver: 8-3-603 with 8.3.6 postgresql
 From pgadmin connection is good with 'Nyárfa10' password.

Best Regards,
    Ferenc

On Wed, 11 Feb 2009, Lutischán Ferenc wrote:

> I found the following bug:
> Connect to database with password that contains special chars (E.g.:
> Nyárfa10)  DriverManager.getConnection( dbUrl,   user,  pwd); will fail with:
> org.postgresql.util.PSQLException: FATAL: password authentication failed for
> user "xy"
>
> jdbc driver: 8-3-603 with 8.3.6 postgresql
> From pgadmin connection is good with 'Nyárfa10' password.
>

A change to fix this has been made to the 8.4 driver series, so you will
need to try the 8.4dev release.  It sends the password in UTF-8, which
means you must set the password when connected to a UTF-8 database so it
gets stored that way it the database.

Kris Jurka

Dear Kris,

Thanks for suggestion, it's working!

Regards,
    Ferenc

Kris Jurka wrotte:
>
>
> On Wed, 11 Feb 2009, Lutischán Ferenc wrote:
>
>> I found the following bug:
>> Connect to database with password that contains special chars (E.g.:
>> Nyárfa10)  DriverManager.getConnection( dbUrl,   user,  pwd); will
>> fail with:
>> org.postgresql.util.PSQLException: FATAL: password authentication
>> failed for user "xy"
>>
>> jdbc driver: 8-3-603 with 8.3.6 postgresql
>> From pgadmin connection is good with 'Nyárfa10' password.
>>
>
> A change to fix this has been made to the 8.4 driver series, so you
> will need to try the 8.4dev release.  It sends the password in UTF-8,
> which means you must set the password when connected to a UTF-8
> database so it gets stored that way it the database.
>
> Kris Jurka