org.postgresql.util.PSQLException Column name candidates.id wasn't found in the ResultSet

From: Roman Chervotkin <roman(dot)chervotkin(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: org.postgresql.util.PSQLException Column name candidates.id wasn't found in the ResultSet
Date: 2005-11-24 13:58:11
Message-ID: c1b06e90511240558w6243aa14ma5ce5feafd49b188@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi, there.
May be silly question but I can't understand it.

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,

But if remove tablename from query and just leave column name like this "SELECT
* FROM candidates WHERE id=?" query executed without a problem. But from
phpmyadmin both these queries worked.
I tried this for two tables and get the same results.

I'm using Postgresql 8.1 with postgresql-8.1-404.jdbc3.jar

Thanks,
Roman.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Thomas Kellerer 2005-11-24 16:34:00 Re: Why is bool == java.sql.Types.BIT ??
Previous Message Dave Cramer 2005-11-24 13:25:22 Re: Can PostgreSQL do data type automated casting in