Hi there !
Within a stateless Session bean,I want to
delete a row in a datatable.
I get CSpDataObject.SUCCESS at execution but
no rows are deleted !!
It seems that changes are not commited.
Any ideas ????????????
Best regards Per
****************************************************************
sqlQuery = "DELETE FROM REQUISITION_LINE WHERE REQ_ID=2 and REQ_LINE_NUM = 1";
retCode = false;
try {
reqResultSet = CSpDataObject.executeImmediate("eco", sqlQuery);
int errorCode = reqResultSet.getResultStatus().getErrorCode();
if (errorCode == CSpDataObject.SUCCESS) {
retCode = true;
}
}
catch (Exception e)
{
throw new RemoteException("Unable to connect to the database {"+e.getMessage()+"}");
}
****************************************************************
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
