Pascal Romaric ha scritto: > Hello, > > > > I'm building a spatial application over an Oracle 10g spatial database. > I try to limit the numbers of features returned by my queries using > Query.setStartIndex and Query.setMaxFeature methods, but when i get my > results the startIndex condition seems to be ignored (the maxfeature > part works well). > > > > Does anybody have a clue on this problem ? Is it a known issue ?
startIndex is not one of the Query properties that all datastores have to implement. You can check if a datastore implements it by using FeatureSource.getQueryCapabilitis().isOffsetSupported() (hmm... naming incoherence... darn, too late to fix it). If you want a datastore that can connect to Oracle and can support both startIndex and maxFeatures in a native way (that is, using @rownumber) have a look at the jdbc-oracle one, part of the new series of jdbc-ng datastores that are soon going to replace fully all the old jdbc based datastores. (even in that case, you'll need a table with a primary key, or to specify a sort by, we don't support startindex/limit if there is no way to get a stable return order). Cheers Andrea -- Andrea Aime OpenGeo - http://opengeo.org Expert service straight from the developers. ------------------------------------------------------------------------------ Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT is a gathering of tech-side developers & brand creativity professionals. Meet the minds behind Google Creative Lab, Visual Complexity, Processing, & iPhoneDevCamp as they present alongside digital heavyweights like Barbarian Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com _______________________________________________ Geotools-gt2-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
