Problems with column names in dot-notation - Mailing list pgsql-jdbc

From Carsten Heidmann
Subject Problems with column names in dot-notation
Date
Msg-id 5.1.0.14.0.20020814143749.03af3a08@uranos
Whole thread Raw
Responses Re: Problems with column names in dot-notation  (Dave Cramer <Dave@micro-automation.net>)
List pgsql-jdbc
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello,
I'm using PostgreSQL 7.2.1 on Solaris 8 (SunOS 5.8). I'm trying to get a
String from my db, using a very simple select command. Executing the
command in psql or even via phpPgAdmin works fine, but when I try to
retrieve the same information via JDBC I get the following error:
"SQL-Error: The column name sometable.somefield not found."
Executing the same command with a field name without the table name
("somefield") works, when the field name is not ambiguous.

If anyone has a solution for this, I would really appreciate it.

My locale and the db-encoding is set to en_US.ISO8859-15 and the JVM is
started with "-Dfile.encoding=ISO8859-15".

Regards, Carsten

-----BEGIN PGP SIGNATURE-----
Version: 6.5.8ckt

iQA/AwUBPVpDN7jxzYr/SJ6uEQIyegCePfDJeUjBFAltI0rLqthugjijo1oAoKn0
HdcIvr5ouzq9/Ym5Uyn2BtT9
=wCmq
-----END PGP SIGNATURE-----
-----------------------------------------------------------
Dipl. Geogr. Carsten Heidmann
Tel.: 040.81908.345
Fax: 040.81908.373
heidmann@hamburg.baw.de
http://nokis.baw.de/

Bundesanstalt fuer Wasserbau
- Aussenstelle Kueste -
Wedeler Landstrasse 157
DE - 22559 Hamburg
-----------------------------------------------------------


pgsql-jdbc by date:

Previous
From: shanmugavel
Date:
Subject: Abrupt connection closure while handling large objects
Next
From: Dave Cramer
Date:
Subject: Re: Problems with column names in dot-notation