The query of an Oracle Spatial vector table in GeoServer always fails due to incorrect SQL statement generated in the GeoServer.
--------------------------------------------------------------------------------------------------------------------------------
Key: GEOS-2105
URL: http://jira.codehaus.org/browse/GEOS-2105
Project: GeoServer
Issue Type: Bug
Components: Oracle
Affects Versions: 1.6.4
Environment: Windows XP on Intel.
Reporter: Gordon Deng
Assignee: Andrea Aime
Priority: Blocker
Using the Oracle Spatial extension within the GeoServe, I configured an Oracle DataStore and A vector-based feature type (the soure is an Oracle vector table). However, when I modified the WMS map in the demo HTML (www/ol_demo.html) to point to the new added feature type, the data from that table could be loaded due to an incorrect SQL statement generated in the GeoServer:
06 Aug 16:23:50 ERROR [data.jdbc] - Error Performing SQL query: SELECT "ID", "SHAPE1" FROM "NTDB_ROADS_ON" WHERE ((TRUE
AND TRUE) AND SDO_RELATE("SHAPE1",MDSYS.SDO_GEOMETRY(2003,1002000,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORD
INATE_ARRAY(-7051005.625447684,-8299698.425649352,5128085.422724353,227395.66467489954)),'mask=anyinteract querytype=WIN
DOW') = 'TRUE' )
java.sql.SQLException: ORA-00920: invalid relational operator
The above error could be duplicated in a sqlplus command using the above SQL statement. If I remove the "(TRUE AND TRUE) AND)", it does not have any error.
It seems to me that the SQL statement generated in GeoServer has some issue regarding the Oracle Spatial support.
Please let me know what information else you want to fix this problem.
BTY, can the Oracle Spatial extension support Oracle GeoRaster table in GeoServer?
Thanks.
--
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