this.pstmt = this.conn.prepareStatement(sql);
this.pstmt.setString(1, "1");
this.rs = this.pstmt.executeQuery();
// create a CachedRowSet and populate it
RowSet cachedRowSet = (RowSet) c.newInstance();
// cachedRowSet.populate(rs);
populate.invoke(cachedRowSet, new Object[] { this.rs });
// scroll through CachedRowSet ...
assertTrue(cachedRowSet.next());
assertEquals("1", cachedRowSet.getString("ID"));
assertEquals("test data stuff !", cachedRowSet
.getString("datafield"));
assertFalse(cachedRowSet.next());
} finally {
this.stmt.executeUpdate("DROP TABLE IF EXISTS testBug5188");
}
}