Example usage for org.springframework.dao EmptyResultDataAccessException getClass

List of usage examples for org.springframework.dao EmptyResultDataAccessException getClass

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.dao.*
  5. EmptyResultDataAccessException
  6. getClass

Introduction

In this page you can find the example usage for org.springframework.dao EmptyResultDataAccessException getClass.

Prototype

@HotSpotIntrinsicCandidate
public final native Class<?> getClass();

Source Link

Document

Returns the runtime class of this Object .

Usage

From source file:org.sakaiproject.dash.dao.impl.DashboardDaoImpl.java

public List<NewsLink> getCurrentNewsLinks(String sakaiUserId, String contextId) {
    if (log.isDebugEnabled()) {
        log.debug("getCurrentNewsLinks(" + sakaiUserId + "," + contextId + ")");
    }// w w w .  j  a  v  a2 s . c  o  m

    String sql = null;
    Object[] params = null;
    if (contextId == null) {
        sql = getStatement("select.current.NewsLinks.by.sakaiUserId");
        params = new Object[] { sakaiUserId, 2, sakaiUserId, 2, sakaiUserId };
    } else {
        sql = getStatement("select.current.NewsLinks.by.sakaiUserId.contextId");
        // sakai-id context-id gr-count sakai-id gr-count sakai-id context-id 
        params = new Object[] { sakaiUserId, contextId, 2, sakaiUserId, 2, sakaiUserId, contextId };

    }

    try {
        return (List<NewsLink>) getJdbcTemplate().query(sql, params, new NewsLinkMapper());
    } catch (EmptyResultDataAccessException ex) {
        log.debug(
                "getCurrentNewsLinks: Empty result executing query: " + ex.getClass() + ":" + ex.getMessage());
        return new ArrayList<NewsLink>();
    } catch (DataAccessException ex) {
        log.warn("getCurrentNewsLinks: Error executing query: " + ex.getClass() + ":" + ex.getMessage());
        return new ArrayList<NewsLink>();
    }
}

From source file:org.sakaiproject.dash.dao.impl.DashboardDaoImpl.java

public List<NewsLink> getStarredNewsLinks(String sakaiUserId, String contextId) {
    if (log.isDebugEnabled()) {
        log.debug("getStarredNewsLinks(" + sakaiUserId + "," + contextId + ")");
    }/*from  w ww .j  av a2  s.  c  om*/

    String sql = null;
    Object[] params = null;
    if (contextId == null) {
        sql = getStatement("select.starred.NewsLinks.by.sakaiUserId");
        params = new Object[] { sakaiUserId };
    } else {
        sql = getStatement("select.starred.NewsLinks.by.sakaiUserId.contextId");
        params = new Object[] { sakaiUserId, contextId };

    }

    try {
        return (List<NewsLink>) getJdbcTemplate().query(sql, params, new NewsLinkMapper());
    } catch (EmptyResultDataAccessException ex) {
        log.debug(
                "getStarredNewsLinks: Empty result executing query: " + ex.getClass() + ":" + ex.getMessage());
        return new ArrayList<NewsLink>();
    } catch (DataAccessException ex) {
        log.warn("getStarredNewsLinks: Error executing query: " + ex.getClass() + ":" + ex.getMessage());
        return new ArrayList<NewsLink>();
    }
}

From source file:org.sakaiproject.dash.dao.impl.DashboardDaoImpl.java

public List<NewsLink> getHiddenNewsLinks(String sakaiUserId, String contextId) {
    if (log.isDebugEnabled()) {
        log.debug("getHiddenNewsLinks(" + sakaiUserId + "," + contextId + ")");
    }/*w  w w . j  av a 2  s.c  om*/

    String sql = null;
    Object[] params = null;
    if (contextId == null) {
        sql = getStatement("select.hidden.NewsLinks.by.sakaiUserId");
        params = new Object[] { sakaiUserId };
    } else {
        sql = getStatement("select.hidden.NewsLinks.by.sakaiUserId.contextId");
        params = new Object[] { sakaiUserId, contextId };

    }

    try {
        return (List<NewsLink>) getJdbcTemplate().query(sql, params, new NewsLinkMapper());
    } catch (EmptyResultDataAccessException ex) {
        log.debug("getHiddenNewsLinks: Empty result executing query: " + ex.getClass() + ":" + ex.getMessage());
        return new ArrayList<NewsLink>();
    } catch (DataAccessException ex) {
        log.warn("getHiddenNewsLinks: Error executing query: " + ex.getClass() + ":" + ex.getMessage());
        return new ArrayList<NewsLink>();
    }
}

From source file:org.sakaiproject.dash.dao.impl.DashboardDaoImpl.java

public int countNewsLinksByGroupId(String sakaiUserId, String groupId) {
    if (log.isDebugEnabled()) {
        log.debug("getNewsItemsByGroupId(" + sakaiUserId + "," + groupId + ")");
    }// w w w  . j  av  a  2s.c o m
    if (sakaiUserId == null || groupId == null) {
        return 0;
    }
    String sql = getStatement("count.NewsLinks.by.sakaiId.groupId");
    Object[] params = new Object[] { sakaiUserId, groupId };
    try {
        return getJdbcTemplate().queryForInt(sql, params);
    } catch (EmptyResultDataAccessException ex) {
        log.debug("countNewsLinksByGroupId: Empty result executing query: " + ex.getClass() + ":"
                + ex.getMessage());
        return 0;
    } catch (DataAccessException ex) {
        log.warn("countNewsLinksByGroupId: Error executing query: " + ex.getClass() + ":" + ex.getMessage());
        return 0;
    }
}

From source file:org.sakaiproject.dash.dao.impl.DashboardDaoImpl.java

public List<NewsLink> getNewsLinksByGroupId(String sakaiUserId, String groupId, int limit, int offset) {
    List<NewsItem> items = null;
    if (log.isDebugEnabled()) {
        log.debug("getNewsItemsByGroupId(" + sakaiUserId + "," + groupId + "," + limit + "," + offset + ")");
    }/*  w  w  w.  j  av a  2  s.com*/
    if (sakaiUserId == null || groupId == null) {
        return new ArrayList<NewsLink>();
    }
    String sql = getStatement("select.NewsLinks.by.sakaiId.groupId.paged");

    Object[] params = null;
    if ("oracle".equalsIgnoreCase(this.databaseVendor)) {
        params = new Object[] { sakaiUserId, groupId, offset + limit, offset };
    } else {
        params = new Object[] { sakaiUserId, groupId, limit, offset };
    }
    try {
        return (List<NewsLink>) getJdbcTemplate().query(sql, params, new NewsLinkMapper());
    } catch (EmptyResultDataAccessException ex) {
        log.debug("getNewsLinksByGroupId: Empty result executing query: " + ex.getClass() + ":"
                + ex.getMessage());
        return new ArrayList<NewsLink>();
    } catch (DataAccessException ex) {
        log.warn("getNewsLinksByGroupId: Error executing query: " + ex.getClass() + ":" + ex.getMessage());
        return new ArrayList<NewsLink>();
    }
}

From source file:org.sakaiproject.dash.dao.impl.DashboardDaoImpl.java

public Person getPersonBySakaiId(String sakaiId) {
    if (log.isDebugEnabled()) {
        log.debug("getPersonBySakaiId(" + sakaiId + ")");
    }//from w w  w .  j ava 2 s .  co  m

    try {
        return (Person) getJdbcTemplate().queryForObject(getStatement("select.Person.by.sakaiId"),
                new Object[] { sakaiId }, new PersonMapper());
    } catch (EmptyResultDataAccessException ex) {
        log.debug("getPersonBySakaiId: Empty result executing query: " + ex.getClass() + ":" + ex.getMessage());
        return null;
    } catch (DataAccessException ex) {
        log.warn("getPersonBySakaiId: Error executing query: " + ex.getClass() + ":" + ex.getMessage());
        return null;
    }
}

From source file:org.sakaiproject.dash.dao.impl.DashboardDaoImpl.java

public List<TaskLock> getTaskLocks(String task) {
    // select.TaskLocks.by.task
    List<NewsItem> items = null;
    if (log.isDebugEnabled()) {
        log.debug("getTaskLocks(" + task + ")");
    }/*from  w  w w. ja va  2s  .c  o  m*/
    if (task == null) {
        return new ArrayList<TaskLock>();
    }
    String sql = getStatement("select.TaskLocks.by.task");

    Object[] params = new Object[] { task };
    try {
        return (List<TaskLock>) getJdbcTemplate().query(sql, params, new TaskLockMapper());
    } catch (EmptyResultDataAccessException ex) {
        log.debug("getTaskLocks: Empty result executing query: " + ex.getClass() + ":" + ex.getMessage());
        return new ArrayList<TaskLock>();
    } catch (DataAccessException ex) {
        log.warn("getTaskLocks: Error executing query: " + ex.getClass() + ":" + ex.getMessage());
        return new ArrayList<TaskLock>();
    }
}

From source file:org.sakaiproject.dash.dao.impl.DashboardDaoImpl.java

public List<TaskLock> getAssignedTaskLocks() {
    // select.TaskLocks.by.hasLock
    List<NewsItem> items = null;
    if (log.isDebugEnabled()) {
        log.debug("getAssignedTaskLocks()");
    }/*from  w ww  . j a  va  2 s  .co m*/
    String sql = getStatement("select.TaskLocks.by.hasLock");

    try {
        return (List<TaskLock>) getJdbcTemplate().query(sql, new TaskLockMapper());
    } catch (EmptyResultDataAccessException ex) {
        log.debug(
                "getAssignedTaskLocks: Empty result executing query: " + ex.getClass() + ":" + ex.getMessage());
        return new ArrayList<TaskLock>();
    } catch (DataAccessException ex) {
        log.warn("getAssignedTaskLocks: Error executing query: " + ex.getClass() + ":" + ex.getMessage());
        return new ArrayList<TaskLock>();
    }
}

From source file:org.sakaiproject.dash.dao.impl.DashboardDaoImpl.java

public SortedSet<Integer> getFutureSequenceNumbers(String entityReference, String calendarTimeLabelKey,
        Integer firstSequenceNumber) {
    if (log.isDebugEnabled()) {
        log.debug("getLastIndexInSequence(" + entityReference + "," + calendarTimeLabelKey + ","
                + firstSequenceNumber + ")");
    }/*from   w  w  w . j  av a 2s.co  m*/

    try {

        String sql = getStatement("select.SequenceNumbers.entityReference.calendarTimeLabelKey.sequenceNumber");
        Object[] args = new Object[] { entityReference, calendarTimeLabelKey, firstSequenceNumber };
        List items = getJdbcTemplate().queryForList(sql, args, Integer.class);
        return new TreeSet(items);

    } catch (EmptyResultDataAccessException ex) {
        log.debug("getFutureSequenceNumbers: Empty result executing query: " + ex.getClass() + ":"
                + ex.getMessage());
        return new TreeSet<Integer>();
    } catch (DataAccessException ex) {
        log.warn("getFutureSequenceNumbers: Error executing query: " + ex.getClass() + ":" + ex.getMessage());
        return new TreeSet<Integer>();
    }

}

From source file:org.sakaiproject.dash.dao.impl.DashboardDaoImpl.java

public Set<String> getSakaIdsForUserWithCalendarLinks(String entityReference) {
    if (log.isDebugEnabled()) {
        log.debug("getSakaIdsForUserWithCalendarLinks(" + entityReference + ")");
    }//ww  w.j  av a  2s .c  o  m
    String sql = getStatement("select.sakaiUserIds.in.calendarLinks.by.entityReference");
    Object[] params = new Object[] { entityReference };
    try {
        List<String> userIds = getJdbcTemplate().query(sql, params, new RowMapper() {

            public Object mapRow(ResultSet rs, int rowNum) throws SQLException {

                return rs.getString(1);
            }

        });
        return new HashSet<String>(userIds);
    } catch (EmptyResultDataAccessException ex) {
        log.debug("getSakaIdsForUserWithCalendarLinks: Empty result executing query: " + ex.getClass() + ":"
                + ex.getMessage());
        return new HashSet<String>();
    } catch (DataAccessException ex) {
        log.warn("getSakaIdsForUserWithCalendarLinks: Error executing query: " + ex.getClass() + ":"
                + ex.getMessage());
        return new HashSet<String>();
    }
}