Problem geting column value.

[Em Aiy]

Hi,
Please look at the following code

ResultSetMetaData rsmd = rs.getMetaData();
for (int i = 0; i < rsmd.getColumnCount(); i++) {
    System.out.println("column name:\t" + rsmd.getColumnName(i));
    System.out.println("column value:\t"+ rs.getObject(rsmd.getColumnName(i)));
}

This code is throwing exception ... "array index out of range". I have checked it and it comes only when i use rs (resultset object) to retrieve the value.

[Herman Schelti]

hi Muhammad Ali,

I think int i should start with the value 1 (not with 0):

the JavaDoc for ResultSetMetaData says:
column - the first column is 1, the second is 2, ...

Herman

[Em Aiy]

yeah, one possible reason was that. The other reason was, i must have done "rs.next()" in order to get a value from the record.