public void remove(String handle) { try { String sql = "DELETE FROM " + _tableName + " WHERE handle=?"; JdbcTemplate jdbcTemplate = getJdbcTemplate(); int cnt = jdbcTemplate.update(sql, new Object[]{handle}); if (cnt == 1 && DEBUG) { _log.debug("Removed association, handle: " + handle + " from table: " + _tableName); } if (cnt != 1) { _log.warn("Trying to remove handle: " + handle + " from table: " + _tableName + "; affected entries: " + cnt); } } catch (Exception e) { _log.error("Error removing association from table: " + _tableName, e); } }
public void remove(String handle) { try { String sql = "DELETE FROM " + _tableName + " WHERE handle=?"; JdbcTemplate jdbcTemplate = getJdbcTemplate(); int cnt = jdbcTemplate.update(sql, new Object[] { handle } ); if (cnt == 1 && DEBUG) _log.debug("Removed association, handle: " + handle + " from table: " + _tableName); if (cnt != 1) _log.warn("Trying to remove handle: " + handle + " from table: " + _tableName + "; affected entries: " + cnt); } catch (Exception e) { _log.error("Error removing association from table: " + _tableName, e); } }
public void remove(String handle) { try { String sql = "DELETE FROM " + _tableName + " WHERE handle=?"; JdbcTemplate jdbcTemplate = getJdbcTemplate(); int cnt = jdbcTemplate.update(sql, new Object[] { handle } ); if (cnt == 1 && DEBUG) _log.debug("Removed association, handle: " + handle + " from table: " + _tableName); if (cnt != 1) _log.warn("Trying to remove handle: " + handle + " from table: " + _tableName + "; affected entries: " + cnt); } catch (Exception e) { _log.error("Error removing association from table: " + _tableName, e); } }
public void remove(String handle) { try { String sql = "DELETE FROM " + _tableName + " WHERE handle=?"; JdbcTemplate jdbcTemplate = getJdbcTemplate(); int cnt = jdbcTemplate.update(sql, new Object[] { handle } ); if (cnt == 1 && DEBUG) _log.debug("Removed association, handle: " + handle + " from table: " + _tableName); if (cnt != 1) _log.warn("Trying to remove handle: " + handle + " from table: " + _tableName + "; affected entries: " + cnt); } catch (Exception e) { _log.error("Error removing association from table: " + _tableName, e); } }
private void cleanupExpired() { if (System.currentTimeMillis() - _lastCleanup < CLEANUP_INTERVAL) { return; } try { String sql = "DELETE FROM " + _tableName + " WHERE expdate<?"; JdbcTemplate jdbcTemplate = getJdbcTemplate(); Date now = new Date(); int cnt = jdbcTemplate.update(sql, new Object[]{now}); _log.debug("Cleaned " + cnt + " expired associations from table: " + _tableName); _lastCleanup = System.currentTimeMillis(); } catch (Exception e) { _log.error("Error removing expired associations from table: " + _tableName, e); } } }
public void remove(String handle) { try { String sql = "DELETE FROM " + _tableName + " WHERE handle=?"; JdbcTemplate jdbcTemplate = getJdbcTemplate(); int cnt = jdbcTemplate.update(sql, new Object[] { handle } ); if (cnt == 1 && DEBUG) _log.debug("Removed association, handle: " + handle + " from table: " + _tableName); if (cnt != 1) _log.warn("Trying to remove handle: " + handle + " from table: " + _tableName + "; affected entries: " + cnt); } catch (Exception e) { _log.error("Error removing association from table: " + _tableName, e); } }
private void cleanupExpired() { if (System.currentTimeMillis() - _lastCleanup < CLEANUP_INTERVAL) return; try { String sql = "DELETE FROM " + _tableName + " WHERE expdate<?"; JdbcTemplate jdbcTemplate = getJdbcTemplate(); Date now = new Date ( ) ; int cnt = jdbcTemplate.update(sql, new Object[] { now } ); _log.debug("Cleaned " + cnt + " expired associations from table: " + _tableName); _lastCleanup = System.currentTimeMillis(); } catch (Exception e) { _log.error("Error removing expired associations from table: " + _tableName, e); } } }
private void cleanupExpired() { if (System.currentTimeMillis() - _lastCleanup < CLEANUP_INTERVAL) return; try { String sql = "DELETE FROM " + _tableName + " WHERE expdate<?"; JdbcTemplate jdbcTemplate = getJdbcTemplate(); Date now = new Date ( ) ; int cnt = jdbcTemplate.update(sql, new Object[] { now } ); _log.debug("Cleaned " + cnt + " expired associations from table: " + _tableName); _lastCleanup = System.currentTimeMillis(); } catch (Exception e) { _log.error("Error removing expired associations from table: " + _tableName, e); } } }
private void cleanupExpired() { if (System.currentTimeMillis() - _lastCleanup < CLEANUP_INTERVAL) return; try { String sql = "DELETE FROM " + _tableName + " WHERE expdate<?"; JdbcTemplate jdbcTemplate = getJdbcTemplate(); Date now = new Date ( ) ; int cnt = jdbcTemplate.update(sql, new Object[] { now } ); _log.debug("Cleaned " + cnt + " expired associations from table: " + _tableName); _lastCleanup = System.currentTimeMillis(); } catch (Exception e) { _log.error("Error removing expired associations from table: " + _tableName, e); } } }
private void cleanupExpired() { if (System.currentTimeMillis() - _lastCleanup < CLEANUP_INTERVAL) return; try { String sql = "DELETE FROM " + _tableName + " WHERE expdate<?"; JdbcTemplate jdbcTemplate = getJdbcTemplate(); Date now = new Date ( ) ; int cnt = jdbcTemplate.update(sql, new Object[] { now } ); _log.debug("Cleaned " + cnt + " expired associations from table: " + _tableName); _lastCleanup = System.currentTimeMillis(); } catch (Exception e) { _log.error("Error removing expired associations from table: " + _tableName, e); } } }
" WHERE handle=?"; JdbcTemplate jdbcTemplate = getJdbcTemplate();
" WHERE handle=?"; JdbcTemplate jdbcTemplate = getJdbcTemplate();
" WHERE handle=?"; JdbcTemplate jdbcTemplate = getJdbcTemplate();
" WHERE handle=?"; JdbcTemplate jdbcTemplate = getJdbcTemplate();
" WHERE handle=?"; JdbcTemplate jdbcTemplate = getJdbcTemplate();
" (handle, type, mackey, expdate) VALUES (?,?,?,?)"; JdbcTemplate jdbcTemplate = getJdbcTemplate();
" (handle, type, mackey, expdate) VALUES (?,?,?,?)"; JdbcTemplate jdbcTemplate = getJdbcTemplate();
" (handle, type, mackey, expdate) VALUES (?,?,?,?)"; JdbcTemplate jdbcTemplate = getJdbcTemplate();
" (handle, type, mackey, expdate) VALUES (?,?,?,?)"; JdbcTemplate jdbcTemplate = getJdbcTemplate();
" (handle, type, mackey, expdate) VALUES (?,?,?,?)"; JdbcTemplate jdbcTemplate = getJdbcTemplate();