I am running the followig code against Access 2000:

cr = SqlManager.singleton().executeRetrieveSQL(sql);

while (cr.getResultSet().next()) {

courtOrder = new CourtOrderBean();

if (cr.getResultSet().getObject("CT_BRCH_NB") != null) {
courtOrder.setBranch((String) cr.getResultSet().getObject("CT_BRCH_NB"));

In this case the CT_BRCH_NB is not null so the I continue into the If-statement. When I execute the courtOrder.setBranch.... statement, I get a SQL exception "java.sql.SQLException: No data found". This same code works fine against DB2.

Any ideas?