Executing a Batch update is similar to that of insert except that the query model is that of an update model and not insert model. Here also, the first step is defining the query model -
| Code Block |
|---|
|
<update id="EMPLOYEE_BATCH_UPDATE_MYAPP" parameterClass ="java.util.HashMap"> |
...
...
SET EMP_NAME = #EmployeeName#, MOB_NO = #mobileNum# |
...
WHERE EMP_ID = #EmployeeId# |
...
Execution of the Database Request again is very similar to earlier examples -
...
List<Map> batchData = getAllEmployeesToUpdate(); //Prepare the list of records to update |
...
DatabaseRequest dbRequest = new DatabaseRequest(); |
...
dbRequest.setDataAccessMapKey("EMPLOYEE"); |
...
dbRequest.setOperation(DatabaseConstants.BATCH_UPDATE) |
...
dbRequest.setOperationExtension("MYAPP"); |
...
dbRequest.setBatchData(paramData); //Add the batch data to the request |
...
DatabaseResult dbResult = dbRequest.execute(); //Execute the request. |
...
logger.debug("No. of rows affected = " + dbResult.getNoOfRowsAffected()); |
...
} catch (DatabaseException dbException) { |
...
//Handle the exception appropriately. |
...