Miracle: When I delete a row it's deleted in page but in DB table it Wont
Hi when i delete a tablerowgroup it is deleted in table component but when i check this in my Database it is presented. I am just not getting whats happening there.
For deleting i have the following code in Delete Button action handler.
try {
RowKey del = tableRowGroup1.getRowKey();
if ((del != null) && (employee1DataProvider.canRemoveRow(del)))
{
employee1DataProvider.removeRow(del);
employee1DataProvider.commitChanges();
employee1DataProvider.refresh();
}
} catch (Exception ex) {
log("ErrorDescription", ex);
error(ex.getMessage());
}
# 1
Hi i am getting these errors when deleting and i cant find how to update an row group i.e, not from a table component by using an Form data.
System Messages:-- When i delete a row which have the same data in two rows.
Number of conflicts while synchronizing: 1 SyncResolver.DELETE_ROW_CONFLICT row 2 more than one row matched delete statement.
Number of conflicts while synchronizing: 1 SyncResolver.DELETE_ROW_CONFLICT row 2 more than one row matched delete statement
System Messages:--When i delete a row which have one and only one kind.
java.sql.SQLException: Invalid cursor position.
java.sql.SQLException: Invalid cursor position.
# 2
As documented before on this forum the printstatements property of the CachedRowSet will give you a good idea of what is going on. I imagine that your SQL server has difficulty in deciding which row you want deleted. You will probably have to add a unique column to the table. The rowset on the other hand does not have the same problem since you are specifying to row to be deleted by RowKey.
Ultimately I suspect you have an SQL problem.
