Re: [Geotools-devel] Unsorted features from H2?

[Justin D. <jde...@op...>]

On Tue, May 22, 2012 at 9:07 PM, Ben Caradoc-Davies <
Ben...@cs...> wrote:

> Justin,
>
> I am attempting to use H2 to test sorting of features (in the context of
> GeoServer paging, i.e. WFS 2.0 GetFeaturePagingTest).
>
> When I add features to an H2 data store, they seem to always come out
> sorted by fid, even when I put them in intentionally unsorted (via
> ListFeatureCollection). Is this an innate property of the H2 data store
> (meaning my test fixture is doomed) or should I be able to get unsorted
> features?
>
Hmmm... i don;t know of any explicit sorting by id... but it could very
well be in there. I would turn on debug logging in the jdbc module and see
what sql is actually being created. It could be that h2 automatically
returns data sorted by the primary key.

>
> Kind regards,
>
> --
> Ben Caradoc-Davies <Ben...@cs...>
> Software Engineer
> CSIRO Earth Science and Resource Engineering
> Australian Resources Research Centre
>



-- 
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.