WFS-t and ARC_SDE

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

WFS-t and ARC_SDE

Lars Oust
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Reply | Threaded
Open this post in threaded view
|

RE: WFS-t and ARC_SDE

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

Dave

> -----Original Message-----
> From: [hidden email] [mailto:geoserver-users-
> [hidden email]] On Behalf Of Lars Oust
> Sent: Tuesday, January 03, 2006 7:43 AM
> To: [hidden email]
> 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
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users



-------------------------------------------------------
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!
<a href="http://ads.osdn.com/?ad_idv37&alloc_id865&op=click">http://ads.osdn.com/?ad_idv37&alloc_id865&op=click
_______________________________________________
Geoserver-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Reply | Threaded
Open this post in threaded view
|

Vedr. RE: WFS-t and ARC_SDE

Lars Oust
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 <[hidden email]> skrev:
What's the name of your oracle field containing geometry? "the_geom" or is
it something else like "shape" ?

Dave

> -----Original Message-----
> From: [hidden email] [mailto:geoserver-users-
> [hidden email]] On Behalf Of Lars Oust
> Sent: Tuesday, January 03, 2006 7:43 AM
> To: [hidden email]
> 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
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users


Reply | Threaded
Open this post in threaded view
|

Re: Vedr. RE: WFS-t and ARC_SDE

Chris Holmes-2
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 <[hidden email]>:

> 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 <[hidden email]> skrev:
>   What's the name of your oracle field containing geometry?
> "the_geom" or is
> it something else like "shape" ?
>
> Dave
>
> > -----Original Message-----
> > From: [hidden email]
> [mailto:geoserver-users-
> > [hidden email]] On Behalf Of Lars Oust
> > Sent: Tuesday, January 03, 2006 7:43 AM
> > To: [hidden email]
> > 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
> > [hidden email]
> > https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
>




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


-------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geoserver-users