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
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
