[Geoserver-users] WFS-t and ARC_SDE

Lars_Oust · January 3, 2006, 2:42pm

Hi.

I'm a new Geoserver user and I try to use WFS-T to
insert a point into a feature class into my Oracle
datadase using ArcSDE.

I've created a WFS-Transactional.xml like this:

  <wfs:Transaction
xmlns:wfs="http://www.opengis.net/wfs">
  <wfs:Insert>
  <topp:SDE_TEST.TESTPUNKTER
xmlns:topp="http://www.openplans.org/topp">
      <topp:the_geom>
        <gml:MultiPoint
xmlns:gml="http://www.opengis.net/gml"
srsName="epsg:4326">
          <gml:pointMember>
            <gml:Point>
              <gml:coordinates decimal="." cs="," ts="
">149.344775,-41.744855</gml:coordinates>
            </gml:Point>
          </gml:pointMember>
        </gml:MultiPoint>
      </topp:the_geom>
       <topp:OBJECTID>11</topp:OBJECTID>
      <topp:CITY_NAME/>
      <topp:ADMIN_NAME>Takk</topp:ADMIN_NAME>
      <topp:CNTRY_NAME>tusen</topp:CNTRY_NAME>
      <topp:STATUS>Bare bull</topp:STATUS>
      <topp:POP_CLASS/>

</topp:SDE_TEST.TESTPUNKTER></wfs:Insert></wfs:Transaction>

But when I try to use the Demo Request at
http://lokalhost:8080/geoserver/demoRequestSubmit.do
I end up with the following message:

org.xml.sax.SAXException: Could not find attributeType
named the_geomin featureType DefaultFeatureType
[name=SDE_TEST.TESTPUNKTER ,
namespace=http://www.opengis.net/gml , abstract=false
, types=(DefaultAttributeType [name=OBJECTID ,
type=class java.lang.Integer , nillable=true, min=1,
max=1],DefaultAttributeType [name=CITY_NAME ,
type=class java.lang.String , nillable=true, min=1,
max=1],DefaultAttributeType [name=ADMIN_NAME ,
type=class java.lang.String , nillable=true, min=1,
max=1],DefaultAttributeType [name=CNTRY_NAME ,
type=class java.lang.String , nillable=true, min=1,
max=1],DefaultAttributeType [name=STATUS , type=class
java.lang.String , nillable=true, min=1,
max=1],DefaultAttributeType [name=POP_CLASS ,
type=class java.lang.String , nillable=true, min=1,
max=1],DefaultAttributeType [name=SHAPE , type=class
com.vividsolutions.jts.geom.MultiPoint ,
nillable=true, min=1, max=1],)]

What is wrong??
Anyone got a hint for me??

-Lars

David_Neufeld · January 3, 2006, 4:40pm

What's the name of your oracle field containing geometry? "the_geom" or is
it something else like "shape" ?

Dave

-----Original Message-----
From: geoserver-users-admin@lists.sourceforge.net [mailto:geoserver-users-
admin@lists.sourceforge.net] On Behalf Of Lars Oust
Sent: Tuesday, January 03, 2006 7:43 AM
To: geoserver-users@lists.sourceforge.net
Subject: [Geoserver-users] WFS-t and ARC_SDE

Hi.

I'm a new Geoserver user and I try to use WFS-T to
insert a point into a feature class into my Oracle
datadase using ArcSDE.

I've created a WFS-Transactional.xml like this:

  <wfs:Transaction
xmlns:wfs="http://www.opengis.net/wfs">
  <wfs:Insert>
  <topp:SDE_TEST.TESTPUNKTER
xmlns:topp="http://www.openplans.org/topp">
      <topp:the_geom>
        <gml:MultiPoint
xmlns:gml="http://www.opengis.net/gml"
srsName="epsg:4326">
          <gml:pointMember>
            <gml:Point>
              <gml:coordinates decimal="." cs="," ts="
">149.344775,-41.744855</gml:coordinates>
            </gml:Point>
          </gml:pointMember>
        </gml:MultiPoint>
      </topp:the_geom>
       <topp:OBJECTID>11</topp:OBJECTID>
      <topp:CITY_NAME/>
      <topp:ADMIN_NAME>Takk</topp:ADMIN_NAME>
      <topp:CNTRY_NAME>tusen</topp:CNTRY_NAME>
      <topp:STATUS>Bare bull</topp:STATUS>
      <topp:POP_CLASS/>

</topp:SDE_TEST.TESTPUNKTER></wfs:Insert></wfs:Transaction>

But when I try to use the Demo Request at
http://lokalhost:8080/geoserver/demoRequestSubmit.do
I end up with the following message:

org.xml.sax.SAXException: Could not find attributeType
named the_geomin featureType DefaultFeatureType
[name=SDE_TEST.TESTPUNKTER ,
namespace=http://www.opengis.net/gml , abstract=false
, types=(DefaultAttributeType [name=OBJECTID ,
type=class java.lang.Integer , nillable=true, min=1,
max=1],DefaultAttributeType [name=CITY_NAME ,
type=class java.lang.String , nillable=true, min=1,
max=1],DefaultAttributeType [name=ADMIN_NAME ,
type=class java.lang.String , nillable=true, min=1,
max=1],DefaultAttributeType [name=CNTRY_NAME ,
type=class java.lang.String , nillable=true, min=1,
max=1],DefaultAttributeType [name=STATUS , type=class
java.lang.String , nillable=true, min=1,
max=1],DefaultAttributeType [name=POP_CLASS ,
type=class java.lang.String , nillable=true, min=1,
max=1],DefaultAttributeType [name=SHAPE , type=class
com.vividsolutions.jts.geom.MultiPoint ,
nillable=true, min=1, max=1],)]

What is wrong??
Anyone got a hint for me??

-Lars

-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log
files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Lars_Oust · January 4, 2006, 6:12pm

My Oravel SDE feature class si created from the example shapefile, tasmania_cities.shp, following the Geoserver 1.3 installation.
My Oracle fiels containing geometry is named “SHAPE”. I could name it different, like GEO??.
The Shapfile has a column named FID. In Oracle and SDE this same column is named OBJECTID??

-Lars

David Neufeld david.neufeld@anonymised.com skrev:

What’s the name of your oracle field containing geometry? “the_geom” or is
it something else like “shape” ?

Dave

-----Original Message-----
From: geoserver-users-admin@lists.sourceforge.net [mailto:geoserver-users-
admin@lists.sourceforge.net] On Behalf Of Lars Oust
Sent: Tuesday, January 03, 2006 7:43 AM
To: geoserver-users@lists.sourceforge.net
Subject: [Geoserver-users] WFS-t and ARC_SDE

Hi.

I’m a new Geoserver user and I try to use WFS-T to
insert a point into a feature class into my Oracle
datadase using ArcSDE.

I’ve created a WFS-Transactional.xml like this:

But when I try to use the Demo Request at
http://lokalhost:8080/geoserver/demoRequestSubmit.do
I end up with the following message:

org.xml.sax.SAXException: Could not find attributeType
named the_geomin featureType DefaultFeatureType
[name=SDE_TEST.TESTPUNKTER ,
namespace=http://www.opengis.net/gml , abstract=false
, types=(DefaultAttributeType [name=OBJECTID ,
type=class java.lang.Integer , nillable=true, min=1,
max=1],DefaultAttributeType [name=CITY_NAME ,
type=class java.lang.String , nillable=true, min=1,
max=1],DefaultAttributeType [name=ADMIN_NAME ,
type=class java.lang.String , nillable=true, min=1,
max=1],DefaultAttributeType [name=CNTRY_NAME ,
type=class java.lang.String , nillable=true, min=1,
max=1],DefaultAttributeType [name=STATUS , type=class
java.lang.String , nillable=true, min=1,
max=1],DefaultAttributeType [name=POP_CLASS ,
type=class java.lang.String , nillable=true, min=1,
max=1],DefaultAttributeType [name=SHAPE , type=class
com.vividsolutions.jts.geom.MultiPoint ,
nillable=true, min=1, max=1],)]

What is wrong??
Anyone got a hint for me??

-Lars

This SF.net email is sponsored by: Splunk Inc. Do you grep through log
files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Chris_Holmes1 · January 4, 2006, 6:49pm

What David is getting at is that in your insert request, you called the
geometry 'the_geom'. This is how the examples are, but the reason is
because that's what the featureType's geometry is called. Since your
geometry is called shape, on your insert request it needs to look like:

      <topp:SHAPE>
        <gml:MultiPoint
xmlns:gml="http://www.opengis.net/gml"
srsName="epsg:4326">
          <gml:pointMember>
            <gml:Point>
              <gml:coordinates decimal="." cs="," ts="
">149.344775,-41.744855</gml:coordinates>
            </gml:Point>
          </gml:pointMember>
        </gml:MultiPoint>
      </topp:SHAPE>

It should also go last, as that's what the error is telling you, the
order of the attributes and what they should be called. SHAPE is the
geometry one, and comes after POP_CLASS.

best regards,

Chris

Quoting Lars Oust <laonijos@anonymised.com>:

My Oravel SDE feature class si created from the example shapefile,
tasmania_cities.shp, following the Geoserver 1.3 installation.
  My Oracle fiels containing geometry is named "SHAPE". I could name
it different, like GEO??.
  The Shapfile has a column named FID. In Oracle and SDE this same
column is named OBJECTID??

  -Lars

David Neufeld <david.neufeld@anonymised.com> skrev:
  What's the name of your oracle field containing geometry?
"the_geom" or is
it something else like "shape" ?

Dave

> -----Original Message-----
> From: geoserver-users-admin@lists.sourceforge.net
[mailto:geoserver-users-
> admin@lists.sourceforge.net] On Behalf Of Lars Oust
> Sent: Tuesday, January 03, 2006 7:43 AM
> To: geoserver-users@lists.sourceforge.net
> Subject: [Geoserver-users] WFS-t and ARC_SDE
>
> Hi.
>
> I'm a new Geoserver user and I try to use WFS-T to
> insert a point into a feature class into my Oracle
> datadase using ArcSDE.
>
> I've created a WFS-Transactional.xml like this:
>
> > xmlns:wfs="http://www.opengis.net/wfs">
>
> > xmlns:topp="http://www.openplans.org/topp">
>
> > xmlns:gml="http://www.opengis.net/gml"
> srsName="epsg:4326">
>
>
> > " cs="," decimal=".">149.344775,-41.744855
>
>
>
>
> 11
>
> Takk
> tusen
> Bare bull
>
>
>
>
> But when I try to use the Demo Request at
> http://lokalhost:8080/geoserver/demoRequestSubmit.do
> I end up with the following message:
>
> org.xml.sax.SAXException: Could not find attributeType
> named the_geomin featureType DefaultFeatureType
> [name=SDE_TEST.TESTPUNKTER ,
> namespace=http://www.opengis.net/gml , abstract=false
> , types=(DefaultAttributeType [name=OBJECTID ,
> type=class java.lang.Integer , nillable=true, min=1,
> max=1],DefaultAttributeType [name=CITY_NAME ,
> type=class java.lang.String , nillable=true, min=1,
> max=1],DefaultAttributeType [name=ADMIN_NAME ,
> type=class java.lang.String , nillable=true, min=1,
> max=1],DefaultAttributeType [name=CNTRY_NAME ,
> type=class java.lang.String , nillable=true, min=1,
> max=1],DefaultAttributeType [name=STATUS , type=class
> java.lang.String , nillable=true, min=1,
> max=1],DefaultAttributeType [name=POP_CLASS ,
> type=class java.lang.String , nillable=true, min=1,
> max=1],DefaultAttributeType [name=SHAPE , type=class
> com.vividsolutions.jts.geom.MultiPoint ,
> nillable=true, min=1, max=1],)]
>
> What is wrong??
> Anyone got a hint for me??
>
> -Lars
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through
log
> files
> for problems? Stop! Download the new AJAX search engine that makes
> searching your log files as easy as surfing the web. DOWNLOAD
SPLUNK!
> http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users

----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/