Subject very stupid error wtih firebird jdbc driver
Author fred.vlietstra
The result set stays empty after exceuting the following code :

private final static String SELECT_LID = "SELECT RECORD_ID,
LIDNR, NAAM, VOORLETTERS, TUSSENVOEGSEL," +
" STRAAT, NUMMER, POSTCODE, PLAATS, BGNUMMER
FROM LEDEN WHERE LIDNR = ?";

public Leden getLid(String lidNr)
{
Connection c = null;
PreparedStatement stmt = null;
ResultSet rs = null;
int x = 0;
Leden lid = null;
try
{
c = getConnection();

stmt = c.prepareStatement(SELECT_LID);
stmt.setString(++x, lidNr);
rs = stmt.executeQuery();

while(rs.next())
{
lid = new Leden();
int i = 0;
lid.setRecord_ID(rs.getString(++i));
lid.setLidNr(rs.getString(++i));
lid.setNaam(rs.getString(++i));
lid.setVoorLetters(rs.getString(++i));
lid.setTussenVoegsel(rs.getString
(++i));
lid.setStraat(rs.getString(++i));
lid.setHuisNummer(new Integer
(rs.getInt(++i)));
lid.setToeVoeging(rs.getString(++i));
lid.setPostCode(rs.getString(++i));
lid.setPlaats(rs.getString(++i));
lid.setHoofdBewoner(convertToBoolean
(rs.getInt(++i)));
lid.setMedeBewoner(convertToBoolean
(rs.getInt(++i)));
lid.setSamenVoegCode(rs.getString
(++i));
lid.setBgNummer(rs.getString(++i));

}

}
catch (java.sql.SQLException e)
{
logger.errorLog(e.getMessage(), e);
}
finally
{
releaseJDBCResources(c, stmt, rs);
}

return lid;

no sql errors nothing. any idea ?