[Geoserver-users] Geoserver ArcSDE WFS-T

GeoServer GeoServer User
1

Hi Aleda,

I am using the exact setup that you are using, however I am still having trouble getting all Update, Insert & Delete to work together. I can either get Update and Delete to work, or just Insert, but not all three at the same time. I have posted the error trace of the problem in another reply under the same subject: Re: [Geoserver-users] Geoserver ArcSDE WFS-T.

Would you be able to give me an example of how you set up your namespace, datastore, and featureType in GeoServer?

This is my setting:
Namespace:

Datastore:

  • Name: sv
  • Enabled: checked
  • Namespace: sv
  • Server: server_name
  • Port: port_no
  • Instance:
  • user: user_name
  • password: password
  • pool.minConnections: 2
  • pool.maxConnections: 6
  • pool.timeOut: 500

FeatureType:

  • see attached jpg.

Thanks for your help.

----- Original Message ----
From: aleda_freeman Aleda.Freeman@anonymised.com
To: geoserver-users@lists.sourceforge.net
Sent: Thursday, 4 September, 2008 11:20:47 PM
Subject: Re: [Geoserver-users] Geoserver ArcSDE WFS-T

Yi,
Just to chime in, here in Massachusetts we are currently running WFS-T with
SDE 9.2 SP5 and GeoServer 1.6.5. Before that we were using SDE 9.1 SP 1 and
GeoServer 1.3. So it can be done!

View this message in context: http://www.nabble.com/Geoserver-ArcSDE-WFS-T-tp19297795p19309002.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

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

Make the switch to the world’s best email. Get Yahoo!7 Mail.

featureTypes.JPG

2

Here's some information from our catalog.xml file (I've changed the password
not that it matters)

<namespace uri = "http://massgis.state.ma.us/featuretype&quot; prefix = "massgis"
default = "true" />

    <datastore namespace = "massgis" enabled = "true" id = "massgis_sde" >
      <connectionParams >
        <parameter value = "password" name = "password" />
        <parameter value = "massgis" name = "namespace" />
        <parameter value = "10" name = "pool.minConnections" />
        <parameter value = "massgis" name = "user" />
        <parameter value = "gis" name = "instance" />
        <parameter value = "30" name = "pool.maxConnections" />
        <parameter value = "10000" name = "pool.timeOut" />
        <parameter value = "alexandria.massgis.state.ma.us" name = "server"
/>
        <parameter value = "5151" name = "port" />
        <parameter value = "1" name = "pool.increment" />
        <parameter value = "arcsde" name = "dbtype" />
      </connectionParams>
    </datastore>

sample layername: massgis:GISDATA.EJ_POLY

(GISDATA is an Oracle schema name, EJ_POLY is the layer name)

What the first part of a transaction request looks like for us:

<wfs:Transaction xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot;
xmlns:gml="http://www.opengis.net/gml&quot;
xmlns:wfs="http://www.opengis.net/wfs&quot; version="1.0.0" service="WFS"
xmlns:massgis="http://massgis.state.ma.us/featuretype&quot;&gt;
--
View this message in context: http://www.nabble.com/Geoserver-ArcSDE-WFS-T-tp19297795p19422759.html
Sent from the GeoServer - User mailing list archive at Nabble.com.