コード例 #1
0
  @Override
  public SQLAction batchAction(BatchQuery query) {
    // check run strategy...

    // optimistic locking is not supported in batches due to JDBC driver limitations
    boolean useOptimisticLock = query.isUsingOptimisticLocking();

    boolean runningAsBatch = !useOptimisticLock && dataNode.getAdapter().supportsBatchUpdates();
    return new PostgresBatchAction(query, dataNode, runningAsBatch);
  }
コード例 #2
0
  public String createLOBSelectString(
      BatchQuery updateQuery, List selectedLOBAttributes, List qualifierAttributes) {

    boolean status;
    if (updateQuery.getDbEntity().getDataMap() != null
        && updateQuery.getDbEntity().getDataMap().isQuotingSQLIdentifiers()) {
      status = true;
    } else {
      status = false;
    }
    QuotingStrategy strategy = getAdapter().getQuotingStrategy(status);

    StringBuffer buf = new StringBuffer();
    buf.append("SELECT ");

    Iterator it = selectedLOBAttributes.iterator();
    while (it.hasNext()) {
      buf.append(strategy.quoteString(((DbAttribute) it.next()).getName()));

      if (it.hasNext()) {
        buf.append(", ");
      }
    }

    buf.append(" FROM ")
        .append(strategy.quoteFullyQualifiedName(updateQuery.getDbEntity()))
        .append(" WHERE ");

    it = qualifierAttributes.iterator();
    while (it.hasNext()) {
      DbAttribute attribute = (DbAttribute) it.next();
      appendDbAttribute(buf, attribute);
      buf.append(" = ?");
      if (it.hasNext()) {
        buf.append(" AND ");
      }
    }

    buf.append(" FOR UPDATE");
    return buf.toString();
  }
コード例 #3
0
  /** Binds BatchQuery parameters to the PreparedStatement. */
  @Override
  public void bindParameters(PreparedStatement statement, BatchQuery query)
      throws SQLException, Exception {

    List<DbAttribute> dbAttributes = query.getDbAttributes();
    int attributeCount = dbAttributes.size();

    // i - attribute position in the query
    // j - PreparedStatement parameter position (starts with "1")
    for (int i = 0, j = 1; i < attributeCount; i++) {
      Object value = query.getValue(i);
      DbAttribute attribute = dbAttributes.get(i);
      int type = attribute.getType();

      // TODO: (Andrus) This works as long as there is no LOBs in qualifier
      if (isUpdateableColumn(value, type)) {
        adapter.bindParameter(statement, value, j, type, attribute.getScale());

        j++;
      }
    }
  }