Postgres Pro
Downloads
Home   >   mailing lists

The column name was not found in this ResultSet - Mailing list pgsql-jdbc

was not found in this ResultSetwas not found in this ResultSet  ("David Johnston" <polobo@yahoo.com>)
Re: The column name was not found in this ResultSet  (Craig Ringer <craig@2ndQuadrant.com>)
From Zsolt Kúti
Subject The column name
Date
Msg-id 20121114114240.3a649bb7@kuti-zsolt.intranet.prolan.hu
Whole thread Raw
Responses Re: The column name
List pgsql-jdbc
Tree view 
Hello,

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")

I get:
org.postgresql.util.PSQLException: The column name o.id was not found
in this ResultSet. at
org.postgresql.jdbc2.AbstractJdbc2ResultSet.findColumn(AbstractJdbc2ResultSet.java:2562)
at
org.postgresql.jdbc2.AbstractJdbc2ResultSet.getString(AbstractJdbc2ResultSet.java:2405)
at
hu.prolan.emgmt.fre.service.store.impl.OrderStoreImpl.loadOrder(OrderStoreImpl.java:236)

Getting data by index is OK, just as simply using getString('id'). This
nonqualified access however cannot get to the next column with the
same name...

How can the columns accessed by qualified name?
Is it a bug?

I use:
postgresql-9.1-901.jdbc4.jar
openjdk6


Please cc to me as I am not on the list!
Thanks!

Zsolt

pgsql-jdbc by date:

Previous
From: "Adam Rauch"
Date:
Subject: Re: postgresql-9.2-1002.jdbc4.jar does not work with Java6
Next
From: "David Johnston"
Date:
Subject: Re: The column name was not found in this ResultSet