1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| PaginatedList<SCRDetailDTO> paginatedList = new PaginatedList<SCRDetailDTO>(theptf.SCRlines, 100);
conn2.setAutoCommit(false);
while (true) {
List<SCRDetailDTO> page = paginatedList.nextPage();
if (page == null || page.isEmpty()) {
break;
}
for (SCRDetailDTO theDetail : page) {
request = theUtil.generateSaveRequest(theDetail, scrId, SCR);
if (request != null) {
callableStatement = conn2.prepareCall(StoredProc.prerapareCallableStmt(request, userId));
callableStatement.addBatch();
}
}
int[] result = callableStatement.executeBatch();
conn2.commit();
callableStatement.clearBatch();
callableStatement.close();
conn2.setAutoCommit(true);
} |
Partager