List of usage examples for org.springframework.dao EmptyResultDataAccessException getClass
@HotSpotIntrinsicCandidate public final native Class<?> getClass();
From source file:org.sakaiproject.dash.dao.impl.DashboardDaoImpl.java
public CalendarLink getCalendarLink(long id) { if (log.isDebugEnabled()) { log.debug("getCalendarLink(" + id + ")"); }/*from w w w .j a v a 2 s .c o m*/ try { return (CalendarLink) getJdbcTemplate().queryForObject(getStatement("select.CalendarLink.by.id"), new Object[] { id }, new CalendarLinkMapper()); } catch (EmptyResultDataAccessException ex) { log.debug("getCalendarLink: Empty result executing query: " + ex.getClass() + ":" + ex.getMessage()); return null; } catch (DataAccessException ex) { log.warn("getCalendarLink: Error executing query: " + ex.getClass() + ":" + ex.getMessage()); return null; } }
From source file:org.sakaiproject.dash.dao.impl.DashboardDaoImpl.java
public List<CalendarLink> getFutureCalendarLinks(String sakaiUserId, String contextId, boolean hidden) { if (log.isDebugEnabled()) { log.debug("getFutureCalendarLinks(" + sakaiUserId + "," + contextId + "," + hidden + ")"); }//www.ja va 2 s. co m if (sakaiUserId == null) { log.warn("getFutureCalendarLinks() called with null sakaiUserId"); return null; } String sql = null; Object[] params = null; if (contextId == null) { sql = getStatement("select.future.CalendarLinks.by.sakaiId.hidden"); params = new Object[] { sakaiUserId, Boolean.valueOf(hidden), getPreviousMidnight() }; } else { sql = getStatement("select.future.CalendarLinks.by.sakaiId.contextId.hidden"); params = new Object[] { sakaiUserId, contextId, Boolean.valueOf(hidden), getPreviousMidnight() }; } try { return (List<CalendarLink>) getJdbcTemplate().query(sql, params, new CalendarLinkMapper()); } catch (EmptyResultDataAccessException ex) { log.debug("getFutureCalendarLinks: Empty result executing query: " + ex.getClass() + ":" + ex.getMessage()); return null; } catch (DataAccessException ex) { log.warn("getFutureCalendarLinks: Error executing query: " + ex.getClass() + ":" + ex.getMessage()); return null; } }
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 ww.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 + ")"); }// w ww. j a v a 2 s. c om 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 va 2s . com*/ 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 ww w . ja v a 2 s. c om*/ 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 va 2 s.c o m*/ 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 + ")"); }// w w w .ja va2 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 a2 s . com 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 w w .j av a 2s. c o 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; } }