How to use

getPrimaryColumn

method

in

org.nuxeo.ecm.core.storage.sql.jdbc.db.Table

@Override
public Column getPrimaryColumn() {
  return new Column(table.getPrimaryColumn(), this);
}

@Override
public void deleteEntryWithoutReferences(String id) {
  // second step: clean stored fields
  Delete delete = new Delete(table);
  String whereString = table.getPrimaryColumn().getQuotedName() + " = ?";
  delete.setWhere(whereString);
  String sql = delete.getStatement();
  if (logger.isLogEnabled()) {
    logger.logSQL(sql, Collections.singleton(id));
  }
  try (PreparedStatement ps = sqlConnection.prepareStatement(sql)) {
    setFieldValue(ps, 1, table.getPrimaryColumn(), id);
    ps.execute();
  } catch (SQLException e) {
    checkConcurrentUpdate(e);
    throw new DirectoryException("deleteEntry failed", e);
  }
}

List<Serializable> values = new ArrayList<>(1 + map.size());
whereClause.append(table.getPrimaryColumn().getQuotedName());
whereClause.append(" = ?");
values.add(id);
  for (int i = 0; i < values.size(); i++) {
    if (i == 0) {
      setFieldValue(ps, 1, table.getPrimaryColumn(), values.get(i));
    } else {
      ps.setString(1 + i, (String) values.get(i));

@Override
public boolean hasEntry(String id) {
  acquireConnection();
  Select select = new Select(table);
  select.setFrom(table.getQuotedName());
  select.setWhat("1");
  select.setWhere(table.getPrimaryColumn().getQuotedName() + " = ?");
  String sql = select.getStatement();
  if (logger.isLogEnabled()) {
    logger.logSQL(sql, Collections.singleton(id));
  }
  try (PreparedStatement ps = sqlConnection.prepareStatement(sql)) {
    setFieldValue(ps, 1, table.getPrimaryColumn(), id);
    try (ResultSet rs = ps.executeQuery()) {
      boolean has = rs.next();
      if (logger.isLogEnabled()) {
        logger.logCount(has ? 1 : 0);
      }
      return has;
    }
  } catch (SQLException e) {
    throw new DirectoryException("hasEntry failed", e);
  }
}

String whereClause = table.getPrimaryColumn().getQuotedName() + " = ?";
whereClause = addFilterWhereClause(whereClause);
select.setWhere(whereClause);
  setFieldValue(ps, 1, table.getPrimaryColumn(), id);
  addFilterValues(ps, 2);
  try (ResultSet rs = ps.executeQuery()) {

select.setWhat(getReadColumnsSQL());
String whereClause = table.getPrimaryColumn().getQuotedName() + " = ?";
whereClause = addFilterWhereClause(whereClause);
  setFieldValue(ps, 1, table.getPrimaryColumn(), id);
  addFilterValues(ps, 2);

String whereString = table.getPrimaryColumn().getQuotedName() + " = ?";
update.setWhere(whereString);
String sql = update.getStatement();
    index++;
  setFieldValue(ps, index, table.getPrimaryColumn(), docModel.getId());
  ps.execute();
} catch (SQLException e) {