Feature query and setting max records...

BillZborowski — Thu, 06 May 2010 12:48:57 GMT

Hi guys,

I'm doing a feature query on a geodata service in AGS 9.3.1 and I'm having some problems. What I want to do is limit the amount of records in each chunk. The default is set to 500, but since our test SDE is located on the other side of the country a query with large amounts of data simply takes too long. Anyhow, what I want to do limit the records, unfortunately I keep getting errors.

Basically what's going on is the application blows up if I don't specify rpi.setCount(4). It also blows up if the rpi.setCount() value is LESS THAN the number of records retrieved by the query. In the case of this particular query, there should be 5 results returned. If i setCount > 5 then it works fine.....but what if the query returns 6? What's going on here?

// Step 1: establish connection to server.
ServerConnection conn = new ServerConnection();
conn.connect(AGSConstants.AGS_SERVER_URL);

// Step 2: Get reference to SOM.
IServerObjectManager som = conn.getServerObjectManager();

// Step 3: Get Map object reference.
IServerContext context = som.createServerContext("gdsCensusView", "GeoDataServer");
GeoDataServer gs = (GeoDataServer)context.getServerObject();
System.out.println(gs.getConfigurationName());
System.out.println(gs.getPhysicalOutputDirectory());
System.out.println(gs.getDefaultWorkingVersion());
  
// Step 4: Perform a Query.
IQueryFilter qf = (IQueryFilter)context.createObject(QueryFilter.getClsid());
qf.setWhereClause("BARLEY_FARM_NUM = 40");
ResultPortionInfo rpi = (ResultPortionInfo)context.createObject(ResultPortionInfo.getClsid());
rpi.setCount(4);
rpi.setStartIndex(0);
IGDSQueryResultPortion resPortion = gs.tableSearch(gs.getDefaultWorkingVersion(), "TEST_VIEW", qf, rpi);
IRecordSet recs = resPortion.getRecords();
ICursor cursor = recs.getCursor(true);
IRow row;
int i = 0;
while ((row = cursor.nextRow()) != null) {
 System.out.println(row.getValue(0));
 System.out.println(row.getValue(1));
 ++i;
}
System.out.println("#####Record Count is " + i);

Re: Feature query and setting max records...

BillZborowski — Wed, 12 May 2010 04:19:52 GMT

Is there nothing that can be done about this? I'm not sure why this is occurring, as the few posts I've seen regarding geodata services seem to suggest it simply cuts off the query at pre-defined maximum. What is the appropriate way to query a geodata service then? I want to specify a query limit of, say, 150 records.

Is there a tutorial somewhere? Does anyone have any experience dealing with this?

topic Feature query and setting max records... in ArcObjects SDK Questions

Feature query and setting max records...

Re: Feature query and setting max records...