Rowset.commit() changes not populated.
Code Inside the action event of a button:
Steps through okay. Commit() does not update changes to record in table.
try {
String isUserID = (String) this.hiddenID.getValue();
// Get the key
xxxRowSet.setConcurrency(java.sql.ResultSet.CONCUR_UPDATABLE);
xxxRowSet.execute();
xxxRowSet.beforeFirst();
// Navigate through rows
if (isUserID != "0"){
xxxRowSet.first();
do{
if (xxxRowSet.getString("id").equals(isUserID)){
xxxRowSet.acceptChanges();
xxxRowSet.commit();
}
} while (xxxRowSet.next());
};
} catch (Exception ex) {
log("Error During Update", ex);
error("Error :"+ex.getMessage());
}
return null;
}
[750 byte] By [CountryComforta] at [2007-11-26 22:36:30] 