DWITHIN filter query fails when a request is made against a feature from an
Oracle datastore
--------------------------------------------------------------------------------------------
Key: GEOS-4384
URL: http://jira.codehaus.org/browse/GEOS-4384
Project: GeoServer
Issue Type: Bug
Components: Oracle
Affects Versions: 2.0.2
Environment: not relevant
Reporter: Pedro Mendes
Assignee: Andrea Aime
Priority: Minor
Attachments: wms.txt
the following GetMap
http://10.112.80.27:8080/Geoserver/wms?service=WMS&version=1.1.0&request=GetMap&layers=cadrede_gis:GIR_INFRA_NODES&styles=&bbox=-89309,-111933,-88509,-111133&width=449&height=512&srs=EPSG:27492&format=image/png&EXCEPTIONS=application/vnd.ogc.se+xml&CQL_FILTER=DWITHIN(LOCATION,POINT(-88909%20-111533),100,meters)
throws a sql exception from db oracle with a message ORA-13207: incorrect use
of the [ INVALID UNITS] operator. The units of measure name in Oracle are in
singular, so a SDO_WITHIN_DISTANCE use must be like, for example
... SDO_WITHIN_DISTANCE(location,
mdsys.sdo_geometry(2001,27492,sdo_point_type(-88909,-111533,null),null,null),
'distance=1000 unit=meter') = 'TRUE' ...
the table with the units of measure
select *
from sdo_units_of_measure a
where lower(a.unit_of_meas_name) like '%meter%'
order by short_name;
the stacktrace in attachment.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
