Example usage for org.springframework.dao DataAccessException getClass

Introduction

In this page you can find the example usage for org.springframework.dao DataAccessException 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 boolean updateRepeatingCalendarItemTime(String entityReference, Date newFirstTime, Date newLastTime) {
    if (log.isDebugEnabled()) {
        log.debug("updateRepeatingCalendarItemTime( " + entityReference + "," + newFirstTime + "," + newLastTime
                + ")");
    }//from www  .  j av a  2  s  .co m

    try {
        getJdbcTemplate().update(getStatement("update.RepeatingEventsTime.entityReference"),
                new Object[] { newFirstTime, newLastTime, entityReference });
        return true;
    } catch (DataAccessException ex) {
        log.warn("updateRepeatingCalendarItemTime: Error executing query: " + ex.getClass() + ":"
                + ex.getMessage());
        return false;
    }
}

---

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

public boolean updateRepeatingCalendarItemTitle(String entityReference, String newTitle) {
    if (log.isDebugEnabled()) {
        log.debug("updateRepeatingCalendarItemTitle( " + entityReference + "," + newTitle + ")");
    }/*from w w w .  j  a va 2s  . com*/

    try {
        getJdbcTemplate().update(getStatement("update.RepeatingEventsTitle.entityReference"),
                new Object[] { newTitle, entityReference });
        return true;
    } catch (DataAccessException ex) {
        log.warn("updateRepeatingCalendarItemTitle: Error executing query: " + ex.getClass() + ":"
                + ex.getMessage());
        return false;
    }
}

---

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

public boolean updateTaskLock(long id, boolean hasLock, Date lastUpdate) {
    if (log.isDebugEnabled()) {
        log.debug("updateTaskLock( " + id + "," + hasLock + "," + lastUpdate + ")");
    }/*from   w w  w  .  j  av a 2s  . c o m*/

    try {
        getJdbcTemplate().update(getStatement("update.TaskLock.hasLock"),
                new Object[] { hasLock, lastUpdate, id });
        return true;
    } catch (DataAccessException ex) {
        log.warn("updateTaskLock: Error executing query: " + ex.getClass() + ":" + ex.getMessage());
        return false;
    }
}

---

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

public boolean updateTaskLock(String task, String serverId, Date lastUpdate) {
    if (log.isDebugEnabled()) {
        log.debug("updateTaskLock( " + task + "," + serverId + "," + lastUpdate + ")");
    }//w w  w . j a  va2  s .co  m

    try {
        getJdbcTemplate().update(getStatement("update.TaskLock.lastUpdate"),
                new Object[] { lastUpdate, task, serverId });
        return true;
    } catch (DataAccessException ex) {
        log.warn("updateTaskLock: Error executing query: " + ex.getClass() + ":" + ex.getMessage());
        return false;
    }
}

---

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

/**
 * @param sqlStatement//w w  w  .  ja  v a 2s  .  com
 */
protected void executeSqlStatement(String key) {
    String sqlStatement = getStatement(key);
    if (sqlStatement == null || sqlStatement.trim().equals("")) {
        log.warn("Missing key in database properties file (" + statements.getFileName() + "): " + key);
    } else {
        String parts[] = sqlStatement.split(";");
        if (parts != null) {
            for (String sql : parts) {
                if (sql != null && !sql.trim().equals("")) {
                    try {
                        getJdbcTemplate().execute(sql.trim());

                    } catch (DataIntegrityViolationException e) {
                        // this means we're trying to insert a duplicate
                        log.debug("executeSqlStatement() " + e);
                    } catch (DataAccessException ex) {
                        log.warn("Error executing SQL statement with key: " + key + " -- " + ex.getClass()
                                + ": " + ex.getMessage());
                        //System.out.println("\nError executing SQL statement with key: " + key + " -- " + ex.getClass() + ": \n" + ex.getMessage() + "\n");
                    }
                }
            }
        }
    }
}

---

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

public void setConfigProperty(String propertyName, Integer propertyValue) {

    if (log.isDebugEnabled()) {
        log.debug("setConfigProperty( " + propertyName + "," + propertyValue + ")");
    }/*from  w w  w.ja v a2 s  .  co  m*/

    // insert into dash_config (property_name, property_value) values (?, ?)
    String sql_insert = getStatement("insert.Config");
    Object[] params_insert = new Object[] { propertyName, propertyValue };

    // update dash_config set property_value=? where property_name=?
    String sql_update = getStatement("update.Config.propertyName");
    Object[] params_update = new Object[] { propertyValue, propertyName };

    JdbcTemplate jdbcTemplate = getJdbcTemplate();
    try {
        jdbcTemplate.update(sql_insert, params_insert);
    } catch (DataIntegrityViolationException e) {
        // this means we're trying to insert a duplicate
        log.debug("setConfigProperty() " + e);
    } catch (Exception e) {
        // insert failed -- try update instead of insert
        try {
            jdbcTemplate.update(sql_update, params_update);
        } catch (DataAccessException ex) {
            log.warn("setConfigProperty: Error executing query: " + ex.getClass() + ":" + ex.getMessage());
        } catch (Exception ex) {
            log.warn("setConfigProperty: Error executing query: " + ex.getClass() + ":" + ex.getMessage());
        }
    }

}

---

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

public boolean deleteRepeatingEvent(Long id) {
    if (log.isDebugEnabled()) {
        log.debug("deleteRepeatingEvent( " + id + ")");
    }/*from   w  w  w  .j  a  v a 2s.  co m*/

    try {
        getJdbcTemplate().update(getStatement("delete.RepeatingEvent.by.id"), new Object[] { id });
        return true;
    } catch (DataAccessException ex) {
        log.warn("deleteRepeatingEvent: Error executing query: " + ex.getClass() + ":" + ex.getMessage());
        return false;
    }
}

---

From source file:org.springframework.jdbc.core.JdbcTemplateTests.java

public void testBatchUpdateWithNoBatchSupportAndSelect() throws Exception {
    final String[] sql = { "UPDATE NOSUCHTABLE SET DATE_DISPATCHED = SYSDATE WHERE ID = 1",
            "SELECT * FROM NOSUCHTABLE" };

    MockControl ctrlStatement = MockControl.createControl(Statement.class);
    Statement mockStatement = (Statement) ctrlStatement.getMock();
    mockStatement.getConnection();// w  w  w  . j  a  v a2 s  .  c  o m
    ctrlStatement.setReturnValue(mockConnection);
    mockStatement.execute(sql[0]);
    ctrlStatement.setReturnValue(false);
    mockStatement.getUpdateCount();
    ctrlStatement.setReturnValue(1);
    mockStatement.execute(sql[1]);
    ctrlStatement.setReturnValue(true);
    mockStatement.close();
    ctrlStatement.setVoidCallable();

    MockControl ctrlDatabaseMetaData = MockControl.createControl(DatabaseMetaData.class);
    DatabaseMetaData mockDatabaseMetaData = (DatabaseMetaData) ctrlDatabaseMetaData.getMock();
    mockDatabaseMetaData.getDatabaseProductName();
    ctrlDatabaseMetaData.setReturnValue("MySQL");
    mockDatabaseMetaData.supportsBatchUpdates();
    ctrlDatabaseMetaData.setReturnValue(false);

    mockConnection.getMetaData();
    ctrlConnection.setReturnValue(mockDatabaseMetaData, 2);
    mockConnection.createStatement();
    ctrlConnection.setReturnValue(mockStatement);

    ctrlStatement.replay();
    ctrlDatabaseMetaData.replay();
    replay();

    JdbcTemplate template = new JdbcTemplate(mockDataSource, false);

    try {
        template.batchUpdate(sql);
        fail("Shouldn't have executed batch statement with a select");
    } catch (DataAccessException ex) {
        // pass
        assertTrue("Check exception type", ex.getClass() == InvalidDataAccessApiUsageException.class);
    }

    ctrlStatement.verify();
    ctrlDatabaseMetaData.verify();
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• »