public void testJobAcquisitionForJobsWithoutSuspensionStateSet() {
final String processInstanceId = "1";
final String myCustomTimerEntity = "myCustomTimerEntity";
final TimerEntity timer = new TimerEntity();
timer.setRetries(3);
timer.setDuedate(null);
timer.setLockOwner(null);
timer.setLockExpirationTime(null);
timer.setJobHandlerType(TimerStartEventJobHandler.TYPE);
timer.setJobHandlerConfiguration(myCustomTimerEntity);
timer.setProcessInstanceId(processInstanceId);
final CommandExecutor commandExecutor = processEngineConfiguration.getCommandExecutorTxRequired();
try {
// we create a timer entity
commandExecutor.execute(new Command<Void>() {
public Void execute(CommandContext commandContext) {
commandContext.getJobManager().insert(timer);
return null;
}
});
// we change the suspension state to null
commandExecutor.execute(new Command<Void>() {
public Void execute(CommandContext commandContext) {
Connection connection = null;
Statement statement = null;
ResultSet rs = null;
try {
SqlSession sqlSession = commandContext.getDbSqlSession().getSqlSession();
connection = sqlSession.getConnection();
statement = connection
.createStatement();
int updateResult = statement.executeUpdate("UPDATE ACT_RU_JOB " +
"SET SUSPENSION_STATE_ = NULL, REV_ = 2" +
" WHERE SUSPENSION_STATE_ = 1");
statement.close();
assertEquals(1, updateResult);
statement = connection
.createStatement();
rs = statement.executeQuery("SELECT * FROM ACT_RU_JOB WHERE SUSPENSION_STATE_ IS NULL");
int rowNum = 0;
while (rs.next()) {
rowNum = rs.getRow();
}
assertEquals(1, rowNum);
} catch (SQLException e) {
throw new RuntimeException(e);
} finally {
try {
if (statement != null) {
statement.close();
}
if (rs != null) {
rs.close();
}
if (connection != null) {
connection.close();
}
} catch (SQLException e) {
throw new RuntimeException(e);
}
}
return null;
}
});
// it is picked up by the acquisition queries
commandExecutor.execute(new Command<Void>() {
public Void execute(CommandContext commandContext) {
JobManager jobManager = commandContext.getJobManager();
List<JobEntity> executableJobs = jobManager.findNextJobsToExecute(new Page(0, 1));
assertEquals(1, executableJobs.size());
assertEquals(myCustomTimerEntity, executableJobs.get(0).getJobHandlerConfiguration());
executableJobs = jobManager.findExclusiveJobsToExecute(processInstanceId);
assertEquals(1, executableJobs.size());
assertEquals(myCustomTimerEntity, executableJobs.get(0).getJobHandlerConfiguration());
return null;
}
});
} finally {
// cleanup
commandExecutor.execute(new Command<Void>() {
public Void execute(CommandContext commandContext) {
final JobEntity newTimer = commandContext.getJobManager().findJobById(timer.getId());
newTimer.delete();
return null;
}
});
}