[Geoserver-users] WFS-T success?

GeoServer GeoServer User
1

Hello,

Using the default installation of GeoServer 1.6.2 and the sample data:
I am sending TransactionRequests to the server, and the
TransactionResult (contained in TransactionResponse) has a status of
SUCCESS. However, it appears that nothing is changed on the server.
How do I diagnose what is going wrong if the server returns SUCCESS?

Also, the TransactionResponse always contain an InsertResult element;
for an Update or Delete, the fid = "none". Why is this?

Thanks for any insight...

2

Hi CB,

You can think of transactions as queries against the database, similar to a
SQL "UPDATE blah WHERE ..." command. That is, when you make a transaction
request, you are supplying a filter and modifying all the features that are
matched. If nothing matches that filter, then you successfully modify 0
features.

Short version: there's probably a typo in a literal or something in your
filter, look that over.

Hope this helps,
David Winslow

On Saturday 29 March 2008 11:25:37 CB wrote:

Hello,

Using the default installation of GeoServer 1.6.2 and the sample data:
I am sending TransactionRequests to the server, and the
TransactionResult (contained in TransactionResponse) has a status of
SUCCESS. However, it appears that nothing is changed on the server.
How do I diagnose what is going wrong if the server returns SUCCESS?

Also, the TransactionResponse always contain an InsertResult element;
for an Update or Delete, the fid = "none". Why is this?

Thanks for any insight...

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplac
e _______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4040,47ee5f7c39501439371379!

3

Using the default installation of GeoServer 1.6.2 and the sample data:
I am sending TransactionRequests to the server, and the
TransactionResult (contained in TransactionResponse) has a status of
SUCCESS. However, it appears that nothing is changed on the server.
How do I diagnose what is going wrong if the server returns SUCCESS?

Are you using a maxFeature limit?
If so, you could not see a new feature if it's id is > of the max

4

Let's keep this on the mailing list, all of us are smarter than just me :slight_smile:

I don't see anything wrong with this request; does a feature with
fid=tiger_roads.8431 actually exist?

-David Winslow

On Monday 31 March 2008 10:08:18 CB wrote:

Thanks for the quick reply.
Is there anything to be learned from the GeoServer console? If I send
a simple Delete request, I see this on the console:
Request: transaction
        handle = null
        service = WFS
        version = 1.0.0
        baseUrl = http://69.54.29.26:8080/geoserver/
        lockId = null
        group =
[net.opengis.wfs:delete=net.opengis.wfs.impl.DeleteElementTypeIm pl@anonymised.com
(filter: [ tiger_roads.8341 ], handle: null, typeName: {http://www.cen
sus.gov}tiger_roads)]
        insert =
        update =
        delete = [net.opengis.wfs.impl.DeleteElementTypeImpl@anonymised.com
(filter: [ t iger_roads.8341 ], handle: null, typeName:
{http://www.census.gov}tiger_roads)] native =
        releaseAction = ALL

The TransactionRequest:
<?xml version="1.0" ?>
<wfs:Transaction
version="1.0.0"
service="WFS"
xmlns:wfs="http://www.opengis.net/wfs&quot;
xmlns:sde="http://geoserver.sf.net"
xmlns:tiger="http://www.census.gov"
xmlns:it.geosolutions="http://www.geo-solutions.it"
xmlns:nurc="http://www.nurc.nato.int"
xmlns:cite="http://www.opengeospatial.net/cite&quot;
xmlns:gml="http://www.opengis.net/gml&quot;
xmlns:ogc="http://www.opengis.net/ogc&quot;
xmlns="http://www.opengis.net/wfs&quot;
xsi:schemaLocation="http://www.opengis.net/wfs ../wfs/1.0.0/WFS-basic.xsd"
xmlns:sf="http://www.openplans.org/spearfish&quot;
xmlns:topp="http://www.openplans.org/topp&quot;
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot;&gt;
    <wfs:Delete typeName="tiger:tiger_roads">
        <ogc:Filter>
            <ogc:FeatureId fid="tiger_roads.8341"/>
        </ogc:Filter>
    </wfs:Delete>
</wfs:Transaction>

Thanks for your help.
CB

On Sat, Mar 29, 2008 at 11:34 AM, David Winslow <dwinslow@anonymised.com>

wrote:

> Hi CB,
>
> You can think of transactions as queries against the database, similar to
> a SQL "UPDATE blah WHERE ..." command. That is, when you make a
> transaction request, you are supplying a filter and modifying all the
> features that are matched. If nothing matches that filter, then you
> successfully modify 0 features.
>
> Short version: there's probably a typo in a literal or something in your
> filter, look that over.
>
> Hope this helps,
> David Winslow
>
> On Saturday 29 March 2008 11:25:37 CB wrote:
> > Hello,
> >
> > Using the default installation of GeoServer 1.6.2 and the sample data:
> > I am sending TransactionRequests to the server, and the
> > TransactionResult (contained in TransactionResponse) has a status of
> > SUCCESS. However, it appears that nothing is changed on the server.
> > How do I diagnose what is going wrong if the server returns SUCCESS?
> >
> > Also, the TransactionResponse always contain an InsertResult element;
> > for an Update or Delete, the fid = "none". Why is this?
> >
> > Thanks for any insight...
> >
> > -----------------------------------------------------------------------
> >-- Check out the new SourceForge.net Marketplace.
> > It's the best place to buy or sell services for
> > just about anything Open Source.
> > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/market
> >plac e _______________________________________________
> > Geoserver-users mailing list
> > Geoserver-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketpl
>ace _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4040,47f0f058143153327367457!

5

Thanks for the reply.
When I get the features from the server, the wfs:FeatureCollection
contains this:
    <gml:featureMember>
        <tiger:tiger_roads fid="tiger_roads.8341">
            <tiger:the_geom>
                <gml:MultiLineString
srsName="http://www.opengis.net/gml/srs/epsg.xml#4326&quot;&gt;
                    <gml:lineStringMember>
                        <gml:LineString>
                            <gml:coordinates
xmlns:gml="http://www.opengis.net/gml&quot; decimal="." cs="," ts="
">-74.001465,40.735218 -74.003431,40.735238</gml:coordinates>
                        </gml:LineString>
                    </gml:lineStringMember>
                </gml:MultiLineString>
            </tiger:the_geom>
            <tiger:CFCC>Z99</tiger:CFCC>
            <tiger:NAME>One Ave W</tiger:NAME>
        </tiger:tiger_roads>
    </gml:featureMember>

The fid matches the fid in the Delete request, and matches what is
seen on the server's console.

On Mon, Mar 31, 2008 at 10:23 AM, David Winslow <dwinslow@anonymised.com> wrote:

Let's keep this on the mailing list, all of us are smarter than just me :slight_smile:

I don't see anything wrong with this request; does a feature with
fid=tiger_roads.8431 actually exist?

-David Winslow

On Monday 31 March 2008 10:08:18 CB wrote:
> Thanks for the quick reply.
> Is there anything to be learned from the GeoServer console? If I send
> a simple Delete request, I see this on the console:
> Request: transaction
> handle = null
> service = WFS
> version = 1.0.0
> baseUrl = http://69.54.29.26:8080/geoserver/
> lockId = null
> group =
> [net.opengis.wfs:delete=net.opengis.wfs.impl.DeleteElementTypeIm pl@anonymised.com
> (filter: [ tiger_roads.8341 ], handle: null, typeName: {http://www.cen
> sus.gov}tiger_roads)]
> insert =
> update =
> delete = [net.opengis.wfs.impl.DeleteElementTypeImpl@anonymised.com
> (filter: [ t iger_roads.8341 ], handle: null, typeName:
> {http://www.census.gov}tiger_roads)] native =
> releaseAction = ALL
>
> The TransactionRequest:
> <?xml version="1.0" ?>
> <wfs:Transaction
> version="1.0.0"
> service="WFS"
> xmlns:wfs="http://www.opengis.net/wfs&quot;
> xmlns:sde="http://geoserver.sf.net"
> xmlns:tiger="http://www.census.gov"
> xmlns:it.geosolutions="http://www.geo-solutions.it"
> xmlns:nurc="http://www.nurc.nato.int"
> xmlns:cite="http://www.opengeospatial.net/cite&quot;
> xmlns:gml="http://www.opengis.net/gml&quot;
> xmlns:ogc="http://www.opengis.net/ogc&quot;
> xmlns="http://www.opengis.net/wfs&quot;
> xsi:schemaLocation="http://www.opengis.net/wfs ../wfs/1.0.0/WFS-basic.xsd"
> xmlns:sf="http://www.openplans.org/spearfish&quot;
> xmlns:topp="http://www.openplans.org/topp&quot;
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot;&gt;
> <wfs:Delete typeName="tiger:tiger_roads">
> <ogc:Filter>
> <ogc:FeatureId fid="tiger_roads.8341"/>
> </ogc:Filter>
> </wfs:Delete>
> </wfs:Transaction>
>
> Thanks for your help.
> CB
>
> On Sat, Mar 29, 2008 at 11:34 AM, David Winslow <dwinslow@anonymised.com>
wrote:
> > Hi CB,
> >
> > You can think of transactions as queries against the database, similar to
> > a SQL "UPDATE blah WHERE ..." command. That is, when you make a
> > transaction request, you are supplying a filter and modifying all the
> > features that are matched. If nothing matches that filter, then you
> > successfully modify 0 features.
> >
> > Short version: there's probably a typo in a literal or something in your
> > filter, look that over.
> >
> > Hope this helps,
> > David Winslow
> >
> > On Saturday 29 March 2008 11:25:37 CB wrote:
> > > Hello,
> > >
> > > Using the default installation of GeoServer 1.6.2 and the sample data:
> > > I am sending TransactionRequests to the server, and the
> > > TransactionResult (contained in TransactionResponse) has a status of
> > > SUCCESS. However, it appears that nothing is changed on the server.
> > > How do I diagnose what is going wrong if the server returns SUCCESS?
> > >
> > > Also, the TransactionResponse always contain an InsertResult element;
> > > for an Update or Delete, the fid = "none". Why is this?
> > >
> > > Thanks for any insight...
> > >
> > > -----------------------------------------------------------------------
> > >-- Check out the new SourceForge.net Marketplace.
> > > It's the best place to buy or sell services for
> > > just about anything Open Source.
> > > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/market
> > >plac e _______________________________________________

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

> > -------------------------------------------------------------------------
> > Check out the new SourceForge.net Marketplace.
> > It's the best place to buy or sell services for
> > just about anything Open Source.
> > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketpl
> >ace _______________________________________________
> > Geoserver-users mailing list
> > Geoserver-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
> !DSPAM:4040,47f0f058143153327367457!

6

It appears Insert is working, while Update and Delete do not.
I am trying to find the differences in the TransactionRequests that
would explain the different results...

On Mon, Mar 31, 2008 at 10:56 AM, CB <cbne@anonymised.com> wrote:

Thanks for the reply.
When I get the features from the server, the wfs:FeatureCollection
contains this:
    <gml:featureMember>
        <tiger:tiger_roads fid="tiger_roads.8341">
            <tiger:the_geom>
                <gml:MultiLineString
srsName="http://www.opengis.net/gml/srs/epsg.xml#4326&quot;&gt;
                    <gml:lineStringMember>
                        <gml:LineString>
                            <gml:coordinates
xmlns:gml="http://www.opengis.net/gml&quot; decimal="." cs="," ts="
">-74.001465,40.735218 -74.003431,40.735238</gml:coordinates>
                        </gml:LineString>
                    </gml:lineStringMember>
                </gml:MultiLineString>
            </tiger:the_geom>
            <tiger:CFCC>Z99</tiger:CFCC>
            <tiger:NAME>One Ave W</tiger:NAME>
        </tiger:tiger_roads>
    </gml:featureMember>

The fid matches the fid in the Delete request, and matches what is
seen on the server's console.

On Mon, Mar 31, 2008 at 10:23 AM, David Winslow <dwinslow@anonymised.com> wrote:
> Let's keep this on the mailing list, all of us are smarter than just me :slight_smile:
>
> I don't see anything wrong with this request; does a feature with
> fid=tiger_roads.8431 actually exist?
>
> -David Winslow
>
>
>
> On Monday 31 March 2008 10:08:18 CB wrote:
> > Thanks for the quick reply.
> > Is there anything to be learned from the GeoServer console? If I send
> > a simple Delete request, I see this on the console:
> > Request: transaction
> > handle = null
> > service = WFS
> > version = 1.0.0
> > baseUrl = http://69.54.29.26:8080/geoserver/
> > lockId = null
> > group =
> > [net.opengis.wfs:delete=net.opengis.wfs.impl.DeleteElementTypeIm pl@anonymised.com
> > (filter: [ tiger_roads.8341 ], handle: null, typeName: {http://www.cen
> > sus.gov}tiger_roads)]
> > insert =
> > update =
> > delete = [net.opengis.wfs.impl.DeleteElementTypeImpl@anonymised.com
> > (filter: [ t iger_roads.8341 ], handle: null, typeName:
> > {http://www.census.gov}tiger_roads)] native =
> > releaseAction = ALL
> >
> > The TransactionRequest:
> > <?xml version="1.0" ?>
> > <wfs:Transaction
> > version="1.0.0"
> > service="WFS"
> > xmlns:wfs="http://www.opengis.net/wfs&quot;
> > xmlns:sde="http://geoserver.sf.net"
> > xmlns:tiger="http://www.census.gov"
> > xmlns:it.geosolutions="http://www.geo-solutions.it"
> > xmlns:nurc="http://www.nurc.nato.int"
> > xmlns:cite="http://www.opengeospatial.net/cite&quot;
> > xmlns:gml="http://www.opengis.net/gml&quot;
> > xmlns:ogc="http://www.opengis.net/ogc&quot;
> > xmlns="http://www.opengis.net/wfs&quot;
> > xsi:schemaLocation="http://www.opengis.net/wfs ../wfs/1.0.0/WFS-basic.xsd"
> > xmlns:sf="http://www.openplans.org/spearfish&quot;
> > xmlns:topp="http://www.openplans.org/topp&quot;
> > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot;&gt;
> > <wfs:Delete typeName="tiger:tiger_roads">
> > <ogc:Filter>
> > <ogc:FeatureId fid="tiger_roads.8341"/>
> > </ogc:Filter>
> > </wfs:Delete>
> > </wfs:Transaction>
> >
> > Thanks for your help.
> > CB
> >
> > On Sat, Mar 29, 2008 at 11:34 AM, David Winslow <dwinslow@anonymised.com>
> wrote:
> > > Hi CB,
> > >
> > > You can think of transactions as queries against the database, similar to
> > > a SQL "UPDATE blah WHERE ..." command. That is, when you make a
> > > transaction request, you are supplying a filter and modifying all the
> > > features that are matched. If nothing matches that filter, then you
> > > successfully modify 0 features.
> > >
> > > Short version: there's probably a typo in a literal or something in your
> > > filter, look that over.
> > >
> > > Hope this helps,
> > > David Winslow
> > >
> > > On Saturday 29 March 2008 11:25:37 CB wrote:
> > > > Hello,
> > > >
> > > > Using the default installation of GeoServer 1.6.2 and the sample data:
> > > > I am sending TransactionRequests to the server, and the
> > > > TransactionResult (contained in TransactionResponse) has a status of
> > > > SUCCESS. However, it appears that nothing is changed on the server.
> > > > How do I diagnose what is going wrong if the server returns SUCCESS?
> > > >
> > > > Also, the TransactionResponse always contain an InsertResult element;
> > > > for an Update or Delete, the fid = "none". Why is this?
> > > >
> > > > Thanks for any insight...
> > > >
> > > > -----------------------------------------------------------------------
> > > >-- Check out the new SourceForge.net Marketplace.
> > > > It's the best place to buy or sell services for
> > > > just about anything Open Source.
> > > > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/market
> > > >plac e _______________________________________________
>
> > > > Geoserver-users mailing list
> > > > Geoserver-users@lists.sourceforge.net
> > > > https://lists.sourceforge.net/lists/listinfo/geoserver-users
> > >
>
> > > -------------------------------------------------------------------------
> > > Check out the new SourceForge.net Marketplace.
> > > It's the best place to buy or sell services for
> > > just about anything Open Source.
> > > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketpl
> > >ace _______________________________________________
> > > Geoserver-users mailing list
> > > Geoserver-users@lists.sourceforge.net
> > > https://lists.sourceforge.net/lists/listinfo/geoserver-users
> >
> > !DSPAM:4040,47f0f058143153327367457!
>
>
>