[Geoserver-users] Geoserver ArcSDE WFS-T

GeoServer GeoServer User
1

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

<gml:Point srsName=“EPSG:4283”>
gml:coordinates143.88987121309273,-36.10663900954768</gml:coordinates>
</gml:Point>

</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

</ogc:Filter>
</wfs:Delete>
</wfs:Transaction>

<?xml version="1.0" ?>



org.geoserver.wfs.WFSException: Could not locate FeatureStore for “{http://au.spatialvision.com/}NCCMA.GISADMIN.SVPOINTTEST”


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:NameSHAPE</wfs:Name>
wfs:Value
<gml:Point srsName=“EPSG:4283”>
gml:coordinates144.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" ?>



org.geoserver.wfs.WFSException: Could not locate FeatureStore for “{http://au.spatialvision.com/}NCCMA.GISADMIN.SVPOINTTEST”


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

</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:NameSHAPE</wfs:Name>
wfs:Value
<gml:Point srsName=“EPSG:4283”>
gml:coordinates143.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

<gml:Point srsName=“EPSG:4283”>
gml:coordinates143.83011628903543,-36.3630334994521</gml:coordinates>
</gml:Point>

</sv:NCCMA.GISADMIN.SVPOINTTEST>
</wfs:Insert>
</wfs:Transaction>

<?xml version="1.0" ?>



org.xml.sax.SAXParseException: The prefix “sv” for element “sv:NCCMA.GISADMIN.SVPOINTTEST” is not bound.

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

----- Original Message ----
From: Gabriel Roldán <groldan@anonymised.com.1671…>
To: geoserver-users@lists.sourceforge.net
Cc: Yi Lik Tsang Yi-Lik.Tsang@anonymised.com
Sent: Thursday, 4 September, 2008 10:22:38 AM
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.

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-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Win a MacBook Air or iPod touch with Yahoo!7- Find out more.