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]
<mailto:[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 <http://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
<http://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]>
<mailto:[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]>>
<mailto:[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] <mailto:[email protected]>
http://lists.osgeo.org/mailman/listinfo/openlayers-users
