Error on connection

Lists: pgsql-jdbc
From: jpicard(at)free(dot)fr
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Error on connection
Date: 2004-08-19 09:32:20
Message-ID: 1092907940.412473a42e74d@imp1-q.free.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-jdbc

Hi all,

I have a Java application (jdk ibm 1.3) run on z/os which connect to Postgresql
database running on a windows XP (jdk ibm 1.3).

The JDBC URL is : jdbc:postgresql://10.82.41.127:5432/ANNUAIRE

When I launch the java application this exception occurs on the client jvm :

[java] Backend start-up failed: ÒáÞá ?╚Ç┴╠Ð╦╚
[java]
[java] at
org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Connection.java:306)
[java] at org.postgresql.Driver.connect(Driver.java:122)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:543)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:194)

And this message display on the database console :

FATAL: database "┴ııõ┴╔┘┼" does not
exist

I guess this is an encoding problem.

Have you see a similar problem ?

I hope you can help me.

Thanks.


From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: jpicard(at)free(dot)fr
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Error on connection
Date: 2004-08-19 10:43:09
Message-ID: 4124843D.7090607@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-jdbc

jpicard(at)free(dot)fr wrote:
> Hi all,
>
> I have a Java application (jdk ibm 1.3) run on z/os which connect to Postgresql
> database running on a windows XP (jdk ibm 1.3).
>
> The JDBC URL is : jdbc:postgresql://10.82.41.127:5432/ANNUAIRE

Is this a 7-bit ascii database name? (it looks like it is, but I thought
I'd check).

> When I launch the java application this exception occurs on the client jvm :
>
> [java] Backend start-up failed: ÒáÞá ?&#9562;Ç&#9524;&#9568;Ð&#9574;&#9562;
> [java]
> [java] at
> org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Connection.java:306)

There isn't much the JDBC driver can do here -- the encoding of messages
early on during startup protocol isn't specified AFAIK, so the driver
just assumes 7-bit ascii in the current development driver or (from
memory) the default JVM encoding in older drivers.

> And this message display on the database console :
>
> FATAL: database "&#9524;&#305;&#305;õ&#9524;&#9556;&#9496;&#9532;" does not
> exist
>
> I guess this is an encoding problem.

What version is the server?

What's the encoding in use on the database side? What about the default
JVM encoding on the client side?

Do you see the same problem if you try the current development driver
from jdbc.postgresql.org?

Is there any chance of getting a tcpdump or similar of the connection
attempt?

-O