Thread: Error on connection

Error on connection

From
jpicard@free.fr
Date:
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.

Re: Error on connection

From
Oliver Jowett
Date:
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