Re: Error on connection

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: ÒáÞá ?╚Ç┴╠Ð╦╚
> [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 "┴ııõ┴╔┘┼" 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