On Wed, 2011-04-13 at 10:10 +1000, andrew walsh wrote: > Hi Gabriel, > > Sending the below message again for benefit of the list is it looks like it > bounced off the > geoserver-users list as it was from my gmail and said 'awaiting moderator > approval':- > > Thanks for your reply. > I am not so familiar the geoserver Java code workings and not in a position > to debug/compile and submit a patch. However I would be happy to raise this > issue on JIRA for the GeoTools ArcSDE plugin. Can't remember my login details > for Jira but I will find out when I get back to the office and raise > a ticket. ok, sounds good. > > There were 2 other issues which I raised in my initial email on April 11 for > which I > have not got any opinions yet, so comments please from > anyone out there in the Geoserver community: > > 1) the addition of a random 1/1000 sec value being added to the DATE > when it comes back in GML or CSV from getFeature. To me this doesn't seem > correct. That is if you have DATE like 2000-01-01 09:00:01 in > Oracle then it should return a ISO8601 style TIMESTAMP > like '2000-01-01T09:00:01.000' not e.g "'2000-01-01T09:00:01.067"". > What's the view on this behaviour, is this a bug worth > reporting as well? > > 2) With date comparison the operators PropertyIsGreaterThan (>) and > PropertyIsLessThan (<) work OK but PropertyIsLessThanEqualTo (<=) and > PropertyIsGreaterThanEqualTo (>=) do not work, that is the > <= and >= filter had no effect and returned 'True'. It would be > much better if this worked correctly as we frequently need an inclusive > range of date/time. may this be related to 1), like in it doesn't work because of that little difference? Can you check (somehow, I know almost nothing about oracle) the Oracle logs and see what request is coming in, and how it should actually be?
Cheers, Gabriel > > Thanks and Regards, > > Andrew > -- Gabriel Roldan grol...@opengeo.org Expert service straight from the developers ------------------------------------------------------------------------------ Forrester Wave Report - Recovery time is now measured in hours and minutes not days. Key insights are discussed in the 2010 Forrester Wave Report as part of an in-depth evaluation of disaster recovery service providers. Forrester found the best-in-class provider in terms of services and vision. Read this report now! http://p.sf.net/sfu/ibm-webcastpromo _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
