UPDATE_ROW_CONFLICT

Dear all,

I get a great problem that I can't update records in dataprovider, I got the following message

"java.lang.RuntimeException: Number of conflicts while synchronizing: 5 SyncResolver.UPDATE_ROW_CONFLICT row 5 attempt to update a row that has been updated or deleted by another user"

And the code is as follows-

try {

getSessionBean1().getAbcRowSet().setObject(1, "123");

getSessionBean1().getAbcDataProvider().refresh();

if (getSessionBean1().getAbcDataProvider().cursorFirst()) {

do {

getSessionBean1().getAbcDataProvider().setValue("status", "1");

} while (getSessionBean1().getAbcDataProvider().cursorNext());

}

getSessionBean1().getAbcDataProvider().commitChanges();

getSessionBean1().getAbcDataProvider().refresh();

} catch (Exception e) {

info (""+e);

}

[872 byte] By [KL2000] at [2007-11-26 11:19:52]
# 1
I have no idea.But I suggest you set printStatements and check what is logged. http://blogs.sun.com/jfbrown/entry/creator_2_cachedrowset_logging
TubahBrown at 2007-7-7 3:35:11 > top of Java-index,Development Tools,Java Tools...
# 2
Do you have any blob field? That is the problem, you can't use a dataprovider with a table with a blob field
jesuspastor at 2007-7-7 3:35:11 > top of Java-index,Development Tools,Java Tools...