Hi
I've recently upgraded from Pro to Power edition.
The following code worked perfectly on Pro (as a result of discussion http://forums.smartclient.com/showthread.php?t=24190).
Now, I get the following error in Tomcat after a LONG wait. I looked at the examples again but can't see anything wrong:
java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction.
Please help me.
I've recently upgraded from Pro to Power edition.
The following code worked perfectly on Pro (as a result of discussion http://forums.smartclient.com/showthread.php?t=24190).
Code:
RPCManager.startQueue();
cvarIntDBTransactionId = RPCManager.getCurrentTransactionId();
dfRegisterUserAccountDetail.setSaveOperationType("add");
dfRegisterUserAccountDetail.saveData();
for (i = 0; i < lgdRegisterUserPeopleList.data.length; i++) {
cvarArrTabs[i].saveDataOnSubmit();
}
RPCManager.sendQueue(
function (responses) {
var lvarErrorFlag = false;
var lvarErrorTab = 0;
for (j = 0; j < responses.length; j++) {
if (responses[j].status != RPCResponse.STATUS_SUCCESS) {
lvarErrorFlag = true;
lvarErrorTab = j;
break;
}
}
if (lvarErrorFlag == true) {
RPCManager.cancelQueue(cvarIntDBTransactionId);
tbsRegisterUser.selectTab(lvarErrorTab);
RPCManager.handleError();
} else {
isc.say(
gvarObjClientConstants.ACCOUNT_REGISTER_SUCCESS,
function () {
window.location = gvarObjUserSession.getCvarStrContextPath() + gvarObjClientConstants.LOGIN_PAGE;
});
}
}
);
java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction.
Please help me.
Comment