Re: Error on connection - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Error on connection
Date
Msg-id 4124843D.7090607@opencloud.com
Whole thread Raw
In response to Error on connection  (jpicard@free.fr)
List pgsql-jdbc
jpicard@free.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

pgsql-jdbc by date:

Previous
From: jpicard@free.fr
Date:
Subject: Error on connection
Next
From: "Mikko T."
Date:
Subject: OutOfMemory when inserting stream of unknown length