Re: Exception while doing ResultSetMetadata.getColumnName() after select setval() - Mailing list pgsql-jdbc

On Tue, 18 Sep 2007, Stephane Bailliez wrote:

> jdbc driver: postgresql-8.1-410.jdbc3.jar
> Sun jdk 1.6.0_01 windows xp
> postgresql 8.1.5 on windows xp and postgresql 8.1.9 on ubuntu
>
>
>            ResultSetMetaData md = rs.getMetaData();
>            int cols = md.getColumnCount();
>            for (int i = 0; i < cols; i++) {
>              String name = md.getColumnName(i); // XXX Exception here
>              print(name + "\t");

In JDBC columns go from 1 -> count, not 0 -> count-1.

Kris Jurka