Hi Rajesh,
> Hello Per,
>
> I have never seen any examples of using "tableName.columnName" with the
> ResultSet.getObject() method.
> My understanding is the ResultSet.getObject () is expected to use
> only the column names, hence using
> the table name qualifier will not work. Using only the column names
> should be right approach as
> you noticed (getObject("A"))
>
But this is a valid sql syntax or? Is the meaning of that, that it's not
supported by the jdbc-spec or only by derby driver?
> For cases where the same column names appear in joins of two tables, I
> would qualify those
> columns with the respective tables in the query and use the
> *getObject*(int columnIndex) instead:
But this means i have to map the column index and the object field. Thats
impossible, because the resultset order of fields depends on create table
statement, which is externally managed from my application (in a sql script
file). I.e. i can not guarantee the correct mapping.
Cheers
Per
