<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>&nbsp;</DIV>
<DIV>the link:</DIV>
<DIV><A href="http://old.nabble.com/-WFS-T-and-Oracle--Error-performing-insert-td26903498.html">http://old.nabble.com/-WFS-T-and-Oracle--Error-performing-insert-td26903498.html</A></DIV>
<DIV>&nbsp;</DIV>
<DIV>regards,</DIV>
<DIV>&nbsp;</DIV>
<DIV>Pat</DIV>
<DIV><BR><BR>&gt;&gt;&gt; Andreas Hocevar &lt;ahocevar@opengeo.org&gt; 01/07/10 11:06 am &gt;&gt;&gt;<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>&gt; Hi,<BR>&gt;&nbsp; <BR>&gt; my layer definition:<BR>&gt;&nbsp; <BR>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; olWFSParcelle = new OpenLayers.Layer.Vector("Parcelle - WFS-T", {<BR>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; projection: new OpenLayers.Projection("EPSG:32198"),<BR>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; strategies: [new OpenLayers.Strategy.BBOX(), oSaveStrategy],<BR>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; protocol: new OpenLayers.Protocol.WFS({<BR>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; version:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "1.1.0",<BR>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; url:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "http://sig.fool.qc/geoserver/wfs<BR>&gt; &lt;<A href="http://mrsig.fadq.qc/geoserver/wfs">http://mrsig.fadq.qc/geoserver/wfs</A>&gt;",<BR>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; featureType:&nbsp;&nbsp; "SAGR_V3",<BR>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; srsName:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "EPSG:32198",<BR>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; featurePrefix:&nbsp; "fadq",<BR>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; featureNS:&nbsp;&nbsp;&nbsp;&nbsp; "http://sig.fool.qc/fadq<BR>&gt; &lt;<A href="http://mrsig.fadq.qc/fadq">http://mrsig.fadq.qc/fadq</A>&gt;",<BR>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; geometryName:&nbsp; "GEOM",<BR>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; schema:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "http://sig.fool.qc/geoserver/<BR>&gt; &lt;<A href="http://mrsig.fadq.qc/geoserver/wfs/DescribeFeatureType?version=1.1.0&amp;srsName=EPSG:32198&amp;TypeName=fadq:SAGR_V3">http://mrsig.fadq.qc/geoserver/wfs/DescribeFeatureType?version=1.1.0&amp;srsName=EPSG:32198&amp;TypeName=fadq:SAGR_V3</A>&gt;wfs?service=WFS&amp;version=1.1.0&amp;request=DescribeFeatureTyp&amp;srsName=EPSG:32198&amp;typename=faqd:SAGR_V3<BR>&gt; &lt;<A href="http://path/to/geoserver/wfs?service=WFS&amp;version=1.1.0&amp;request=DescribeFeatureTyp&amp;typename=faqd:SAGR_V3">http://path/to/geoserver/wfs?service=WFS&amp;version=1.1.0&amp;request=DescribeFeatureTyp&amp;typename=faqd:SAGR_V3</A>&gt;"<BR>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; })<BR>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; });<BR>&gt;<BR>&gt; &gt;&gt;&gt; Andreas Hocevar &lt;ahocevar@opengeo.org&gt; 01/07/10 3:26 am &gt;&gt;&gt;<BR>&gt; Hi,<BR>&gt;<BR>&gt; I do not see how the request below would make any difference if the<BR>&gt; order was changed. According to the schema, the Transaction children are<BR>&gt; a 0..* choice, not a sequence.<BR>&gt;<BR>&gt; Can you please also paste the server response to the failing transaction<BR>&gt; request?<BR>&gt;<BR>&gt; Regards,<BR>&gt; Andreas.<BR>&gt;<BR>&gt; The only problem I see with the xml you pasted is that the<BR>&gt; On 2010-01-06 22:34, Patrick Mayrand wrote:<BR>&gt; &gt; Hi,<BR>&gt; &gt; <BR>&gt; &gt; with OL i use the edition of polygon. A transaction with several<BR>&gt; &gt; operation does not work<BR>&gt; &gt; <BR>&gt; &gt; GML generate by Openlayers:<BR>&gt; &gt; <BR>&gt; &gt; &lt;wfs:Transaction xmlns:wfs="http://www.opengis.net/wfs" service="WFS"<BR>&gt; &gt; version="1.1.0"<BR>&gt; &gt; xsi:schemaLocation="http://www.opengis.net/wfs<BR>&gt; <A href='http://schemas.opengis.net/wfs/1.1.0/wfs.xsd"'>http://schemas.opengis.net/wfs/1.1.0/wfs.xsd"</A><BR>&gt; &lt;<A href="http://schemas.opengis.net/wfs/1.1.0/wfs.xsd"">http://schemas.opengis.net/wfs/1.1.0/wfs.xsd"</A>&gt;<BR>&gt; &gt; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"&gt;<BR>&gt; &gt; &lt;wfs:Delete typeName="fadq:SAGR_V3"<BR>&gt; &gt; xmlns:fadq="http://sig.fool.qc/fadq"&gt;&lt;ogc:Filter (<BR>&gt; &gt; 'http://mrsig.fadq.qc/fadq" )<BR>&gt; &gt; xmlns:ogc="http://www.opengis.net/ogc"&gt;&lt;ogc:FeatureId (<BR>&gt; &gt; 'http://www.opengis.net/ogc" )<BR>&gt; &gt; fid="SAGR_V3.17"/&gt;&lt;/ogc:Filter&gt;&lt;/wfs:Delete&gt;<BR>&gt; &gt; &lt;wfs:Insert&gt;&lt;feature:SAGR_V3<BR>&gt; &gt;<BR>&gt; xmlns:feature="http://sig.fool.qc/fadq"&gt;&lt;feature:GEOM&gt;&lt;gml:MultiSurface (<BR>&gt; &gt; 'http://sig.fool.qc/fadq" ) xmlns:gml="http://www.opengis.net/gml"<BR>&gt; &gt;<BR>&gt; srsName="EPSG:32198"&gt;&lt;gml:surfaceMember&gt;&lt;gml:Polygon&gt;&lt;gml:exterior&gt;&lt;gml:LinearRing&gt;&lt;gml:posList&gt;-206413.01818846<BR>&gt; &gt; 292765.09570319 -206182.22900389 292089.51281744 -205745.8276367<BR>&gt; &gt; 292269.94799811 -205917.87048338 292479.75634772 -206413.01818846<BR>&gt; &gt;<BR>&gt; 292765.09570319&lt;/gml:posList&gt;&lt;/gml:LinearRing&gt;&lt;/gml:exterior&gt;&lt;/gml:Polygon&gt;&lt;/gml:surfaceMember&gt;&lt;/gml:MultiSurface&gt;&lt;/feature:GEOM&gt;&lt;/feature:SAGR_V3&gt;&lt;/wfs:Insert&gt;<BR>&gt; &gt;<BR>&gt; &gt; &lt;/wfs:Transaction&gt;<BR>&gt; &gt; <BR>&gt; &gt; <BR>&gt; &gt; The order is:<BR>&gt; &gt; <BR>&gt; &gt; DELETE - INSERT<BR>&gt; &gt; <BR>&gt; &gt; <BR>&gt; &gt; but the order should be reversed and it works<BR>&gt; &gt; <BR>&gt; &gt; INSERT - DELETE<BR>&gt; &gt; <BR>&gt; &gt; <BR>&gt; &gt; It this normal?? a bug??<BR>&gt; &gt; <BR>&gt; &gt; <BR>&gt; &gt; regards,<BR>&gt; &gt; <BR>&gt; &gt; <BR>&gt; &gt; Pat<BR>&gt; &gt;<BR>&gt; &gt;<BR>&gt; &gt; _______________________________________________<BR>&gt; &gt; Users mailing list<BR>&gt; &gt; Users@openlayers.org<BR>&gt; &gt; <A href="http://openlayers.org/mailman/listinfo/users">http://openlayers.org/mailman/listinfo/users</A><BR>&gt; &gt;&nbsp; <BR>&gt;<BR>&gt;<BR>&gt; -- <BR>&gt; Andreas Hocevar<BR>&gt; OpenGeo - <A href="http://opengeo.org/">http://opengeo.org/</A><BR>&gt; Expert service straight from the developers.<BR>&gt;<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>