Example usage for org.springframework.dao EmptyResultDataAccessException getMessage

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

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

Introduction

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

Prototype

@Override
@Nullable
public String getMessage()

Source Link

Document

Return the detail message, including the message from the nested exception if there is one.

Usage

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 + ")");
    }//from  w w  w.  ja  v a2  s.  co m

    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 + ")");
    }//from  w  ww .  jav a  2s.c om
    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 + ")");
    }/*from   w  w  w  .ja v  a 2s  .  c om*/
    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 www .j  av a 2  s  .c  om*/

    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 .j a  v  a 2 s .co  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 v a2s. c  om*/
    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   ww  w .ja  v  a  2  s. com

    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 + ")");
    }//  w w w. ja  v a 2 s . com
    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>();
    }
}

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

public Set<String> getSakaiIdsForUserWithNewsLinks(String entityReference) {
    if (log.isDebugEnabled()) {
        log.debug("getSakaIdsForUserWithNewsLinks(" + entityReference + ")");
    }//from  w  w w.ja va  2s .com
    String sql = getStatement("select.sakaiUserIds.in.newsLinks.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("getSakaIdsForUserWithNewsLinks: Empty result executing query: " + ex.getClass() + ":"
                + ex.getMessage());
        return new HashSet<String>();
    } catch (DataAccessException ex) {
        log.warn("getSakaIdsForUserWithNewsLinks: Error executing query: " + ex.getClass() + ":"
                + ex.getMessage());
        return new HashSet<String>();
    }
}

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

public Set<String> listUsersWithLinks(CalendarItem calendarItem) {
    if (log.isDebugEnabled()) {
        log.debug("listUsersWithAccess(" + calendarItem + ")");
    }//from ww  w. j  av a 2  s. c om

    try {

        String sql = getStatement("select.Person.sakaiId.by.calendarLink");
        Object[] args = new Object[] { calendarItem.getId() };
        List items = getJdbcTemplate().queryForList(sql, args, String.class);
        if (items == null || items.isEmpty()) {
            return new TreeSet<String>();
        }
        return new TreeSet<String>(items);

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

}