Обсуждение: The column index is out of range in PostgreSQL + resolve

Dear All,

=20

SQL Query is running perfect from PG Admin but it gives error "The
column index is out of range " when running through java
application.Please advise me how to solve this issue.

=20

Best Regards

Murali=20

On Mon, 31 Jul 2006, Murali Doss wrote:

>
> SQL Query is running perfect from PG Admin but it gives error "The
> column index is out of range " when running through java
> application.Please advise me how to solve this issue.

This error message has nothing to do with the query execution, but rather
the fetching of results from the ResultSet.  I imagine you are using one
of the ResultSet.getXXX() methods using an improper column index.

Kris Jurka