public SchedulerJobInfo getSchedulerJobInfo(String idStr) throws SQLException {
String fetchSQL = "SELECT * FROM " + JOB_TABLE + " WHERE " + COLUMN_ID + "=?";
List<Object[]> result = runner.query(fetchSQL, multipleRowsHandler, idStr);
if (result.size() == 0) {
return null;
} else {
Object[] jobInfo = result.get(0);
SchedulerJobHandle id = SchedulerJobHandle.fromString((String) jobInfo[0]);
XJob xJob = ToXMLString.valueOf((String) jobInfo[1], ObjectFactory.class);
String userName = (String) jobInfo[2];
String status = (String) jobInfo[3];
long createdOn = (Long) jobInfo[4];
long modifiedOn = (Long) jobInfo[5];
SchedulerJobState jobState = SchedulerJobState.valueOf(status);
return new SchedulerJobInfo(id, xJob, userName, jobState, createdOn, modifiedOn);
}
}