From: Andrea A. <aa...@op...> - 2007-11-01 14:13:09
|
Patrick Mollbrink ha scritto: > Hi Justin, > > Thanks for your reply, as you probably understand I'm new to Geoserver > and I'm still trying to grasp the big picture of things. > > So, I guess that in real life it's really a matter of trail and error > depending on the DataStore :) > That is ok, I really wanted to find out if there are any major do's and > dont's to handling this. > > You mention date as a potential problem, have you any experience with > syntax like the one below? > > <Filter> > <Between> > <PropertyName>START_TIME</PropertyName> > <LowerBoundary> > <Literal>2008-01-01T00:00:00.00</Literal> > </LowerBoundary> > <UpperBoundary> > <Literal>2008-01-01T12:00:00.00</Literal> > </UpperBoundary> > </Between> > </Filter> > > I have just configured my test environment Oracle XE, Geoserver and > MapInfo Pro and everything works fine. > Next week I will try to define the syntax for the filters, so I might > just take your offer of asking more :) As far as I know Oracle + dates -> boom, there are some issues open about it: http://jira.codehaus.org/browse/GEOT-725 http://jira.codehaus.org/browse/GEOT-1353 Unfortunately there is no maintainer for the Oracle data store (I'm the assignee of the issues just as a placeholder, waiting for someone to step up and become a real mantainer). If you want these to be fixed quickly you should explore the idea of contracting some company to do the associated developments, such as TOPP, Refractions, Geomatys, Geosolutions and the like. I guess fixing these should not take more than a few days. Cheers Andrea |