@Override public int doSetFieldValue(PreparedStatement ps, int index, Column column) throws SQLException { column.setToPreparedStatement(ps, index, value); return index + 1; } }
@Override public int doSetFieldValue(PreparedStatement ps, int index, Column column) throws SQLException { column.setToPreparedStatement(ps, index, from); column.setToPreparedStatement(ps, index + 1, to); return index + 2; }
protected void setToPreparedStatement(String sql, PreparedStatement ps, List<Column> columns, List<? extends Serializable> values) throws SQLException { if (columns.size() != values.size()) { throw new IllegalStateException(); } for (int i = 0; i < columns.size(); i++) { columns.get(i).setToPreparedStatement(ps, i + 1, values.get(i)); } if (logger.isLogEnabled()) { logger.logSQL(sql, values); } }
private void setFieldValue(PreparedStatement ps, int index, Column column, Object value) { try { column.setToPreparedStatement(ps, index, fieldValueForWrite(value, column)); } catch (SQLException e) { throw new DirectoryException("setFieldValue failed", e); } }
frags = fragments; columns.get(0).setToPreparedStatement(ps, 1, nodeId); columns.get(1).setToPreparedStatement(ps, 2, id); columns.get(2).setToPreparedStatement(ps, 3, frags); columns.get(3).setToPreparedStatement(ps, 4, Long.valueOf(kind)); ps.execute(); countExecute();
@Override public void createClusterNode(Serializable nodeId) { Calendar now = Calendar.getInstance(); String sql = sqlInfo.getCreateClusterNodeSql(); List<Column> columns = sqlInfo.getCreateClusterNodeColumns(); try (PreparedStatement ps = connection.prepareStatement(sql)) { if (logger.isLogEnabled()) { logger.logSQL(sql, Arrays.asList(nodeId, now)); } columns.get(0).setToPreparedStatement(ps, 1, nodeId); columns.get(1).setToPreparedStatement(ps, 2, now); ps.execute(); } catch (SQLException e) { try { checkConcurrentUpdate(e); } catch (ConcurrentUpdateException cue) { cue.addInfo( "Duplicate cluster node with id: " + nodeId + " (a crashed node must be cleaned up, or the repository.clustering.id configuration fixed)"); throw cue; } throw new NuxeoException(e); } }
throw new RuntimeException(key); column.setToPreparedStatement(ps, n, v); if (debugValues != null) { debugValues.add(v);
throw new RuntimeException(column.toString()); column.setToPreparedStatement(ps, i++, v); if (debugValues != null) { debugValues.add(v); whereColumn.setToPreparedStatement(ps, i, id); if (debugValues != null) { debugValues.add(id);
@Override public void removeClusterNode(Serializable nodeId) { // delete from cluster_nodes String sql = sqlInfo.getDeleteClusterNodeSql(); Column column = sqlInfo.getDeleteClusterNodeColumn(); try (PreparedStatement ps = connection.prepareStatement(sql)) { if (logger.isLogEnabled()) { logger.logSQL(sql, Collections.singletonList(nodeId)); } column.setToPreparedStatement(ps, 1, nodeId); ps.execute(); // delete un-processed invals from cluster_invals deleteClusterInvals(nodeId); } catch (SQLException e) { throw new NuxeoException(e); } }
where.setToPreparedStatement(ps, ii++, id);
throw new RuntimeException(key); column.setToPreparedStatement(ps, n, v); if (debugValues != null) { debugValues.add(v);
throw new RuntimeException(key); column.setToPreparedStatement(ps, i, v); if (debugValues != null) { debugValues.add(v);
protected void deleteClusterInvals(Serializable nodeId) throws SQLException { String sql = sqlInfo.getDeleteClusterInvalsSql(); Column column = sqlInfo.getDeleteClusterInvalsColumn(); try (PreparedStatement ps = connection.prepareStatement(sql)) { if (logger.isLogEnabled()) { logger.logSQL(sql, Collections.singletonList(nodeId)); } column.setToPreparedStatement(ps, 1, nodeId); int n = ps.executeUpdate(); countExecute(); if (logger.isLogEnabled()) { logger.logCount(n); } } }
int i = 1; for (Serializable id : todo) { where.setToPreparedStatement(ps, i++, id);
before = delCount > 0; copyIdColumn.setToPreparedStatement(copyPs, 1, newId); copyIdColumn.setToPreparedStatement(copyPs, 2, id); if (logger.isLogEnabled()) { logger.logSQL(copySql, Arrays.asList(newId, id));
int i = 1; for (String key : keys) { keyCol.setToPreparedStatement(ps, i++, key);
column.setToPreparedStatement(ps, i++, (Serializable) vv); if (debugValues != null) { debugValues.add((Serializable) vv); column.setToPreparedStatement(ps, i++, v); if (debugValues != null) { debugValues.add(v);
/** * Updates a row in the database with given explicit values. */ protected void updateSimpleRowWithValues(String tableName, Row row) { Update update = sqlInfo.getUpdateByIdForKeys(tableName, row.getKeys()); Table table = update.getTable(); String sql = update.getStatement(); try (PreparedStatement ps = connection.prepareStatement(sql)) { if (logger.isLogEnabled()) { List<Serializable> values = new LinkedList<>(); values.addAll(row.getValues()); values.add(row.id); // id last in SQL logger.logSQL(sql, values); } int i = 1; List<String> keys = row.getKeys(); List<Serializable> values = row.getValues(); int size = keys.size(); for (int r = 0; r < size; r++) { String key = keys.get(r); Serializable value = values.get(r); table.getColumn(key).setToPreparedStatement(ps, i++, value); } dialect.setId(ps, i, row.id); // id last in SQL int count = ps.executeUpdate(); countExecute(); } catch (SQLException e) { throw new NuxeoException("Could not update: " + sql, e); } }
value = ((Delta) value).getDeltaValue(); column.setToPreparedStatement(ps, i++, value); value = rowu.conditions.get(key); column.setToPreparedStatement(ps, i++, value);
column.setToPreparedStatement(ps, i++, row.get(column.getKey()));