Hi Gabriel + all,
Thanks for the relpy.
I have done a bit more testing in the last few days, and using GeoServer
1.6.5 beta, I have managed to get either update and delete, or just
insert to work, but not both.
In GeoServer, I created a namespace with URI:
http://au.spatialvision.com, and prefix: sv. Using
xmlns:sv="http://au.spatialvision.com/", I would get an error doing
update or delete, but works fine with insert.
WFS-T Insert (Success):
<?xml version="1.0" encoding="UTF-8"?>
<wfs:Transaction
service="WFS"
version="1.0.0"
handle="IMFinsert"
xmlns:sv="http://au.spatialvision.com/"
xmlns:wfs="http://www.opengis.net/wfs"
xmlns:ogc="http://www.opengis.net/ogc"
xmlns:gml="http://www.opengis.net/gml">
<wfs:Insert>
<sv:NCCMA.GISADMIN.SVPOINTTEST>
<SHAPE>
<gml:Point srsName="EPSG:4283">
<gml:coordinates>143.88987121309273,-36.10663900954768</gml:coordinates>
</gml:Point>
</SHAPE>
</sv:NCCMA.GISADMIN.SVPOINTTEST>
</wfs:Insert>
</wfs:Transaction>
WFS-T Delete (fail):
<?xml version="1.0" encoding="UTF-8"?>
<wfs:Transaction
service="WFS"
version="1.0.0"
handle="IMFdelete"
xmlns:sv="http://au.spatialvision.com/"
xmlns:wfs="http://www.opengis.net/wfs"
xmlns:ogc="http://www.opengis.net/ogc"
xmlns:gml="http://www.opengis.net/gml">
<wfs:Delete typeName="sv:NCCMA.GISADMIN.SVPOINTTEST">
<ogc:Filter>
<FeatureId fid="NCCMA.GISADMIN.SVPOINTTEST.41"/>
</ogc:Filter>
</wfs:Delete>
</wfs:Transaction>
<?xml version="1.0" ?>
<ServiceExceptionReport
version="1.2.0"
xmlns="http://www.opengis.net/ogc"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.opengis.net/ogc
http://schemas.opengis.net/wfs/1.0.0/OGC-exception.xsd">
<ServiceException>
org.geoserver.wfs.WFSException: Could not locate FeatureStore
for "{http://au.spatialvision.com/\}NCCMA.GISADMIN.SVPOINTTEST"
</ServiceException>
</ServiceExceptionReport>
at
org.geoserver.wfs.UpdateElementHandler.execute(UpdateElementHandler.java
:130)
WFS-T Update (fail)
<?xml version="1.0" encoding="UTF-8"?>
<wfs:Transaction
service="WFS"
version="1.0.0"
handle="IMFupdate"
xmlns:sv="http://au.spatialvision.com/"
xmlns:wfs="http://www.opengis.net/wfs"
xmlns:ogc="http://www.opengis.net/ogc"
xmlns:gml="http://www.opengis.net/gml">
<wfs:Update typeName="sv:NCCMA.GISADMIN.SVPOINTTEST">
<wfs:Property>
<wfs:Name>SHAPE</wfs:Name>
<wfs:Value>
<gml:Point srsName="EPSG:4283">
<gml:coordinates>144.48483089829804,-36.12842743111402</gml:coordinates>
</gml:Point>
</wfs:Value>
</wfs:Property>
<ogc:Filter>
<ogc:FeatureId fid="NCCMA.GISADMIN.SVPOINTTEST.1688"/>
</ogc:Filter>
</wfs:Update>
</wfs:Transaction>
<?xml version="1.0" ?>
<ServiceExceptionReport
version="1.2.0"
xmlns="http://www.opengis.net/ogc"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.opengis.net/ogc
http://schemas.opengis.net/wfs/1.0.0/OGC-exception.xsd">
<ServiceException>
org.geoserver.wfs.WFSException: Could not locate FeatureStore
for "{http://au.spatialvision.com/\}NCCMA.GISADMIN.SVPOINTTEST"
</ServiceException>
</ServiceExceptionReport>
at
org.geoserver.wfs.UpdateElementHandler.execute(UpdateElementHandler.java
:130)
However, if the xmlns in the WFS-T Transcational XML is changed from
xmlns:sv="http://au.spatialvision.com/" to
xmlns:sde="http://au.spatialvision.com/"\. That is, absolutely nothing
is changed in GeoServer, and the FeatureType in GeoServer is still
sv:NCCMA.GISADMIN.SVPOINTTEST. I would be able to do update or delete,
but not insert.
WFS-T Delete (Success):
<?xml version="1.0" encoding="UTF-8"?>
<wfs:Transaction
service="WFS"
version="1.0.0"
handle="IMFdelete"
xmlns:sde="http://au.spatialvision.com/"
xmlns:wfs="http://www.opengis.net/wfs"
xmlns:ogc="http://www.opengis.net/ogc"
xmlns:gml="http://www.opengis.net/gml">
<wfs:Delete typeName="sv:NCCMA.GISADMIN.SVPOINTTEST">
<ogc:Filter>
<FeatureId fid="NCCMA.GISADMIN.SVPOINTTEST.57"/>
</ogc:Filter>
</wfs:Delete>
</wfs:Transaction>
WFS-T Update (Success):
<?xml version="1.0" encoding="UTF-8"?>
<wfs:Transaction
service="WFS"
version="1.0.0"
handle="IMFupdate"
xmlns:sde="http://au.spatialvision.com/"
xmlns:wfs="http://www.opengis.net/wfs"
xmlns:ogc="http://www.opengis.net/ogc"
xmlns:gml="http://www.opengis.net/gml">
<wfs:Update typeName="sv:NCCMA.GISADMIN.SVPOINTTEST">
<wfs:Property>
<wfs:Name>SHAPE</wfs:Name>
<wfs:Value>
<gml:Point srsName="EPSG:4283">
<gml:coordinates>143.70662636644562,-35.78084618396142</gml:coordinates>
</gml:Point>
</wfs:Value>
</wfs:Property>
<ogc:Filter>
<ogc:FeatureId fid="NCCMA.GISADMIN.SVPOINTTEST.41"/>
</ogc:Filter>
</wfs:Update>
</wfs:Transaction>
WFS-T Insert (Fail):
<?xml version="1.0" encoding="UTF-8"?>
<wfs:Transaction
service="WFS"
version="1.0.0"
handle="IMFinsert"
xmlns:sde="http://au.spatialvision.com/"
xmlns:wfs="http://www.opengis.net/wfs"
xmlns:ogc="http://www.opengis.net/ogc"
xmlns:gml="http://www.opengis.net/gml">
<wfs:Insert>
<sv:NCCMA.GISADMIN.SVPOINTTEST>
<SHAPE>
<gml:Point srsName="EPSG:4283">
<gml:coordinates>143.83011628903543,-36.3630334994521</gml:coordinates>
</gml:Point>
</SHAPE>
</sv:NCCMA.GISADMIN.SVPOINTTEST>
</wfs:Insert>
</wfs:Transaction>
<?xml version="1.0" ?>
<ServiceExceptionReport
version="1.2.0"
xmlns="http://www.opengis.net/ogc"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.opengis.net/ogc
http://schemas.opengis.net/wfs/1.0.0/OGC-exception.xsd">
<ServiceException>
org.xml.sax.SAXParseException: The prefix "sv" for element
"sv:NCCMA.GISADMIN.SVPOINTTEST" is not bound.
</ServiceException>
</ServiceExceptionReport>
Has anybody experience simlier problem?? And sicne some user has been
able to get WFS-T to work, I really would like to know the setup they
are using.
Any kind of help is appericated.
Thanks.
Yi Lik
________________________________________________
Yi Lik Tsang
GIS Developer
SPATIAL VISION
Level 2, 170 Queen Street, Melbourne, VIC, 3000
Phone: +61 3 9691 3013
Fax: +61 3 9691 3001
E-mail: yilik.tsang@anonymised.com
-----Original Message-----
From: Gabriel Roldán [mailto:groldan@anonymised.com]
Sent: Thursday, 4 September 2008 10:23 AM
To: geoserver-users@lists.sourceforge.net
Cc: Yi Lik Tsang
Subject: Re: [Geoserver-users] Geoserver ArcSDE WFS-T
Hi Yi,
On Wednesday 03 September 2008 05:38:29 am Yi Lik Tsang wrote:
Has anybody been able to get GeoServer to work with ArcSDE 9.2 using
WFS-T.
yes? at least I know of a couple corporate users that are happy with it
or
when they wasn't they invested some resources into improving the
GeoServer
ArcSDE extension.
I am running ArcSDE 9.2 sp5, and I need to use WFS-T for update,
insert & delete.
I have tried basically all version of GeoServer. I've managed to get
version 1.5.4 to update & delete, but not insert.
And for all the other version, I've either have porblem connecting to
SDE, or having porblem with loading a new featureType, problems other
people seem to have experienced as well.
well, this is an open source project, so you either:
- provide a patch with proper unit tests and the module maintainers will
be
glad to review it and apply it for you if the patch it good enough
- get a contract with one of the many organizations that support
geoserver to
fix it for you
- or kindly ask the community to look over the problems you're
experiencing
and hope them fix it for you for free. But for that to happen you need
to
provide more information that the developers can use to assess your
problem.
A simple statement of frustration gives us anything to work on. You can
usually send a stack trace report, describe better your problem and the
steps
to reproduce, describe the structure of the tables you're trying to
access
and are failing, or even provide a sample dataset that happens to fail.
Also, if the instructions at
http://docs.codehaus.org/display/GEOTDOC/ArcSDE+DataStore are not good
or out
of date, once you solve your problem you could contribute some
documentation
clean up in order to avoid others the pain you're suffering.
best regards,
Gabriel
I really would like to know how to get GeoServer to work with ArcSDE
with WFS-T.
And I really would like to help you. If the instructions on
Thanks.
________________________________________________
Yi Lik Tsang
GIS Developer
SPATIAL VISION
Level 2, 170 Queen Street, Melbourne, VIC, 3000
Phone: +61 3 9691 3013
Fax: +61 3 9691 3001
E-mail: yilik.tsang@anonymised.com
For our latest news visit http://www.spatialvision.com.au This e-mail
is privileged and confidential and intended only for the addressee(s).
If received in error advise Spatial Vision by return e-mail and then
please delete. Please consider the environment before printing this
email.
For our latest news visit http://www.spatialvision.com.au
This e-mail is privileged and confidential and intended only for the addressee(s). If received in error advise Spatial Vision by return e-mail and then please delete.
Please consider the environment before printing this email.
