On Mon, Dec 2, 2013 at 11:47 PM, Martin Davis <[email protected]> wrote:
> Further to this issue, there's good news and bad news.
>
> The good news is that including the TIME= parameter eliminates the error,
> and appears to work *as designed*. (Although it would be nice to be able
> to omit the TIME= parameter and have some sensible default in place to
> avoid the error. Perhaps the default could be TIME=<current time> ?)
>
> The bad news is that the temporal query emitted by GeoServer does not
> match the temporal semantics of Oracle, and thus does not return enough
> data. For a query of a time instant:
>
> GeoServer emits: SELECT ... WHERE ((? >= VALID_START AND ? <=
> VALID_END) AND SDO_FILTER(... )
>
> As I mentioned before, Oracle uses a closed-open period model, with
> VALID-END = NULL representing an open period. Therefore to return all
> records current at the given time the query should be:
>
> SELECT ... WHERE ((? >= VALID_START AND (? <= VALID_END OR VALID_END IS
> NULL) AND SDO_FILTER(... )
>
This filter is actually written as an OGC filter somewhere in the WMS
module (WMS class, buildDimensionFilter method), adding an extra to it
would be easy.
DB2 should not break because of the extra condition right? I mean, the
validation should be done on inserts/updates, but now on the
queries being performed on the data, or am I missing something?
As far as I remember Ian added support for time periods in GeoServer vector
data, would be useful to also hear
his perspective on this (maybe there was a reason to setup the code to work
on closed periods only?)
Cheers
Andrea
--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
