post - Mailing list pgsql-jdbc

From Andrey Kikhtenko
Subject post
Date
Msg-id 6F83CD6826475840B9107AB69BE401A60126F855@poligon.tscrm.com
Whole thread Raw
Responses Re: post  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc

Hi,

 

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

         at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:276)

         at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:95)

         at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)

         at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:124)

         at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)

         at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)

         at org.postgresql.Driver.makeConnection(Driver.java:386)

         at org.postgresql.Driver.connect(Driver.java:260)

         at java.sql.DriverManager.getConnection(Unknown Source)

         at java.sql.DriverManager.getConnection(Unknown Source)

{code}

 

My code is:

{code}

Properties connectionProperties = new Properties();

                   connectionProperties.setProperty("user", userName);

                   connectionProperties.put("charSet", "utf-8");

                   connectionProperties.setProperty("password", userPassword);

                   try {

                   connection = DriverManager.getConnection(connectionString, connectionProperties);

                   } catch (SQLException e) {

                            e.printStackTrace();

                   }{code}

 

When I'm tryin' to connect using UTF-8 decoded name: Р?ванов I'm receiving the same exception, but another client tool (EMS SQL Manager) works with second login.

 

Can some body tell me what's wrong?

 

Thanks, Andrew.

 

 

Best regards,


Andrew Kikhtenko

Developer

TERRASOFT

Direct phone:  +380 444 962 450

E-mail: A.Kikhtenko@tscrm.com

www.tscrm.com

 

cid:image001.jpg@01C6DD9D.A8EDD280

 

 

Attachment

pgsql-jdbc by date:

Previous
From: Andrew
Date:
Subject: Re: UUID datatype
Next
From: Kris Jurka
Date:
Subject: Re: post