PostgreSQL JDBC - Re: org.postgresql.util.PSQLException Column name candidates.id

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: org.postgresql.util.PSQLException Column name candidates.id

Kris Jurka

2005-11-24, 8:24 pm

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Sponsored Links