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<CalendarItem> getCalendarItems(RepeatingCalendarItem repeatingEvent) {
    if (log.isDebugEnabled()) {
        log.debug("getInstancesOfRepeatingEvents(" + repeatingEvent + ")");
    }/*w  w w .  ja  v  a 2s  .c o m*/
    String sql = getStatement("select.CalendarItems.by.repeatingEvent");
    Object[] params = new Object[] { repeatingEvent.getId() };

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

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

public SourceType getSourceType(String sourceTypeName) {
    if (log.isDebugEnabled()) {
        log.debug("getSourceType( " + sourceTypeName + ")");
    }//  w ww.j av  a 2 s . c  o  m

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

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

public CalendarItem getCalendarItem(long id) {
    if (log.isDebugEnabled()) {
        log.debug("getCalendarItem(" + id + ")");
    }/*from  w w  w . j  a  va 2 s.  c  o  m*/

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

}

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

public CalendarItem getCalendarItem(String entityReference, String calendarTimeLabelKey,
        Integer sequenceNumber) {
    if (log.isDebugEnabled()) {
        log.debug(//  w ww.  ja va  2s .c o m
                "getCalendarItem(" + entityReference + "," + calendarTimeLabelKey + "," + sequenceNumber + ")");
    }

    String sql = null;
    Object[] params = null;
    if (sequenceNumber == null) {
        sql = getStatement("select.CalendarItem.by.entityReference.calendarTimeLabelKey");
        params = new Object[] { entityReference, calendarTimeLabelKey };
    } else if (calendarTimeLabelKey == null) {
        sql = getStatement("select.CalendarItem.by.entityReference.sequenceNumber");
        params = new Object[] { entityReference, sequenceNumber };
    } else {
        sql = getStatement("select.CalendarItem.by.entityReference.calendarTimeLabelKey.sequenceNumber");
        params = new Object[] { entityReference, calendarTimeLabelKey, sequenceNumber };
    }

    try {
        return (CalendarItem) getJdbcTemplate().queryForObject(sql, params, new CalendarItemMapper());
    } catch (EmptyResultDataAccessException ex) {
        log.debug("getCalendarItem: Empty result executing query: " + ex.getClass() + ":" + ex.getMessage());
        // System.out.println("addCalendarItem: Error executing query: " + ex.getClass() + ":" + ex.getMessage());
        return null;
    } catch (DataAccessException e) {
        log.warn("getCalendarItem: Error executing query: " + e.getClass() + ":" + e.getMessage());
        // System.out.println("addCalendarItem: Error executing query: " + e.getClass() + ":" + e.getMessage());
        return null;
    } catch (Exception e) {
        log.warn("addCalendarItem: Error executing query: " + e.getClass() + ":" + e.getMessage());
        // System.out.println("addCalendarItem: Error executing query: " + e.getClass() + ":" + e.getMessage());
        return null;
    }
}

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

public List<CalendarItem> getCalendarItems(String entityReference) {
    if (log.isDebugEnabled()) {
        log.debug("getCalendarItems(" + entityReference + ")");
    }//from   w w  w .  j  av  a 2s .c  o m

    try {
        return (List<CalendarItem>) getJdbcTemplate().query(
                getStatement("select.CalendarItems.by.entityReference"), new Object[] { entityReference },
                new CalendarItemMapper());
    } catch (EmptyResultDataAccessException ex) {
        log.debug("getCalendarItems: Empty result executing query: " + ex.getClass() + ":" + ex.getMessage());
        return null;
    } catch (DataAccessException ex) {
        log.warn("getCalendarItems: Error executing query: " + ex.getClass() + ":" + ex.getMessage());
        return null;
    }

}

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

public List<CalendarItem> getCalendarItems(String sakaiUserId, String contextId, boolean saved,
        boolean hidden) {
    if (log.isDebugEnabled()) {
        log.debug("getCalendarItems(" + sakaiUserId + "," + contextId + ")");
    }/*from   ww w .j  a  v  a 2 s .c  om*/
    String sql = null;
    Object[] params = null;
    if (contextId == null) {
        if (hidden) {
            sql = getStatement("select.CalendarItems.by.sakaiId.hidden");
        } else if (saved) {
            sql = getStatement("select.CalendarItems.by.sakaiId.sticky");
        } else {
            sql = getStatement("select.CalendarItems.by.sakaiId");
        }
        params = new Object[] { sakaiUserId };
    } else {
        if (hidden) {
            sql = getStatement("select.CalendarItems.by.sakaiId.contextId.hidden");
        } else if (saved) {
            sql = getStatement("select.CalendarItems.by.sakaiId.contextId.sticky");
        } else {
            sql = getStatement("select.CalendarItems.by.sakaiId.contextId");
        }
        params = new Object[] { sakaiUserId, contextId };
    }

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

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

public List<CalendarItem> getCalendarItemsByContext(String contextId) {

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

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

public CalendarLink getCalendarLink(long calendarItemId, long personId) {
    if (log.isDebugEnabled()) {
        log.debug("getCalendarLink(" + calendarItemId + ", " + personId + ")");
    }/*from  ww  w. j  a v  a2 s .  c  o  m*/

    try {
        return (CalendarLink) getJdbcTemplate().queryForObject(
                getStatement("select.CalendarLink.by.calendarItemId.personId"),
                new Object[] { calendarItemId, personId }, 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 CalendarLink getCalendarLink(long id) {
    if (log.isDebugEnabled()) {
        log.debug("getCalendarLink(" + id + ")");
    }/*  w  w  w  . j  a va 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 + ")");
    }//from  w  ww  .  j  a v  a2 s.  c om

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