Invalid Descriptor Index

[Paras Ahuja]

rsmd=rs.getMetaData();
				int colCount=rsmd.getColumnCount();
				String[] colNames=new String[colCount];
				for(int i=0;i<colCount;i++)
				{
					colNames[i]=new String();
					colNames[i]=rsmd.getColumnName(i);
				}

I am getting this error.
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid descriptor index

I have used the same code so many times, i never got this error. But now suddenly it doesn't work.
Please help

[Martin Vajsar]

In JDBC, all numberings start at one. This is terribly unfortunate design decision, but at least it is consistent across the whole JDBC API. It therefore applies to ResultSetMetaData.getColumnName() too; you're trying to access column at index 0, which does not exist.