No Columns in MappingSqlQuery.mapRow

[eliaz]

Hello,

i'm stuck on a problem with MappingSqlQuery. My overridden mapRow(ResultSet rs, int rowIndex) method is called, but the resultset seems to be holding no values.
mysql server log reports a correct query which returns one row, but if i execute rs.getInt(0), an exception occurs

java.sql.SQLException: Column Index out of range, 0 < 1.

any ideas?

[Marten Deinum]

Check the javadocs and also read the error message that gives it away also.

getInt

public int getInt(int columnIndex)
throws SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.

Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the value returned is 0
Throws:
SQLException - if a database access error occurs

[eliaz]

ahh...

i really did read the docs, but i simply read over it, it seems...

thank you so much...