Examples of com.esri.sde.sdk.client.SeQuery.prepareQuery()

com.esri.sde.sdk.client.SeQuery.prepareQuery()

      SeSqlConstruct sqlConstruct = new SeSqlConstruct();
      String[] tables = {METADATA_TABLE };
      sqlConstruct.setTables(tables);
      String[] propertyNames = { METADATA_COLUMN };      
      SeQuery query = new SeQuery(seConnection);
      query.prepareQuery(propertyNames, sqlConstruct);
      query.execute();
      
      // it is not documented in the ArcSDE API how you know there are no more rows to fetch!
      // I'm assuming: query.fetch returns null (empiric tests indicate this assumption is correct).
      boolean allRowsFetched = false;

View Full Code Here

                @Override
                public SeQuery execute(ISession session, SeConnection connection)
                        throws SeException, IOException {
                    SeQuery seQuery = new SeQuery(connection, new String[] { "ROW_ID", "INT32_COL",
                            "STRING_COL" }, new SeSqlConstruct(typeName, whereClause));
                    seQuery.prepareQuery();
                    seQuery.execute();
                    return seQuery;
                }
            });

View Full Code Here

        SeRasterAttr rasterAttributes;
        LinkedList<SeRasterAttr> rasterAttList = new LinkedList<SeRasterAttr>();
        SeQuery query = null;
        try {
            query = new SeQuery(scon, rasterColumns, new SeSqlConstruct(rasterTable));
            query.prepareQuery();
            query.execute();


            SeRow row = query.fetch();
            while (row != null) {
                rasterAttributes = row.getRaster(0);

View Full Code Here

            sqlConstruct.setTables(new String[] { auxTableName });
            String whereClause = "TYPE = 3";
            sqlConstruct.setWhere(whereClause);


            query = new SeQuery(scon, new String[] { "RASTERBAND_ID", "OBJECT" }, sqlConstruct);
            query.prepareQuery();
            query.execute();


            long bandId;
            ByteArrayInputStream colorMapIS;
            DataBuffer colorMapData;

View Full Code Here

            SeSqlConstruct sqlCons = new SeSqlConstruct(rastersColumnsTable);
            sqlCons.setWhere("RASTERCOLUMN_ID = " + rasterColumnId);


            try {
                query = new SeQuery(scon, new String[] { "OWNER" }, sqlCons);
                query.prepareQuery();
            } catch (SeException e) {
                // sde 9.3 calls it raster_columns, not sde_raster_columns...
                rastersColumnsTable = dbaName + ".RASTER_COLUMNS";
                sqlCons = new SeSqlConstruct(rastersColumnsTable);
                sqlCons.setWhere("RASTERCOLUMN_ID = " + rasterColumnId);

View Full Code Here

                // sde 9.3 calls it raster_columns, not sde_raster_columns...
                rastersColumnsTable = dbaName + ".RASTER_COLUMNS";
                sqlCons = new SeSqlConstruct(rastersColumnsTable);
                sqlCons.setWhere("RASTERCOLUMN_ID = " + rasterColumnId);
                query = new SeQuery(scon, new String[] { "OWNER" }, sqlCons);
                query.prepareQuery();
            }
            query.execute();


            SeRow row = query.fetch();
            if (row == null) {

View Full Code Here

            @Override
            public Integer execute(ISession session, SeConnection connection) throws SeException,
                    IOException {
                final SeQuery rowQuery = new SeQuery(connection, columns, sql);
                rowQuery.setSpatialConstraints(SeQuery.SE_OPTIMIZE, false, spatFilters);
                rowQuery.prepareQuery();
                rowQuery.execute();


                // fetch some rows
                rowQuery.fetch();
                rowQuery.fetch();

View Full Code Here

                    SeQuery transQuery = new SeQuery(connection, columns, sqlConstruct);
                    // transaction is not committed, so transQuery should give
                    // the
                    // inserted
                    // record and query don't
                    transQuery.prepareQuery();
                    transQuery.execute();
                    SeRow transRow = transQuery.fetch();
                    // querying over a transaction in progress does give diff
                    // assertEquals(Integer.valueOf(50), transRow.getInteger(0))
                    transQuery.close();

View Full Code Here

            final SeRow noTransRow = session.issue(new Command<SeRow>() {
                @Override
                public SeRow execute(ISession session, SeConnection connection) throws SeException,
                        IOException {
                    SeQuery query = new SeQuery(connection, columns, sqlConstruct);
                    query.prepareQuery();
                    query.execute();
                    SeRow row = query.fetch();
                    query.close();
                    return row;
                }

View Full Code Here


        @Override
        public SeQuery execute(final ISession session, final SeConnection connection)
                throws SeException, IOException {
            SeQuery query = new SeQuery(connection, propertyNames, sql);
            query.prepareQuery();
            query.execute();
            return query;
        }


    }

View Full Code Here

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.