Re: post - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: post
Date
Msg-id Pine.BSO.4.64.0809301052250.16033@leary.csoft.net
Whole thread Raw
In response to post  ("Andrey Kikhtenko" <A.Kikhtenko@tscrm.com>)
List pgsql-jdbc

On Tue, 30 Sep 2008, Andrey Kikhtenko wrote:

> I have postgreSQL database (server & database encoding - utf-8. Version
> - 8.3)
>
> I've created the login with the Cyrilic symbols (f.e. "������").
>
> When I'm tryin' to connect using JDBC I'm receving the exception:
>
> {code}
>
> org.postgresql.util.PSQLException: FATAL: password authentication failed
> for user "??????"
>

The initial connection setup with the server does not have a well defined
encoding so the only thing that is guaranteed to work is plain ASCII.  Up
until a week ago, the JDBC driver always sent the username as ASCII so it
wouldn't work.  Last week it was changed to use UTF-8, so now some more
cases should work (including yours).  You'll need to build the driver from
CVS, or you can try this one:

http://ejurka.com/pgsql/jars/ak/

Kris Jurka

pgsql-jdbc by date:

Previous
From: "Andrey Kikhtenko"
Date:
Subject: post
Next
From: Kris Jurka
Date:
Subject: Re: PreparedStatement.toString() creates valid SQL; was: Q: use setObject also for int or string