WMS query fails with ORA-13208 and ORA-06512 exceptions
-------------------------------------------------------
Key: GEOS-3594
URL: http://jira.codehaus.org/browse/GEOS-3594
Project: GeoServer
Issue Type: Bug
Components: Oracle, WMS
Affects Versions: 2.0-RC2
Environment: Windows XP, Oracle 11g, Oracle NG drivers for GeoServer.
Reporter: Pavel Golodoniuc
Assignee: Andrea Aime
Attachments: ER_TEST.sql, Exception.txt, GSML_MAPPEDFEATURE_SIMPLE.sql
In an Oracle database I have created two views from attached
GSML_MAPPEDFEATURE_SIMPLE.sql and ER_TEST.sql and added corresponding records
into USER_SDO_GEOM_METADATA:
SELECT * FROM USER_SDO_GEOM_METADATA;
TABLE_NAME COLUMN_NAME DIMINFO
SRID
-------------------------- ---------------------
--------------------------------------------------------------------------------------------------------------------------
----
ER_TEST LOCATION
MDSYS.SDO_DIM_ELEMENT(MDSYS.SDO_DIM_ELEMENT(longitude,-180,180,0.000001),MDSYS.SDO_DIM_ELEMENT(latitude,-90,90,0.000001))
8311
GSML_MAPPEDFEATURE_SIMPLE LOCATION
MDSYS.SDO_DIM_ELEMENT(MDSYS.SDO_DIM_ELEMENT(longitude,-180,180,0.000001),MDSYS.SDO_DIM_ELEMENT(latitude,-90,90,0.000001))
8311
In fact, ER_TEST view is a simplified version of the GSML_MAPPEDFEATURE_SIMPLE
and exposes just two fields (ID and SDO_GEOMETRY). In both cases the data is
coming from the same table, the same filter conditions and joins are applied.
Then I have successfully created two layers in GeoServer with absolutely the
same settings. Simple GetFeature WFS requests like
http://localhost:9090/geoserver/wfs?request=GetFeature&typeName=pirsa:ER_TEST&maxFeatures=10
work perfectly in both cases. But for some reason the WMS is only producing
correct output for GSML_MAPPEDFEATURE_SIMPLE feature type. When attempting to
query WMS for ER_TEST
(http://localhost:9090/geoserver/wms?service=WMS&version=1.1.0&request=GetMap&layers=pirsa:ER_TEST&styles=&bbox=129.102,-38.058,141.0,-26.003&width=505&height=512&srs=EPSG:4283&format=image/png)
GeoServer generates an error (see Exception.txt).
What is so different in these two so similar views that causes this unexpected
behaviour?
--
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
------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
