Re: org.postgresql.util.PSQLException Column name candidates.id - Mailing list pgsql-jdbc

On Thu, 24 Nov 2005, Roman Chervotkin wrote:

> I have query in my application "SELECT * FROM candidates WHERE
> candidates.id=?"
>
> so after query executed I've got exception
> *Exception Details: * org.postgresql.util.PSQLException
>  Der Spaltenname candidates.id wurde in diesem ResultSet nicht gefunden,
>

This error is complaining about calling ResultSet.getXXX("candidates.id"),
not the execution of the query.  You need to call getXXX("id"), you may
not qualify resulting column with the source tablename.

Kris Jurka