Hey Dan, It sounds like the table in Oracle that contains your spatial column (SDO_GEOMETRY) does not have a spatial index ... if that is the case then you need to something like:
CREATE INDEX <YOUR INDEX NAME> ON <YOUR SPATIAL TABLE>(<YOUR SPATIAL COLUMN>) INDEXTYPE IS MDSYS.SPATIAL_INDEX; However, if you already have a spatial index then there are also metadata tables in MDSYS that sometimes require entries to get everything 'happy' (ie USER_SDO_GEOM_METADATA or ALL_SDO_GEOM_METADATA). Hope this helps! Wally Atkins REF: http://edndoc.esri.com/arcsde/9.0/capi_concepts/oracle_spatial_geomtypes.htm On Wed, Jan 26, 2011 at 5:11 AM, Daniel Behr <[email protected]> wrote: > Hi again, > I'm still having the same problem to get my WFS Layer displayed. As my > skills for Firebug are a bit limited I am stuck with its results: > > With a working OL proxy script, I get this error in firebug: > > '502 Bad Gateway > This proxy does not allow you to access that location' > (...following the whole server settings) > > Without proxy.cgi I get this error in firebug: > > <ServiceException> > error:Translator error > Translator error > Error reading Features > Could not aquire feature:org.geotools.data.DataSourceException: Error > Performing SQL query: SELECT "ID", "TITLE", > "TYPE", "ANFANG", "ANFANGISO", > "ENDE", "ENDEISO", "PARAMETER", > "GEOM" FROM "WFSPLATFORM_P" WHERE > SDO_RELATE("GEOM",MDSYS.SDO_GEOMETRY(2003,4326,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-146.07421875,34.90234375,146.07421875,45.09765625)),'mask=anyinteract > querytype=WINDOW') = 'TRUE' > Error Performing SQL query: SELECT "ID", "TITLE", > "TYPE", "ANFANG", "ANFANGISO", > "ENDE", "ENDEISO", "PARAMETER", > "GEOM" FROM "WFSPLATFORM_P" WHERE > SDO_RELATE("GEOM",MDSYS.SDO_GEOMETRY(2003,4326,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-146.07421875,34.90234375,146.07421875,45.09765625)),'mask=anyinteract > querytype=WINDOW') = 'TRUE' > ORA-13226: Oberfl?che ohne Spatial-Index nicht unterst?tzt > ORA-06512: in "MDSYS.MD", Zeile 1723 > ORA-06512: in "MDSYS.MDERR", Zeile 8 > ORA-06512: in "MDSYS.SDO_3GL", Zeile 71 > </ServiceException></ServiceExceptionReport> > > > > Theres a spatial Index required? > There is another service requesting exactly the same featureNS, featureType > and url for a WFS, but with a more complex code and without proxy! > I've been through the code, but I cant make out where the crucial > difference is. Can it be that it is simply impossible to reproduce this > layer with a simple WFS call (see below) and that there MUST be something > else happening in server and client communication? > > Or am I getting something wrong with the url's included in the proxy > script? Firebug shows that this url is used, even if the proxy doesnt point > to it: > > POST > http://server.de/cgi-bin/proxy.cgi?url=http%3A%2F%2Fserver.de%2Fgeoserver%2Fwfs > > No matter if I inlude this or any other url, the one above is the only one > thats used. > > Just for clarification: my geoserver is on port 8090 so the url to include > in the script should be 'server.de:8090' right? > anyway, I tried evey possible combination but Firebug always shows the > above url and that 'This proxy does not allow you to access that > location'... > > any idea what causes this? > Dan > > > > > Am 21.01.2011 15:32, schrieb Wally Atkins: > >> I would suggest using FireFox along with FireBug, if you haven't >> already, and tracing the network calls that occurs between your browser >> and GeoServer. >> >> As you mentioned, everything appears to be happy between Oracle and >> GeoServer when delivering WMS to the browser but something becomes >> 'unhappy' when attempting to deliver WFS. Hopefully something in the >> network traffic will point you in the right direction. >> >> Wally >> >> On Fri, Jan 21, 2011 at 5:41 AM, Daniel Behr <[email protected] >> <mailto:[email protected]>> wrote: >> >> thanks Wally, but GeoServer is running on the same machine, if I got >> this right, there is no need for a proxy then. >> >> Any other ideas why my vectorlayer does not display? >> >> thanks in advance >> Dan >> >> >> Am 20.01.2011 16:56, schrieb Wally Atkins: >> >> proxy: >> >> http://trac.osgeo.org/openlayers/wiki/FrequentlyAskedQuestions#ProxyHost >> >> On Thu, Jan 20, 2011 at 10:14 AM, Daniel Behr >> <[email protected] <mailto:[email protected]> >> <mailto:[email protected] <mailto:[email protected]>>> wrote: >> >> Hello List, >> I'm trying to get a Layer.Vector into OpenLayers 2.10 but it >> wont work. >> >> The Data comes from Oracle > Geoserver 1.7.6 and if I call it >> as >> Layer.WMS [1] it works as expected. >> >> no matter what changes i make to the Layer.Vector call [2], the >> layer never shows up in the map. (not even in the wrong >> place, but >> reprojecting is not an issue...) >> >> I thought the code from OL example at: >> >> http://openlayers.org/dev/examples/wfs-protocol.html >> >> would do it, but no. >> I also tried to add a format like this >> >> format: new OpenLayers.Format.WFS >> >> but I get an error in firebug that the this.layer is not >> defined. >> >> Anyone has a clue what I am missing here? I guess its something >> about events or features, but I really dont understand why >> the OL >> example works then... >> >> thanks >> Dan >> >> [1] >> pLayer = new OpenLayers.Layer.WMS( >> "Platforms", "http://myserver/geoserver/wms";, { >> layers: 'pform:PLATFORM', >> styles: 'polygon', >> srs: 'EPSG:900913', >> format: 'image/png', >> transparent: 'true' >> }, >> {singleTile: true} >> ); >> >> [2] >> pLayer = new OpenLayers.Layer.Vector("Platforms", { >> strategies: [new OpenLayers.Strategy.BBOX()], >> protocol: new OpenLayers.Protocol.WFS({ >> url: "http://myserver/geoserver/wfs";, >> featureType: "PLATFORM", >> featureNS: >> "http://myserver/namespace/gml/pform";, >> geometryName: 'GEOM' >> }) >> }); >> > _______________________________________________ > Users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/openlayers-users >
_______________________________________________ Users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/openlayers-users
