@Override public int getMaxResults() { if (maxResults > DEFAULT_LIMIT_SELECT_INTERVAL) { return DEFAULT_LIMIT_SELECT_INTERVAL; } return super.getMaxResults(); }
@Override public int getMaxResults() { if (maxResults > DEFAULT_LIMIT_SELECT_INTERVAL) { return DEFAULT_LIMIT_SELECT_INTERVAL; } return super.getMaxResults(); }
public List selectList(String statement, ListQueryParameterObject parameter) { return selectListWithRawParameter(statement, parameter, parameter.getFirstResult(), parameter.getMaxResults()); }
public List selectList(String statement, ListQueryParameterObject parameter) { return selectListWithRawParameter(statement, parameter, parameter.getFirstResult(), parameter.getMaxResults()); }
@Override public int getMaxResults() { if (maxResults > DEFAULT_LIMIT_SELECT_INTERVAL) { return DEFAULT_LIMIT_SELECT_INTERVAL; } return super.getMaxResults(); }
public List selectList(String statement, ListQueryParameterObject parameter) { return selectListWithRawParameter(statement, parameter, parameter.getFirstResult(), parameter.getMaxResults()); }
@Statement public List<ExternalTaskEntity> selectExternalTasksForTopics(OPersistenceSession session, ListQueryParameterObject query) { Map<String, Object> map = (Map<String, Object>)query.getParameter(); String sql = "select from "+getSchemaClass()+" where " +"(lockExpirationTime is null or lockExpirationTime <= ?) and " +"(suspensionState is null or suspensionState = 1) and " +"topicName in ? limit ?"; return queryList(session, sql, map.get("now"), map.get("topics"), query.getMaxResults()); }
@Statement public List<JobEntity> selectExclusiveJobsToExecute(OPersistenceSession session, ListQueryParameterObject query) { Map<String, Object> params = (Map<String, Object>) query.getParameter(); Date now=(Date) params.get("now"); int maxResults=query.getMaxResults(); return queryList(session, "select from "+getSchemaClass()+ " where retries > 0" + " and (duedate is null or duedate <= ?)" + " and (lockOwner is null or lockExpirationTime < ?)" + " and exclusive = true" + " and suspensionState = 1" + " LIMIT ?", now, now, maxResults); }
@Statement public List<JobEntity> selectNextJobsToExecute(OPersistenceSession session, ListQueryParameterObject query) { Map<String, Object> params = (Map<String, Object>) query.getParameter(); Date now=(Date) params.get("now"); int maxResults=query.getMaxResults(); String orderBy = query.getOrderBy(); return queryList(session, "select from "+getSchemaClass()+ " where retries > 0" + " and (duedate is null or duedate <= ?)" + " and (lockOwner is null or lockExpirationTime < ?)" + " and suspensionState = 1" + (Strings.isEmpty(orderBy)?" order by "+orderBy:"") + " LIMIT ?", now, now, maxResults); }