public CFCrmMemoDataBuff readBuff(CFSecurityAuthorization Authorization, CFCrmMemoDataPKey PKey) {
   final String S_ProcName = "readBuff";
   if (!schema.isTransactionOpen()) {
     throw CFLib.getDefaultExceptionFactory()
         .newUsageException(getClass(), S_ProcName, "Transaction not open");
   }
   ResultSet resultSet = null;
   try {
     Connection cnx = schema.getCnx();
     long TenantId = PKey.getRequiredTenantId();
     long MemoId = PKey.getRequiredMemoId();
     String sql = "{ call sp_read_memodata( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " ) }";
     if (stmtReadBuffByPKey == null) {
       stmtReadBuffByPKey = cnx.prepareStatement(sql);
     }
     int argIdx = 1;
     stmtReadBuffByPKey.setLong(
         argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
     stmtReadBuffByPKey.setString(
         argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
     stmtReadBuffByPKey.setString(
         argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
     stmtReadBuffByPKey.setLong(
         argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
     stmtReadBuffByPKey.setLong(
         argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
     stmtReadBuffByPKey.setLong(argIdx++, TenantId);
     stmtReadBuffByPKey.setLong(argIdx++, MemoId);
     resultSet = stmtReadBuffByPKey.executeQuery();
     if ((resultSet != null) && resultSet.next()) {
       CFCrmMemoDataBuff buff = unpackMemoDataResultSetToBuff(resultSet);
       if (resultSet.next()) {
         resultSet.last();
         throw CFLib.getDefaultExceptionFactory()
             .newRuntimeException(
                 getClass(),
                 S_ProcName,
                 "Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
       }
       return (buff);
     } else {
       return (null);
     }
   } catch (SQLException e) {
     throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
   } finally {
     if (resultSet != null) {
       try {
         resultSet.close();
       } catch (SQLException e) {
       }
       resultSet = null;
     }
   }
 }
 public void deleteMemoDataByIdIdx(
     CFSecurityAuthorization Authorization, CFCrmMemoDataPKey argKey) {
   deleteMemoDataByIdIdx(Authorization, argKey.getRequiredTenantId(), argKey.getRequiredMemoId());
 }
  public void updateMemoData(CFSecurityAuthorization Authorization, CFCrmMemoDataBuff Buff) {
    final String S_ProcName = "updateMemoData";
    if ("MMOD".equals(Buff.getClassCode())
        && (!schema.isTenantUser(Authorization, Buff.getRequiredTenantId(), "UpdateMemoData"))) {
      throw CFLib.getDefaultExceptionFactory()
          .newRuntimeException(
              getClass(),
              S_ProcName,
              "Permission denied -- User not part of TSecGroup UpdateMemoData");
    }
    try {
      Connection cnx = schema.getCnx();
      long TenantId = Buff.getRequiredTenantId();
      long MemoId = Buff.getRequiredMemoId();
      long ContactId = Buff.getRequiredContactId();
      String Memo = Buff.getRequiredMemo();
      int Revision = Buff.getRequiredRevision();
      CFCrmMemoDataPKey pkey = schema.getFactoryMemoData().newPKey();
      pkey.setRequiredTenantId(Buff.getRequiredTenantId());
      pkey.setRequiredMemoId(Buff.getRequiredMemoId());
      CFCrmMemoDataBuff readBuff = lockBuff(Authorization, pkey);
      if (readBuff == null) {
        throw CFLib.getDefaultExceptionFactory()
            .newStaleCacheDetectedException(
                getClass(),
                S_ProcName,
                "Attempted to update record which could not be locked/found",
                schema.getLowerDbSchemaName() + "..memodata",
                pkey);
      }
      int oldRevision = readBuff.getRequiredRevision();
      if (oldRevision != Revision) {
        throw CFLib.getDefaultExceptionFactory()
            .newCollisionDetectedException(getClass(), S_ProcName, Buff);
      }
      int newRevision = Revision + 1;
      String sql =
          "UPDATE "
              + schema.getLowerDbSchemaName()
              + "..MemoData "
              + "SET "
              + "tenantid = ?"
              + ", "
              + "memoid = ?"
              + ", "
              + "contactid = ?"
              + ", "
              + "memo = ?"
              + ", "
              + "updatedby = ?, "
              + "updatedat = sysdatetime() "
              + ", revision = ? "
              + " WHERE "
              + "tenantid = ? "
              + "AND "
              + "memoid = ? "
              + "AND "
              + "revision = ? ";
      if (stmtUpdateByPKey == null) {
        stmtUpdateByPKey = cnx.prepareStatement(sql);
      }
      int argIdx = 1;

      stmtUpdateByPKey.setLong(argIdx++, TenantId);
      stmtUpdateByPKey.setLong(argIdx++, MemoId);
      stmtUpdateByPKey.setLong(argIdx++, ContactId);
      stmtUpdateByPKey.setString(argIdx++, Memo);
      stmtUpdateByPKey.setString(argIdx++, Authorization.getSecUserId().toString());
      stmtUpdateByPKey.setInt(argIdx++, newRevision);
      stmtUpdateByPKey.setLong(argIdx++, TenantId);
      stmtUpdateByPKey.setLong(argIdx++, MemoId);
      stmtUpdateByPKey.setInt(argIdx++, Revision);
      ;
      int rowsAffected = stmtUpdateByPKey.executeUpdate();
      if (rowsAffected != 1) {
        throw CFLib.getDefaultExceptionFactory()
            .newRuntimeException(
                getClass(),
                S_ProcName,
                "Expected 1 row to be affected by update, not " + rowsAffected);
      }
      Buff.setRequiredRevision(newRevision);
      String sqlAuditUpdated =
          "INSERT INTO "
              + schema.getLowerDbSchemaName()
              + "..MemoData_h( auditclusterid, "
              + " auditsessionid, "
              + " auditstamp"
              + ", "
              + "tenantid"
              + ", "
              + "memoid"
              + ", "
              + "contactid"
              + ", "
              + "memo"
              + ", "
              + " revision, "
              + " auditaction ) "
              + "SELECT ?, ?, sysdatetime()"
              + ", "
              + "mmod.tenantid"
              + ", "
              + "mmod.memoid"
              + ", "
              + "mmod.contactid"
              + ", "
              + "mmod.memo"
              + ", "
              + " mmod.revision, "
              + " 1 "
              + "FROM "
              + schema.getLowerDbSchemaName()
              + "..MemoData AS mmod "
              + " WHERE "
              + "mmod.tenantid = ? "
              + "AND mmod.memoid = ? ";
      if (stmtAuditUpdatedByPKey == null) {
        stmtAuditUpdatedByPKey = cnx.prepareStatement(sqlAuditUpdated);
      }
      argIdx = 1;
      stmtAuditUpdatedByPKey.setLong(argIdx++, Authorization.getSecClusterId());
      stmtAuditUpdatedByPKey.setString(argIdx++, Authorization.getSecSessionId().toString());
      stmtAuditUpdatedByPKey.setLong(argIdx++, TenantId);
      stmtAuditUpdatedByPKey.setLong(argIdx++, MemoId);
      int rowsAudited = stmtAuditUpdatedByPKey.executeUpdate();
      if (rowsAudited != 1) {
        throw CFLib.getDefaultExceptionFactory()
            .newRuntimeException(
                getClass(),
                S_ProcName,
                "Expected 1 row to be affected by audit via insert-selected, not " + rowsAffected);
      }
    } catch (SQLException e) {
      throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
    }
  }