Re: The column name <col> was not found in this ResultSet

From: Zsolt Kúti <kuti(dot)zsolt(at)prolan(dot)hu>
To: David Johnston <polobo(at)yahoo(dot)com>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: The column name <col> was not found in this ResultSet
Date: 2012-11-16 07:16:23
Message-ID: 20121116081623.4d451b23@kuti-zsolt.intranet.prolan.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Thu, 15 Nov 2012 17:19:51 -0500 -n
David Johnston <polobo(at)yahoo(dot)com> írta:

> > In a query like this:
> > select * form T1 a, T2 b where a.id='xx' and a.id=b.id
> >
> > calling the result set:
> > rs.getString("o.id") <<<<<<<<<<<<<<<<<<<<< "o" is neither "a"
> > nor "b"

Hello David,

Information has distorted while I tried to simplify presenting my case.
rs.getString("o.id") must be read as rs.getString("a.id")

Sorry for the confusion.

Enumeration all the fields needed after the SELECT works around,
but it is rather tedious for 30+ fields.

Zsolt

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Craig Ringer 2012-11-19 01:31:17 Re: The column name <col> was not found in this ResultSet
Previous Message David Johnston 2012-11-15 22:19:51 Re: The column name <col> was not found in this ResultSet