@Override public void clear() { Loggers.SQL_LOG.trace("[IS0123] SQL store: Clearing {} records", getCacheName()); int numDeleted; try { numDeleted = sql.deleteFrom(table(sqlRecordTransformer.getTableName())).execute(); } catch (Exception e) { Loggers.SQL_LOG.error("[IS0124] {}: {}", e.getMessage(), e); throw new PersistenceException(e.getMessage(), e); } Loggers.SQL_LOG.info("[IS0125] SQL store: Cleared {} {} records", numDeleted, sqlRecordTransformer.getTableName()); }
@Override public void clear() { Loggers.SQL_LOG.trace("[IS0123] SQL store: Clearing {} records", getCacheName()); int numDeleted; try (Connection connection = dataSource.getConnection()) { numDeleted = DSL.using(connection, config.sqlDialect) .deleteFrom(table(sqlRecordTransformer.getTableName())) .execute(); } catch (Exception e) { Loggers.SQL_LOG.error("[IS0124] {}: {}", e.getMessage(), e); throw new PersistenceException(e.getMessage(), e); } Loggers.SQL_LOG.info("[IS0125] SQL store: Cleared {} {} records", numDeleted, sqlRecordTransformer.getTableName()); }
DSL.using(getConfiguration()).delete(DSL.table(lockTable)).execute();