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<CalendarLink> getPastCalendarLinks(String sakaiUserId, String contextId, boolean hidden) {
    if (log.isDebugEnabled()) {
        log.debug("getPastCalendarLinks(" + sakaiUserId + "," + contextId + "," + hidden + ")");
    }//w  w w  . j  a v  a  2s .  c o m

    if (sakaiUserId == null) {
        log.warn("getPastCalendarLinks() called with null sakaiUserId");
        return null;
    }
    String sql = null;
    Object[] params = null;

    if (contextId == null) {
        sql = getStatement("select.past.CalendarLinks.by.sakaiId.hidden");
        params = new Object[] { sakaiUserId, Boolean.valueOf(hidden), new Date() };
    } else {
        sql = getStatement("select.past.CalendarLinks.by.sakaiId.contextId.hidden");
        params = new Object[] { sakaiUserId, contextId, Boolean.valueOf(hidden), new Date() };
    }

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

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

public List<CalendarLink> getStarredCalendarLinks(String sakaiUserId, String contextId) {
    if (log.isDebugEnabled()) {
        log.debug("getStarredCalendarLinks(" + sakaiUserId + "," + contextId + ")");
    }//from  ww  w  . ja va 2s  .  co m

    if (sakaiUserId == null) {
        log.warn("getStarredCalendarLinks() called with null sakaiUserId");
        return null;
    }
    String sql = null;
    Object[] params = null;

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

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

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

public Context getContext(String contextId) {
    if (log.isDebugEnabled()) {
        log.debug("getContext(" + contextId + ")");
    }//from ww  w  .  j a  v  a2s.co m

    try {
        String sql = getStatement("select.Context.by.contextId");

        return (Context) getJdbcTemplate().queryForObject(sql, new Object[] { contextId }, new ContextMapper());
    } catch (EmptyResultDataAccessException ex) {
        log.debug("getContext: Empty result executing query: " + ex.getClass() + ":" + ex.getMessage());
        return null;
    } catch (DataAccessException ex) {
        log.warn("getContext: Error executing query: " + ex.getClass() + ":" + ex.getMessage());
        return null;
    } catch (Exception e) {
        log.warn("getContext: Error executing query: " + e.getClass() + ":" + e.getMessage());
        return null;
    }
}

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

public List<NewsItem> getMOTD(String motdContextId) {
    if (log.isDebugEnabled()) {
        log.debug("getMOTD()");
    }/*from   w  w  w.  ja v a2  s .c  o  m*/

    String sql = getStatement("select.motd.recent");
    Object[] params = new Object[] { motdContextId };

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

}

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

public NewsItem getNewsItem(long id) {
    if (log.isDebugEnabled()) {
        log.debug("getNewsItem(" + id + ")");
    }//from w  w w.j  a  v a 2s .c  om

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

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

public NewsItem getNewsItem(String entityReference) {
    if (log.isDebugEnabled()) {
        log.debug("getNewsItem(" + entityReference + ")");
    }/*from www  .  j a  v a  2  s.co m*/

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

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

public List<NewsItem> getNewsItemsByContext(String contextId) {

    if (log.isDebugEnabled()) {
        log.debug("getNewsItemsByContext(" + contextId + ")");
    }/*from  ww w. j a  v a 2s.  c  om*/
    String sql = null;
    Object[] params = null;
    if (contextId != null) {
        sql = getStatement("select.NewsItems.by.contextId");
        params = new Object[] { contextId };
    }
    if (log.isDebugEnabled()) {
        log.debug("getNewsItemsByContext(" + contextId + ") sql = " + sql);
    }
    // TODO: what do do if sql and/or params null ??
    try {
        return (List<NewsItem>) getJdbcTemplate().query(sql, params, new NewsItemMapper());
    } catch (EmptyResultDataAccessException ex) {
        log.debug("getNewsItemsByContext: Empty result executing query: " + ex.getClass() + ":"
                + ex.getMessage());
        return new ArrayList<NewsItem>();
    } catch (DataAccessException ex) {
        log.warn("getNewsItem: Error executing query: " + ex.getClass() + ":" + ex.getMessage());
        return new ArrayList<NewsItem>();
    }
}

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

public NewsLink getNewsLink(long newsItemId, long personId) {
    if (log.isDebugEnabled()) {
        log.debug("getNewsLink(" + newsItemId + ", " + personId + ")");
    }//from w ww. jav a 2s.co  m

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

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 + ")");
    }/*from   ww  w. j  ava2 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 + ")");
    }/*w  w  w .  j  a va2  s  .c o  m*/

    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>();
    }
}