Hugo Garza <hiro2k(at)gmail(dot)com> wrote:
> I'm going a complex join on 5 tables and some of them have a
> column that repeats in two tables called "name". So I created an
> alias for each table, one of them called co, and in my application
> I do a result.getString("co.name"). But the application fails
> with: "The column name co.name was not found in this ResultSet."
Try giving the result column an alias:
select co.name as co_name
Then access it by the name you have given it.
Personally, I've never seen that other usage, and would never have
expected it to work.
In response to
pgsql-jdbc by date
|Next:||From: Maciek Sakrejda||Date: 2011-02-01 22:52:27|
|Subject: Re: My query table aliases don't exist in my application|
|Previous:||From: Hugo Garza||Date: 2011-02-01 22:23:06|
|Subject: My query table aliases don't exist in my application|