Here is the problem Justin, MemoryDataStore implements sorting in GeoTools 2.2 - since this is against our own GeoTools interface SortBy interface; we need to do the deprecation dance as we move to GeoAPI. Aside: SortBy2 is our convention to allow extensions beyond the OGC specifications, the specification only allows a propertyName as far as I understand it - hense SortBy2.
I am not familiar with JDBCDataStore and its friend SQLBuilder, but your suggestion sounds good. Cheers, Jody > Hi all, > > Starting to tackle sorting as part of wfs 1.1. The state of things as > they sit today is: > > - Query has a reference to a SortBy which is deprecated, replaced by the > geoapi version. > - There is a SortBy2 interface which adds the ability to supply an > arbitrary expression to sort by > > >From what I can tell none of the data stores support sorting yet. I > would like to target postgis / jdbc as a first step. This will require > an addition to SQLBuilder, a method of the form: > > sqlOrderBy( SortBy[] ); > > Any comments/questions/concerns? > > To do sorting across the board in data store land looks to be quite a > bit of work. The FeatureCollection interface has a sort() method, but > from I can tell it is ignored. And since most data stores don't do the > work of implementing their own FeatureCollections ( they rely on > AbstractDataStore, or JDBCDataStore ), supporting sorting non-naively > looks to me a lot of work. > > -Justin > > ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Geotools-devel mailing list Geotools-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel