Exemplo n.º 1
0
 private String toString(SeQueryInfo qInfo) {
   StringBuffer sb = new StringBuffer("SeQueryInfo[\n\tcolumns=");
   try {
     SeSqlConstruct sql = qInfo.getConstruct();
     String[] tables = sql.getTables();
     String[] cols = qInfo.getColumns();
     String by = null;
     try {
       by = qInfo.getByClause();
     } catch (NullPointerException npe) {
       // no-op
     }
     String where = sql.getWhere();
     for (int i = 0; cols != null && i < cols.length; i++) {
       sb.append(cols[i]);
       if (i < cols.length - 1) sb.append(", ");
     }
     sb.append("\n\tTables=");
     for (int i = 0; i < tables.length; i++) {
       sb.append(tables[i]);
       if (i < tables.length - 1) sb.append(", ");
     }
     sb.append("\n\tWhere=");
     sb.append(where);
     sb.append("\n\tOrderBy=");
     sb.append(by);
   } catch (SeException e) {
     sb.append("Exception retrieving query info properties: " + e.getMessage());
   }
   sb.append("]");
   return sb.toString();
 }
Exemplo n.º 2
0
    /**
     * Returns an SeQueryInfo that can be used to retrieve a set of SeRows from an ArcSDE layer or a
     * layer with joins. The SeQueryInfo object lacks the set of column names to fetch. It is the
     * responsibility of the calling code to call setColumns(String []) on the returned object to
     * specify which properties to fetch.
     *
     * @param unqualifiedPropertyNames non null, possibly empty, list of property names to fetch
     * @return
     * @throws IOException
     */
    public SeQueryInfo getQueryInfo(final String[] unqualifiedPropertyNames) throws IOException {
      assert unqualifiedPropertyNames != null;
      String[] tables;
      String byClause = null;

      final SeSqlConstruct plainSqlConstruct = getSeSqlConstruct();

      String where = plainSqlConstruct.getWhere();

      try {
        if (definitionQuery == null) {
          tables = new String[] {this.sdeTable.getQualifiedName()};
        } else {
          tables = definitionQuery.getConstruct().getTables();
          String joinWhere = definitionQuery.getConstruct().getWhere();
          if (where == null) {
            where = joinWhere;
          } else {
            where = joinWhere == null ? where : (joinWhere + " AND " + where);
          }
          try {
            byClause = definitionQuery.getByClause();
          } catch (NullPointerException e) {
            // no-op
          }
        }

        final SeQueryInfo qInfo = new SeQueryInfo();
        final SeSqlConstruct sqlConstruct = new SeSqlConstruct();
        sqlConstruct.setTables(tables);
        if (where != null && where.length() > 0) {
          sqlConstruct.setWhere(where);
        }

        final int queriedAttCount = unqualifiedPropertyNames.length;

        if (queriedAttCount > 0) {
          String[] sdeAttNames = new String[queriedAttCount];
          FilterToSQLSDE sqlEncoder = getSqlEncoder();

          for (int i = 0; i < queriedAttCount; i++) {
            String attName = unqualifiedPropertyNames[i];
            String coldef = sqlEncoder.getColumnDefinition(attName);
            sdeAttNames[i] = coldef;
          }
          qInfo.setColumns(sdeAttNames);
        }

        qInfo.setConstruct(sqlConstruct);
        if (byClause != null) {
          qInfo.setByClause(byClause);
        }
        return qInfo;
      } catch (SeException e) {
        throw new ArcSdeException(e);
      }
    }
Exemplo n.º 3
0
  /**
   * Returns the envelope for all features within the layer that pass any SQL construct, state, or
   * spatial constraints for the stream.
   */
  public Envelope calculateQueryExtent() throws IOException {

    LOGGER.fine("Building a new SeQuery to consult it's resulting envelope");

    final SeExtent extent;
    try {
      extent =
          session.issue(
              new Command<SeExtent>() {
                @Override
                public SeExtent execute(ISession session, SeConnection connection)
                    throws SeException, IOException {

                  final String[] spatialCol = {schema.getGeometryDescriptor().getLocalName()};
                  // fullConstruct may hold information about multiple tables in case of an
                  // in-process view
                  final SeSqlConstruct fullConstruct =
                      filters.getQueryInfo(spatialCol).getConstruct();
                  String whereClause = fullConstruct.getWhere();
                  if (whereClause == null) {
                    /*
                     * we really need a where clause or will get a famous -51 DATABASE LEVEL
                     * ERROR with no other explanation on some oracle databases
                     */
                    whereClause = "1 = 1";
                  }
                  final SeFilter[] spatialConstraints = filters.getSpatialFilters();

                  SeExtent extent;

                  final SeQuery extentQuery = new SeQuery(connection);
                  try {
                    versioningHandler.setUpStream(session, extentQuery);

                    if (spatialConstraints.length > 0) {
                      extentQuery.setSpatialConstraints(
                          SeQuery.SE_OPTIMIZE, false, spatialConstraints);
                    }

                    SeSqlConstruct sqlCons = new SeSqlConstruct();
                    sqlCons.setTables(fullConstruct.getTables());
                    sqlCons.setWhere(whereClause);

                    final SeQueryInfo seQueryInfo = new SeQueryInfo();
                    seQueryInfo.setColumns(spatialCol);
                    seQueryInfo.setConstruct(sqlCons);

                    extent = extentQuery.calculateLayerExtent(seQueryInfo);
                  } finally {
                    extentQuery.close();
                  }

                  return extent;
                }
              });
    } catch (IOException ex) {
      SeSqlConstruct sqlCons = this.filters.getSeSqlConstruct();
      String sql = (sqlCons == null) ? null : sqlCons.getWhere();
      String tables = (sqlCons == null) ? null : Arrays.asList(sqlCons.getTables()).toString();
      if (ex.getCause() instanceof SeException) {
        SeException sdeEx = (SeException) ex.getCause();
        if (sdeEx.getSeError().getSdeError() == -288) {
          // gah, the dreaded 'LOGFILE SYSTEM TABLES DO NOT EXIST'
          // error.
          // this error is worthless. Make it quiet, at least.
          LOGGER.severe(
              "ArcSDE is complaining that your 'LOGFILE SYSTEM "
                  + "TABLES DO NOT EXIST'.  This is an ignorable error.");
        }
      }
      LOGGER.log(
          Level.SEVERE,
          "***********************\ntables: "
              + tables
              + "\nfilter: "
              + this.filters.getGeometryFilter()
              + "\nSQL: "
              + sql,
          ex);
      throw ex;
    }

    Envelope envelope =
        new Envelope(extent.getMinX(), extent.getMaxX(), extent.getMinY(), extent.getMaxY());
    if (LOGGER.isLoggable(Level.FINE)) {
      LOGGER.fine("got extent: " + extent + ", built envelope: " + envelope);
    }
    return envelope;
  }