<HTML><HEAD>
<META content="text/html; charset=iso-8859-15" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18702"></HEAD>
<BODY style="MARGIN: 4px 4px 1px">
<DIV>Hi,</DIV>
<DIV> </DIV>
<DIV><A href="http://old.nabble.com/-WFS-T-and-Oracle--Error-performing-insert-td26903498.html#a27076260">http://old.nabble.com/-WFS-T-and-Oracle--Error-performing-insert-td26903498.html#a27076260</A></DIV>
<DIV> </DIV>
<DIV>A new response in geoserver mailinglist :</DIV>
<DIV> </DIV>
<DIV>Hi, <BR><BR>Schema says: <BR><BR> <xsd:choice minOccurs="0" maxOccurs="unbounded"> <BR> <xsd:element ref="wfs:Insert"/> <BR> <xsd:element ref="wfs:Update"/> <BR> <xsd:element ref="wfs:Delete"/> <BR> <xsd:element ref="wfs:Native"/> <BR> </xsd:choice> <BR><BR><BR>I do not know how it should be interpreted, but I can imagine that some WFS-T client would like to gather consecutive events during editing session and then sends them as one multirequest. Edits may consern the same feature and in that case only Insert-Update-Delete sequence can work. It is impossible to delete a feature if it has not been created yet, and updating after delete will not work either. I guess that OpenLayers does not send multiple request for the same feature with one transaction but because it would not harm it in any way to sort the requests in order Insert-Update-Delete so why not to do it? <BR><BR>Meanwhile my colleague made a test with XMLSpy and it validates requests in any order. That speaks for that Geoserver is wrong and OpenLayers right. Or then perhaps both the OGC standard and OpenLayers are wrong :) <BR><BR>-Jukka Rahkonen- </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>regards,</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Pat<BR><BR>>>> Andreas Hocevar <ahocevar@opengeo.org> 01/07/10 11:06 am >>><BR>Hi,<BR><BR>this looks like a GeoServer issue. Can you report that in the geoserver<BR>users list? If not let me know, then I'll forward your message.<BR><BR>Regards,<BR>Andreas.<BR><BR>On 2010-01-07 14:49, Patrick Mayrand wrote:<BR>> Hi,<BR>> <BR>> my layer definition:<BR>> <BR>> olWFSParcelle = new OpenLayers.Layer.Vector("Parcelle - WFS-T", {<BR>> projection: new OpenLayers.Projection("EPSG:32198"),<BR>> strategies: [new OpenLayers.Strategy.BBOX(), oSaveStrategy],<BR>> protocol: new OpenLayers.Protocol.WFS({<BR>> version: "1.1.0",<BR>> url: "http://sig.fool.qc/geoserver/wfs<BR>> <<A href="http://mrsig.fadq.qc/geoserver/wfs">http://mrsig.fadq.qc/geoserver/wfs</A>>",<BR>> featureType: "SAGR_V3",<BR>> srsName: "EPSG:32198",<BR>> featurePrefix: "fadq",<BR>> featureNS: "http://sig.fool.qc/fadq<BR>> <<A href="http://mrsig.fadq.qc/fadq">http://mrsig.fadq.qc/fadq</A>>",<BR>> geometryName: "GEOM",<BR>> schema: "http://sig.fool.qc/geoserver/<BR>> <<A href="http://mrsig.fadq.qc/geoserver/wfs/DescribeFeatureType?version=1.1.0&srsName=EPSG:32198&TypeName=fadq:SAGR_V3">http://mrsig.fadq.qc/geoserver/wfs/DescribeFeatureType?version=1.1.0&srsName=EPSG:32198&TypeName=fadq:SAGR_V3</A>>wfs?service=WFS&version=1.1.0&request=DescribeFeatureTyp&srsName=EPSG:32198&typename=faqd:SAGR_V3<BR>> <<A href="http://path/to/geoserver/wfs?service=WFS&version=1.1.0&request=DescribeFeatureTyp&typename=faqd:SAGR_V3">http://path/to/geoserver/wfs?service=WFS&version=1.1.0&request=DescribeFeatureTyp&typename=faqd:SAGR_V3</A>>"<BR>> })<BR>> });<BR>><BR>> >>> Andreas Hocevar <ahocevar@opengeo.org> 01/07/10 3:26 am >>><BR>> Hi,<BR>><BR>> I do not see how the request below would make any difference if the<BR>> order was changed. According to the schema, the Transaction children are<BR>> a 0..* choice, not a sequence.<BR>><BR>> Can you please also paste the server response to the failing transaction<BR>> request?<BR>><BR>> Regards,<BR>> Andreas.<BR>><BR>> The only problem I see with the xml you pasted is that the<BR>> On 2010-01-06 22:34, Patrick Mayrand wrote:<BR>> > Hi,<BR>> > <BR>> > with OL i use the edition of polygon. A transaction with several<BR>> > operation does not work<BR>> > <BR>> > GML generate by Openlayers:<BR>> > <BR>> > <wfs:Transaction xmlns:wfs="http://www.opengis.net/wfs" service="WFS"<BR>> > version="1.1.0"<BR>> > xsi:schemaLocation="http://www.opengis.net/wfs<BR>> <A href='http://schemas.opengis.net/wfs/1.1.0/wfs.xsd"'>http://schemas.opengis.net/wfs/1.1.0/wfs.xsd"</A><BR>> <<A href="http://schemas.opengis.net/wfs/1.1.0/wfs.xsd"">http://schemas.opengis.net/wfs/1.1.0/wfs.xsd"</A>><BR>> > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><BR>> > <wfs:Delete typeName="fadq:SAGR_V3"<BR>> > xmlns:fadq="http://sig.fool.qc/fadq"><ogc:Filter (<BR>> > 'http://mrsig.fadq.qc/fadq" )<BR>> > xmlns:ogc="http://www.opengis.net/ogc"><ogc:FeatureId (<BR>> > 'http://www.opengis.net/ogc" )<BR>> > fid="SAGR_V3.17"/></ogc:Filter></wfs:Delete><BR>> > <wfs:Insert><feature:SAGR_V3<BR>> ><BR>> xmlns:feature="http://sig.fool.qc/fadq"><feature:GEOM><gml:MultiSurface (<BR>> > 'http://sig.fool.qc/fadq" ) xmlns:gml="http://www.opengis.net/gml"<BR>> ><BR>> srsName="EPSG:32198"><gml:surfaceMember><gml:Polygon><gml:exterior><gml:LinearRing><gml:posList>-206413.01818846<BR>> > 292765.09570319 -206182.22900389 292089.51281744 -205745.8276367<BR>> > 292269.94799811 -205917.87048338 292479.75634772 -206413.01818846<BR>> ><BR>> 292765.09570319</gml:posList></gml:LinearRing></gml:exterior></gml:Polygon></gml:surfaceMember></gml:MultiSurface></feature:GEOM></feature:SAGR_V3></wfs:Insert><BR>> ><BR>> > </wfs:Transaction><BR>> > <BR>> > <BR>> > The order is:<BR>> > <BR>> > DELETE - INSERT<BR>> > <BR>> > <BR>> > but the order should be reversed and it works<BR>> > <BR>> > INSERT - DELETE<BR>> > <BR>> > <BR>> > It this normal?? a bug??<BR>> > <BR>> > <BR>> > regards,<BR>> > <BR>> > <BR>> > Pat<BR>> ><BR>> ><BR>> > _______________________________________________<BR>> > Users mailing list<BR>> > Users@openlayers.org<BR>> > <A href="http://openlayers.org/mailman/listinfo/users">http://openlayers.org/mailman/listinfo/users</A><BR>> > <BR>><BR>><BR>> -- <BR>> Andreas Hocevar<BR>> OpenGeo - <A href="http://opengeo.org/">http://opengeo.org/</A><BR>> Expert service straight from the developers.<BR>><BR><BR><BR>-- <BR>Andreas Hocevar<BR>OpenGeo - <A href="http://opengeo.org/">http://opengeo.org/</A><BR>Expert service straight from the developers.<BR><BR></DIV></BODY></HTML>