The query of an Oracle Spatial vector table in GeoServer always fails due to incorrect SQL statement generated in the GeoServer.
Description
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 - 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.
Environment
None
Activity
codehaus
April 10, 2015 at 4:14 PM
CodeHaus Comment From: aaime - Time: Tue, 19 Aug 2008 04:58:41 -0500 ---------------------
<p>No, there is no support for Oracle GeoRaster in GeoServer. To get some, we either need a donation of code from someone able to develop it (either directly, or by sponsoring some commercial support developer to create it).</p>
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 - 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.