Hard to say, most likely the given lidnr simply does not exist.

Mark

> 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 ?

--
Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger01