> > I also tried to implement date comparsion using the cql_filter and the > 'AFTER' > operator > as follows but this didn't work: > > http://server.metoc.gov.au:8080/geoserver/wfs?request=GetFeature&typeName=TEST:TEST.BEACH_TEMPS&cql_Filter=LOCATION%3D%27Bilgola%27%20AND%20OBS_DATE_TIME%20AFTER%202011-01-01T00:01:00Z&version=1.1.0&outputFormat=csv > > This gave back 0 results and the following error msg. in the geoserver.log: > > 2011-04-11 13:39:31,083 WARN [data.ArcSDEQuery] - Error fetching row for > TEST.BEACH_TEMPS[ > Filter: [[ LOCATION = Bilgola ] AND [ OBS_DATE_TIME > Sat Jan 01 00:01:00 EST > 2011 ]] > where clause sent: (TEST.BEACH_TEMPS.LOCATION = 'Bilgola' AND > TEST.BEACH_TEMPS.OBS_DATE_TIME > 'Sat Jan 01 00:01:00 EST 2011') > geometry filter:Filter.INCLUDE > org.geotools.arcsde.ArcSdeException: [SDE error -51][Error desc=DATABASE > LEVEL > ERROR OCCURRED.][Extended desc= > ] > > Looks like Oracle was not liking the SQL sent to it. Indeed it is not, and yeah it looks like a bug in the ArcSDE GeoTools plugin. How should the where clause look like and what type is the column?
Gabriel. > > Andrew Walsh > > > > > ------------------------------------------------------------------------------ > Xperia(TM) PLAY > It's a major breakthrough. An authentic gaming > smartphone on the nation's most reliable network. > And it wants your games. > http://p.sf.net/sfu/verizon-sfdev > _______________________________________________ > Geoserver-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Gabriel Roldan [email protected] Expert service straight from the developers ------------------------------------------------------------------------------ Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
