[Geoserver-users] [WFS-T and Oracle] Error performing insert

Patrick_Mayrand · December 23, 2009, 3:00pm

Hi,

Geoserver: stable 2.0

my wfs-t only works when I make one or more inserts or updates and deletes but it does not work with inserts and updates or inserts and deletes.

Not Work:

<wfs:Transaction xmlns:wfs=“http://www.opengis.net/wfs” service=“WFS” version=“1.1.0” xsi:schemaLocation=“http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/wfs.xsd” xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”>
<wfs:Delete typeName=“fadq:SAGR_V3” xmlns:fadq=“[http://sig.fool.qc/fadq"><ogc:Filter](http://mrsig.fadq.qc/fadq"><ogc:Filter) xmlns:ogc=”[http://www.opengis.net/ogc"><ogc:FeatureId](http://www.opengis.net/ogc"><ogc:FeatureId) fid=“SAGR_V3.17”/></ogc:Filter></wfs:Delete>
wfs:Insert<feature:SAGR_V3 xmlns:feature="[http://sig.fool.qc/fadq"><feature:GEOM><gml:MultiSurface](http://sig.fool.qc/fadq">feature:GEOM<gml:MultiSurface) xmlns:gml=“http://www.opengis.net/gml” srsName=“EPSG:32198”>gml:surfaceMember gml:Polygon gml:exterior gml:LinearRing gml:posList-206413.01818846 292765.09570319 -206182.22900389 292089.51281744 -205745.8276367 292269.94799811 -205917.87048338 292479.75634772 -206413.01818846 292765.09570319</gml:posList></gml:LinearRing></gml:exterior></gml:Polygon></gml:surfaceMember></gml:MultiSurface></feature:GEOM></feature:SAGR_V3></wfs:Insert>
</wfs:Transaction>

In geoserver log:

Request: transaction
handle = null
service = WFS
version = 1.1.0
baseUrl = http://sig.fool.qc:80/geoserver/
providedVersion = null
lockId = null
group = [wfs:delete=net.opengis.wfs.impl.DeleteElementTypeImpl@anonymised.com (filter: [ SAGR_V3.17 ], handle: null, typeName: {http://sig.fool.qc/fadq}SAGR_V3), wfs:insert=net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com (feature: [SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute: GEOM=MULTIPOLYGON (((-206413.01818846 292765.09570319, -206182.22900389 292089.51281744, -205745.8276367 292269.94799811, -205917.87048338 292479.75634772, -206413.01818846 292765.09570319))), SimpleFeatureImpl.Attribute: NAME=null]], handle: null, idgen: , inputFormat: , srsName: null)]
insert = [net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com (feature: [SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute: GEOM=MULTIPOLYGON (((-206413.01818846 292765.09570319, -206182.22900389 292089.51281744, -205745.8276367 292269.94799811, -205917.87048338 292479.75634772, -206413.01818846 292765.09570319))), SimpleFeatureImpl.Attribute: NAME=null]], handle: null, idgen: , inputFormat: , srsName: null)]
update =
delete = [net.opengis.wfs.impl.DeleteElementTypeImpl@anonymised.com (filter: [ SAGR_V3.17 ], handle: null, typeName: {http://sig.fool.qc/fadq}SAGR_V3)]
native =
releaseAction = ALL

org.geoserver.wfs.WFSException: Error performing insert
at org.geoserver.wfs.response.TransactionResponse.v_1_1(TransactionResponse.java:197)
at org.geoserver.wfs.response.TransactionResponse.write(TransactionResponse.java:67)
at org.geoserver.ows.Dispatcher.response(Dispatcher.java:705)
at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:213)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:73)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:619)

If I remove the line delete it works:

<wfs:Transaction xmlns:wfs=“http://www.opengis.net/wfs” service=“WFS” version=“1.1.0” xsi:schemaLocation=“http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/wfs.xsd” xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”>
wfs:Insert<feature:SAGR_V3 xmlns:feature="[http://sig.fool.qc/fadq"><feature:GEOM><gml:MultiSurface](http://mrsig.fadq.qc/fadq">feature:GEOM<gml:MultiSurface) xmlns:gml=“http://www.opengis.net/gml” srsName=“EPSG:32198”>gml:surfaceMember gml:Polygon gml:exterior gml:LinearRing gml:posList-206413.01818846 292765.09570319 -206182.22900389 292089.51281744 -205745.8276367 292269.94799811 -205917.87048338 292479.75634772 -206413.01818846 292765.09570319</gml:posList></gml:LinearRing></gml:exterior></gml:Polygon></gml:surfaceMember></gml:MultiSurface></feature:GEOM></feature:SAGR_V3></wfs:Insert>
</wfs:Transaction>

In geoserver log:

Request: transaction
handle = null
service = WFS
version = 1.1.0
baseUrl = http://sig.fool.qc:80/geoserver/
providedVersion = null
lockId = null
group = [wfs:insert=net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com (feature: [SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute: GEOM=MULTIPOLYGON (((-206413.01818846 292765.09570319, -206182.22900389 292089.51281744, -205745.8276367 292269.94799811, -205917.87048338 292479.75634772, -206413.01818846 292765.09570319))), SimpleFeatureImpl.Attribute: NAME=null]], handle: null, idgen: , inputFormat: , srsName: null)]
insert = [net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com (feature: [SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute: GEOM=MULTIPOLYGON (((-206413.01818846 292765.09570319, -206182.22900389 292089.51281744, -205745.8276367 292269.94799811, -205917.87048338 292479.75634772, -206413.01818846 292765.09570319))), SimpleFeatureImpl.Attribute: NAME=null]], handle: null, idgen: , inputFormat: , srsName: null)]
update =
delete =
native =
releaseAction = ALL

best regards,

Pat

Jukka_Rahkonen · December 23, 2009, 4:07pm

Hi,

We are doing these with Oracle NG and they do work for us. I am remembering that the order must be insert-update-delete, have you checked that?

-Jukka Rahkonen-

-----Alkuperäinen viesti-----
Lähettäjä: Patrick Mayrand [mailto:Patrick.Mayrand@anonymised.com]
Lähetetty: ke 23.12.2009 17:00
Vastaanottaja: geoserver-users@lists.sourceforge.net
Aihe: [Geoserver-users] [WFS-T and Oracle] Error performing insert

Hi,

Geoserver: stable 2.0

my wfs-t only works when I make one or more inserts or updates and deletes but it does not work with inserts and updates or inserts and deletes.

Not Work:

<wfs:Transaction xmlns:wfs="http://www.opengis.net/wfs" service="WFS" version="1.1.0" xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/wfs.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<wfs:Delete typeName="fadq:SAGR_V3" xmlns:fadq="http://sig.fool.qc/fadq"><ogc:Filter ( 'http://mrsig.fadq.qc/fadq" ) xmlns:ogc="http://www.opengis.net/ogc"><ogc:FeatureId ( 'http://www.opengis.net/ogc" ) fid="SAGR_V3.17"/></ogc:Filter></wfs:Delete>
<wfs:Insert><feature:SAGR_V3 xmlns:feature="http://sig.fool.qc/fadq"><feature:GEOM><gml:MultiSurface ( 'http://sig.fool.qc/fadq" ) xmlns:gml="http://www.opengis.net/gml" srsName="EPSG:32198"><gml:surfaceMember><gml:Polygon><gml:exterior><gml:LinearRing><gml:posList>-206413.01818846 292765.09570319 -206182.22900389 292089.51281744 -205745.8276367 292269.94799811 -205917.87048338 292479.75634772 -206413.01818846 292765.09570319</gml:posList></gml:LinearRing></gml:exterior></gml:Polygon></gml:surfaceMember></gml:MultiSurface></feature:GEOM></feature:SAGR_V3></wfs:Insert>
</wfs:Transaction>

In geoserver log:

Request: transaction
        handle = null
        service = WFS
        version = 1.1.0
        baseUrl = http://sig.fool.qc:80/geoserver/ ( http://mrsig.fadq.qc:80/geoserver/ )
        providedVersion = null
        lockId = null
        group = [wfs:delete=net.opengis.wfs.impl.DeleteElementTypeImpl@...2843... (filter: [ SAGR_V3.17 ], handle: null, typeName: {http://sig.fool.qc/fadq\}SAGR_V3), wfs:insert=net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com (feature: [SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute: GEOM<GEOM id=fid--20068e19_12592a87d6b_6e15>=MULTIPOLYGON (((-206413.01818846 292765.09570319, -206182.22900389 292089.51281744, -205745.8276367 292269.94799811, -205917.87048338 292479.75634772, -206413.01818846 292765.09570319))), SimpleFeatureImpl.Attribute: NAME<NAME id=fid--20068e19_12592a87d6b_6e15>=null]], handle: null, idgen: <unset>, inputFormat: <unset>, srsName: null)]
        insert = [net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com (feature: [SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute: GEOM<GEOM id=fid--20068e19_12592a87d6b_6e15>=MULTIPOLYGON (((-206413.01818846 292765.09570319, -206182.22900389 292089.51281744, -205745.8276367 292269.94799811, -205917.87048338 292479.75634772, -206413.01818846 292765.09570319))), SimpleFeatureImpl.Attribute: NAME<NAME id=fid--20068e19_12592a87d6b_6e15>=null]], handle: null, idgen: <unset>, inputFormat: <unset>, srsName: null)]
        update =
        delete = [net.opengis.wfs.impl.DeleteElementTypeImpl@anonymised.com (filter: [ SAGR_V3.17 ], handle: null, typeName: {http://sig.fool.qc/fadq\}SAGR_V3)]
        native =
        releaseAction = ALL

org.geoserver.wfs.WFSException: Error performing insert
        at org.geoserver.wfs.response.TransactionResponse.v_1_1(TransactionResponse.java:197)
        at org.geoserver.wfs.response.TransactionResponse.write(TransactionResponse.java:67)
        at org.geoserver.ows.Dispatcher.response(Dispatcher.java:705)
        at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:213)
        at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
        at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
        at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
        at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
        at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
        at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:73)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:47)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
        at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
        at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
        at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
        at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
        at java.lang.Thread.run(Thread.java:619)

If I remove the line delete it works:

<wfs:Transaction xmlns:wfs="http://www.opengis.net/wfs" service="WFS" version="1.1.0" xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/wfs.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<wfs:Insert><feature:SAGR_V3 xmlns:feature="http://sig.fool.qc/fadq"><feature:GEOM><gml:MultiSurface ( 'http://mrsig.fadq.qc/fadq" ) xmlns:gml="http://www.opengis.net/gml" srsName="EPSG:32198"><gml:surfaceMember><gml:Polygon><gml:exterior><gml:LinearRing><gml:posList>-206413.01818846 292765.09570319 -206182.22900389 292089.51281744 -205745.8276367 292269.94799811 -205917.87048338 292479.75634772 -206413.01818846 292765.09570319</gml:posList></gml:LinearRing></gml:exterior></gml:Polygon></gml:surfaceMember></gml:MultiSurface></feature:GEOM></feature:SAGR_V3></wfs:Insert>
</wfs:Transaction>

In geoserver log:

Request: transaction
        handle = null
        service = WFS
        version = 1.1.0
        baseUrl = http://sig.fool.qc:80/geoserver/ ( http://sig.fool.qc:80/geoserver/ )
        providedVersion = null
        lockId = null
        group = [wfs:insert=net.opengis.wfs.impl.InsertElementTypeImpl@...2845... (feature: [SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute: GEOM<GEOM id=fid--20068e19_12592a87d6b_6e17>=MULTIPOLYGON (((-206413.01818846 292765.09570319, -206182.22900389 292089.51281744, -205745.8276367 292269.94799811, -205917.87048338 292479.75634772, -206413.01818846 292765.09570319))), SimpleFeatureImpl.Attribute: NAME<NAME id=fid--20068e19_12592a87d6b_6e17>=null]], handle: null, idgen: <unset>, inputFormat: <unset>, srsName: null)]
        insert = [net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com (feature: [SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute: GEOM<GEOM id=fid--20068e19_12592a87d6b_6e17>=MULTIPOLYGON (((-206413.01818846 292765.09570319, -206182.22900389 292089.51281744, -205745.8276367 292269.94799811, -205917.87048338 292479.75634772, -206413.01818846 292765.09570319))), SimpleFeatureImpl.Attribute: NAME<NAME id=fid--20068e19_12592a87d6b_6e17>=null]], handle: null, idgen: <unset>, inputFormat: <unset>, srsName: null)]
        update =
        delete =
        native =
        releaseAction = ALL

best regards,

Pat

Patrick_Mayrand · December 23, 2009, 5:22pm

Thanks..........

yes when i change the order, it work.

Now i search:

how to change the order in openlayers

Pat

Rahkonen Jukka wrote:

Hi,

We are doing these with Oracle NG and they do work for us. I am
remembering that the order must be insert-update-delete, have you checked
that?

-Jukka Rahkonen-

-----Alkuperäinen viesti-----
Lähettäjä: Patrick Mayrand [mailto:Patrick.Mayrand@anonymised.com…]
Lähetetty: ke 23.12.2009 17:00
Vastaanottaja: geoserver-users@lists.sourceforge.net
Aihe: [Geoserver-users] [WFS-T and Oracle] Error performing insert

Hi,

Geoserver: stable 2.0

my wfs-t only works when I make one or more inserts or updates and deletes
but it does not work with inserts and updates or inserts and deletes.

Not Work:

<wfs:Transaction xmlns:wfs="http://www.opengis.net/wfs" service="WFS"
version="1.1.0" xsi:schemaLocation="http://www.opengis.net/wfs
http://schemas.opengis.net/wfs/1.1.0/wfs.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<wfs:Delete typeName="fadq:SAGR_V3"
xmlns:fadq="http://sig.fool.qc/fadq"><ogc:Filter (
'http://mrsig.fadq.qc/fadq" )
xmlns:ogc="http://www.opengis.net/ogc"><ogc:FeatureId (
'http://www.opengis.net/ogc" )
fid="SAGR_V3.17"/></ogc:Filter></wfs:Delete>
<wfs:Insert><feature:SAGR_V3
xmlns:feature="http://sig.fool.qc/fadq"><feature:GEOM><gml:MultiSurface (
'http://sig.fool.qc/fadq" ) xmlns:gml="http://www.opengis.net/gml"
srsName="EPSG:32198"><gml:surfaceMember><gml:Polygon><gml:exterior><gml:LinearRing><gml:posList>-206413.01818846
292765.09570319 -206182.22900389 292089.51281744 -205745.8276367
292269.94799811 -205917.87048338 292479.75634772 -206413.01818846
292765.09570319</gml:posList></gml:LinearRing></gml:exterior></gml:Polygon></gml:surfaceMember></gml:MultiSurface></feature:GEOM></feature:SAGR_V3></wfs:Insert>
</wfs:Transaction>

In geoserver log:

Request: transaction
        handle = null
        service = WFS
        version = 1.1.0
        baseUrl = http://sig.fool.qc:80/geoserver/ (
http://mrsig.fadq.qc:80/geoserver/ )
        providedVersion = null
        lockId = null
        group =
[wfs:delete=net.opengis.wfs.impl.DeleteElementTypeImpl@anonymised.com (filter: [
SAGR_V3.17 ], handle: null, typeName: {http://sig.fool.qc/fadq\}SAGR_V3),
wfs:insert=net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com (feature:
[SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute: GEOM<GEOM
id=fid--20068e19_12592a87d6b_6e15>=MULTIPOLYGON (((-206413.01818846
292765.09570319, -206182.22900389 292089.51281744, -205745.8276367
292269.94799811, -205917.87048338 292479.75634772, -206413.01818846
292765.09570319))), SimpleFeatureImpl.Attribute: NAME<NAME
id=fid--20068e19_12592a87d6b_6e15>=null]], handle: null, idgen: <unset>,
inputFormat: <unset>, srsName: null)]
        insert = [net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com
(feature: [SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute:
GEOM<GEOM id=fid--20068e19_12592a87d6b_6e15>=MULTIPOLYGON
(((-206413.01818846 292765.09570319, -206182.22900389 292089.51281744,
-205745.8276367 292269.94799811, -205917.87048338 292479.75634772,
-206413.01818846 292765.09570319))), SimpleFeatureImpl.Attribute:
NAME<NAME id=fid--20068e19_12592a87d6b_6e15>=null]], handle: null, idgen:
<unset>, inputFormat: <unset>, srsName: null)]
        update =
        delete = [net.opengis.wfs.impl.DeleteElementTypeImpl@anonymised.com
(filter: [ SAGR_V3.17 ], handle: null, typeName:
{http://sig.fool.qc/fadq\}SAGR_V3)]
        native =
        releaseAction = ALL

org.geoserver.wfs.WFSException: Error performing insert
        at
org.geoserver.wfs.response.TransactionResponse.v_1_1(TransactionResponse.java:197)
        at
org.geoserver.wfs.response.TransactionResponse.write(TransactionResponse.java:67)
        at org.geoserver.ows.Dispatcher.response(Dispatcher.java:705)
        at
org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:213)
        at
org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
        at
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
        at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
        at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
        at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
        at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
        at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
        at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at
org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
        at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at
org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:73)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at
org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:47)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
        at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
        at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
        at
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
        at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
        at
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
        at java.lang.Thread.run(Thread.java:619)

If I remove the line delete it works:

<wfs:Transaction xmlns:wfs="http://www.opengis.net/wfs" service="WFS"
version="1.1.0" xsi:schemaLocation="http://www.opengis.net/wfs
http://schemas.opengis.net/wfs/1.1.0/wfs.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<wfs:Insert><feature:SAGR_V3
xmlns:feature="http://sig.fool.qc/fadq"><feature:GEOM><gml:MultiSurface (
'http://mrsig.fadq.qc/fadq" ) xmlns:gml="http://www.opengis.net/gml"
srsName="EPSG:32198"><gml:surfaceMember><gml:Polygon><gml:exterior><gml:LinearRing><gml:posList>-206413.01818846
292765.09570319 -206182.22900389 292089.51281744 -205745.8276367
292269.94799811 -205917.87048338 292479.75634772 -206413.01818846
292765.09570319</gml:posList></gml:LinearRing></gml:exterior></gml:Polygon></gml:surfaceMember></gml:MultiSurface></feature:GEOM></feature:SAGR_V3></wfs:Insert>
</wfs:Transaction>

In geoserver log:

Request: transaction
        handle = null
        service = WFS
        version = 1.1.0
        baseUrl = http://sig.fool.qc:80/geoserver/ (
http://sig.fool.qc:80/geoserver/ )
        providedVersion = null
        lockId = null
        group =
[wfs:insert=net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com (feature:
[SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute: GEOM<GEOM
id=fid--20068e19_12592a87d6b_6e17>=MULTIPOLYGON (((-206413.01818846
292765.09570319, -206182.22900389 292089.51281744, -205745.8276367
292269.94799811, -205917.87048338 292479.75634772, -206413.01818846
292765.09570319))), SimpleFeatureImpl.Attribute: NAME<NAME
id=fid--20068e19_12592a87d6b_6e17>=null]], handle: null, idgen: <unset>,
inputFormat: <unset>, srsName: null)]
        insert = [net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com
(feature: [SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute:
GEOM<GEOM id=fid--20068e19_12592a87d6b_6e17>=MULTIPOLYGON
(((-206413.01818846 292765.09570319, -206182.22900389 292089.51281744,
-205745.8276367 292269.94799811, -205917.87048338 292479.75634772,
-206413.01818846 292765.09570319))), SimpleFeatureImpl.Attribute:
NAME<NAME id=fid--20068e19_12592a87d6b_6e17>=null]], handle: null, idgen:
<unset>, inputFormat: <unset>, srsName: null)]
        update =
        delete =
        native =
        releaseAction = ALL

best regards,

Pat

------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and
easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
View this message in context: http://old.nabble.com/-WFS-T-and-Oracle--Error-performing-insert-tp26903498p26904932.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

Jukka_Rahkonen · December 23, 2009, 6:51pm

Hi,

I cannot say anything about OpenLayers, but if it is OL fault and nothing else helps try doing a bug report. WFS standard gives the order and clients should respect that.

-Jukka-

emptiness wrote:

Thanks..........
yes when i change the order, it work.
Now i search:
how to change the order in openlayers
Pat

Rahkonen Jukka wrote:

Hi,

We are doing these with Oracle NG and they do work for us. I am

remembering that the order must be insert-update-delete, have you checked
that?

-Jukka Rahkonen-

-----Alkuperäinen viesti-----
Lähettäjä: Patrick Mayrand [mailto:Patrick.Mayrand@anonymised.com]
Lähetetty: ke 23.12.2009 17:00
Vastaanottaja: geoserver-users@lists.sourceforge.net
Aihe: [Geoserver-users] [WFS-T and Oracle] Error performing insert

Hi,

Geoserver: stable 2.0

my wfs-t only works when I make one or more inserts or updates and deletes

but it does not work with inserts and updates or inserts and deletes.

Not Work:

<wfs:Transaction xmlns:wfs="http://www.opengis.net/wfs" service="WFS"
version="1.1.0" xsi:schemaLocation="http://www.opengis.net/wfs
http://schemas.opengis.net/wfs/1.1.0/wfs.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<wfs:Delete typeName="fadq:SAGR_V3"
xmlns:fadq="http://sig.fool.qc/fadq"><ogc:Filter (
'http://mrsig.fadq.qc/fadq" )
xmlns:ogc="http://www.opengis.net/ogc"><ogc:FeatureId (
'http://www.opengis.net/ogc" )
fid="SAGR_V3.17"/></ogc:Filter></wfs:Delete>
<wfs:Insert><feature:SAGR_V3
xmlns:feature="http://sig.fool.qc/fadq"><feature:GEOM><gml:MultiSurface (
'http://sig.fool.qc/fadq" ) xmlns:gml="http://www.opengis.net/gml"
srsName="EPSG:32198"><gml:surfaceMember><gml:Polygon><gml:exterior><gml:LinearRing><gml:posList>-206413.01818846
292765.09570319 -206182.22900389 292089.51281744 -205745.8276367
292269.94799811 -205917.87048338 292479.75634772 -206413.01818846
292765.09570319</gml:posList></gml:LinearRing></gml:exterior></gml:Polygon></gml:surfaceMember></gml:MultiSurface></feature:GEOM></feature:SAGR_V3></wfs:Insert>
</wfs:Transaction>

In geoserver log:

Request: transaction
        handle = null
        service = WFS
        version = 1.1.0
        baseUrl = http://sig.fool.qc:80/geoserver/ (
http://mrsig.fadq.qc:80/geoserver/ )
        providedVersion = null
        lockId = null
        group =
[wfs:delete=net.opengis.wfs.impl.DeleteElementTypeImpl@anonymised.com (filter: [
SAGR_V3.17 ], handle: null, typeName: {http://sig.fool.qc/fadq\}SAGR_V3),
wfs:insert=net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com (feature:
[SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute: GEOM<GEOM
id=fid--20068e19_12592a87d6b_6e15>=MULTIPOLYGON (((-206413.01818846
292765.09570319, -206182.22900389 292089.51281744, -205745.8276367
292269.94799811, -205917.87048338 292479.75634772, -206413.01818846
292765.09570319))), SimpleFeatureImpl.Attribute: NAME<NAME
id=fid--20068e19_12592a87d6b_6e15>=null]], handle: null, idgen: <unset>,
inputFormat: <unset>, srsName: null)]
        insert = [net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com
(feature: [SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute:
GEOM<GEOM id=fid--20068e19_12592a87d6b_6e15>=MULTIPOLYGON
(((-206413.01818846 292765.09570319, -206182.22900389 292089.51281744,
-205745.8276367 292269.94799811, -205917.87048338 292479.75634772,
-206413.01818846 292765.09570319))), SimpleFeatureImpl.Attribute:
NAME<NAME id=fid--20068e19_12592a87d6b_6e15>=null]], handle: null, idgen:
<unset>, inputFormat: <unset>, srsName: null)]
        update =
        delete = [net.opengis.wfs.impl.DeleteElementTypeImpl@anonymised.com
(filter: [ SAGR_V3.17 ], handle: null, typeName:
{http://sig.fool.qc/fadq\}SAGR_V3)]
        native =
        releaseAction = ALL

org.geoserver.wfs.WFSException: Error performing insert
        at
org.geoserver.wfs.response.TransactionResponse.v_1_1(TransactionResponse.java:197)
        at
org.geoserver.wfs.response.TransactionResponse.write(TransactionResponse.java:67)
        at org.geoserver.ows.Dispatcher.response(Dispatcher.java:705)
        at
org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:213)
        at
org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
        at
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
        at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
        at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
        at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
        at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
        at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
        at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at
org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
        at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at
org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:73)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at
org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:47)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
        at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
        at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
        at
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
        at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
        at
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
        at java.lang.Thread.run(Thread.java:619)

If I remove the line delete it works:

<wfs:Transaction xmlns:wfs="http://www.opengis.net/wfs" service="WFS"
version="1.1.0" xsi:schemaLocation="http://www.opengis.net/wfs
http://schemas.opengis.net/wfs/1.1.0/wfs.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<wfs:Insert><feature:SAGR_V3
xmlns:feature="http://sig.fool.qc/fadq"><feature:GEOM><gml:MultiSurface (
'http://mrsig.fadq.qc/fadq" ) xmlns:gml="http://www.opengis.net/gml"
srsName="EPSG:32198"><gml:surfaceMember><gml:Polygon><gml:exterior><gml:LinearRing><gml:posList>-206413.01818846
292765.09570319 -206182.22900389 292089.51281744 -205745.8276367
292269.94799811 -205917.87048338 292479.75634772 -206413.01818846
292765.09570319</gml:posList></gml:LinearRing></gml:exterior></gml:Polygon></gml:surfaceMember></gml:MultiSurface></feature:GEOM></feature:SAGR_V3></wfs:Insert>
</wfs:Transaction>

In geoserver log:

Request: transaction
        handle = null
        service = WFS
        version = 1.1.0
        baseUrl = http://sig.fool.qc:80/geoserver/ (
http://sig.fool.qc:80/geoserver/ )
        providedVersion = null
        lockId = null
        group =
[wfs:insert=net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com (feature:
[SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute: GEOM<GEOM
id=fid--20068e19_12592a87d6b_6e17>=MULTIPOLYGON (((-206413.01818846
292765.09570319, -206182.22900389 292089.51281744, -205745.8276367
292269.94799811, -205917.87048338 292479.75634772, -206413.01818846
292765.09570319))), SimpleFeatureImpl.Attribute: NAME<NAME
id=fid--20068e19_12592a87d6b_6e17>=null]], handle: null, idgen: <unset>,
inputFormat: <unset>, srsName: null)]
        insert = [net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com
(feature: [SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute:
GEOM<GEOM id=fid--20068e19_12592a87d6b_6e17>=MULTIPOLYGON
(((-206413.01818846 292765.09570319, -206182.22900389 292089.51281744,
-205745.8276367 292269.94799811, -205917.87048338 292479.75634772,
-206413.01818846 292765.09570319))), SimpleFeatureImpl.Attribute:
NAME<NAME id=fid--20068e19_12592a87d6b_6e17>=null]], handle: null, idgen:
<unset>, inputFormat: <unset>, srsName: null)]
        update =
        delete =
        native =
        releaseAction = ALL

best regards,

Pat

------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and
easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
View this message in context: http://old.nabble.com/-WFS-T-and-Oracle--Error-performing-insert-tp26903498p26904932.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Patrick_Mayrand · January 8, 2010, 1:07pm

Hi,

In openlayers mailing list:

http://openlayers.org/pipermail/users/2010-January/015641.html

Is this a GeoServer issue ??

regards,

Pat

emptiness wrote:

Hi,

Geoserver: stable 2.0

my wfs-t only works when I make one or more inserts or updates and deletes
but it does not work with inserts and updates or inserts and deletes.

Not Work:

<wfs:Transaction xmlns:wfs="http://www.opengis.net/wfs" service="WFS"
version="1.1.0" xsi:schemaLocation="http://www.opengis.net/wfs
http://schemas.opengis.net/wfs/1.1.0/wfs.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<wfs:Delete typeName="fadq:SAGR_V3"
xmlns:fadq="http://sig.fool.qc/fadq"><ogc:Filter (
'http://mrsig.fadq.qc/fadq" )
xmlns:ogc="http://www.opengis.net/ogc"><ogc:FeatureId (
'http://www.opengis.net/ogc" )
fid="SAGR_V3.17"/></ogc:Filter></wfs:Delete>
<wfs:Insert><feature:SAGR_V3
xmlns:feature="http://sig.fool.qc/fadq"><feature:GEOM><gml:MultiSurface (
'http://sig.fool.qc/fadq" ) xmlns:gml="http://www.opengis.net/gml"
srsName="EPSG:32198"><gml:surfaceMember><gml:Polygon><gml:exterior><gml:LinearRing><gml:posList>-206413.01818846
292765.09570319 -206182.22900389 292089.51281744 -205745.8276367
292269.94799811 -205917.87048338 292479.75634772 -206413.01818846
292765.09570319</gml:posList></gml:LinearRing></gml:exterior></gml:Polygon></gml:surfaceMember></gml:MultiSurface></feature:GEOM></feature:SAGR_V3></wfs:Insert>
</wfs:Transaction>

In geoserver log:

Request: transaction
        handle = null
        service = WFS
        version = 1.1.0
        baseUrl = http://sig.fool.qc:80/geoserver/ (
http://mrsig.fadq.qc:80/geoserver/ )
        providedVersion = null
        lockId = null
        group =
[wfs:delete=net.opengis.wfs.impl.DeleteElementTypeImpl@anonymised.com (filter: [
SAGR_V3.17 ], handle: null, typeName: {http://sig.fool.qc/fadq\}SAGR_V3),
wfs:insert=net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com (feature:
[SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute: GEOM<GEOM
id=fid--20068e19_12592a87d6b_6e15>=MULTIPOLYGON (((-206413.01818846
292765.09570319, -206182.22900389 292089.51281744, -205745.8276367
292269.94799811, -205917.87048338 292479.75634772, -206413.01818846
292765.09570319))), SimpleFeatureImpl.Attribute: NAME<NAME
id=fid--20068e19_12592a87d6b_6e15>=null]], handle: null, idgen: <unset>,
inputFormat: <unset>, srsName: null)]
        insert = [net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com
(feature: [SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute:
GEOM<GEOM id=fid--20068e19_12592a87d6b_6e15>=MULTIPOLYGON
(((-206413.01818846 292765.09570319, -206182.22900389 292089.51281744,
-205745.8276367 292269.94799811, -205917.87048338 292479.75634772,
-206413.01818846 292765.09570319))), SimpleFeatureImpl.Attribute:
NAME<NAME id=fid--20068e19_12592a87d6b_6e15>=null]], handle: null, idgen:
<unset>, inputFormat: <unset>, srsName: null)]
        update =
        delete = [net.opengis.wfs.impl.DeleteElementTypeImpl@anonymised.com
(filter: [ SAGR_V3.17 ], handle: null, typeName:
{http://sig.fool.qc/fadq\}SAGR_V3)]
        native =
        releaseAction = ALL

org.geoserver.wfs.WFSException: Error performing insert
        at
org.geoserver.wfs.response.TransactionResponse.v_1_1(TransactionResponse.java:197)
        at
org.geoserver.wfs.response.TransactionResponse.write(TransactionResponse.java:67)
        at org.geoserver.ows.Dispatcher.response(Dispatcher.java:705)
        at
org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:213)
        at
org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
        at
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
        at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
        at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
        at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
        at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
        at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
        at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at
org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
        at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at
org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:73)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at
org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:47)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
        at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
        at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
        at
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
        at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
        at
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
        at java.lang.Thread.run(Thread.java:619)

If I remove the line delete it works:

<wfs:Transaction xmlns:wfs="http://www.opengis.net/wfs" service="WFS"
version="1.1.0" xsi:schemaLocation="http://www.opengis.net/wfs
http://schemas.opengis.net/wfs/1.1.0/wfs.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<wfs:Insert><feature:SAGR_V3
xmlns:feature="http://sig.fool.qc/fadq"><feature:GEOM><gml:MultiSurface (
'http://mrsig.fadq.qc/fadq" ) xmlns:gml="http://www.opengis.net/gml"
srsName="EPSG:32198"><gml:surfaceMember><gml:Polygon><gml:exterior><gml:LinearRing><gml:posList>-206413.01818846
292765.09570319 -206182.22900389 292089.51281744 -205745.8276367
292269.94799811 -205917.87048338 292479.75634772 -206413.01818846
292765.09570319</gml:posList></gml:LinearRing></gml:exterior></gml:Polygon></gml:surfaceMember></gml:MultiSurface></feature:GEOM></feature:SAGR_V3></wfs:Insert>
</wfs:Transaction>

In geoserver log:

Request: transaction
        handle = null
        service = WFS
        version = 1.1.0
        baseUrl = http://sig.fool.qc:80/geoserver/ (
http://sig.fool.qc:80/geoserver/ )
        providedVersion = null
        lockId = null
        group =
[wfs:insert=net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com (feature:
[SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute: GEOM<GEOM
id=fid--20068e19_12592a87d6b_6e17>=MULTIPOLYGON (((-206413.01818846
292765.09570319, -206182.22900389 292089.51281744, -205745.8276367
292269.94799811, -205917.87048338 292479.75634772, -206413.01818846
292765.09570319))), SimpleFeatureImpl.Attribute: NAME<NAME
id=fid--20068e19_12592a87d6b_6e17>=null]], handle: null, idgen: <unset>,
inputFormat: <unset>, srsName: null)]
        insert = [net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com
(feature: [SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute:
GEOM<GEOM id=fid--20068e19_12592a87d6b_6e17>=MULTIPOLYGON
(((-206413.01818846 292765.09570319, -206182.22900389 292089.51281744,
-205745.8276367 292269.94799811, -205917.87048338 292479.75634772,
-206413.01818846 292765.09570319))), SimpleFeatureImpl.Attribute:
NAME<NAME id=fid--20068e19_12592a87d6b_6e17>=null]], handle: null, idgen:
<unset>, inputFormat: <unset>, srsName: null)]
        update =
        delete =
        native =
        releaseAction = ALL

best regards,

Pat

------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and
easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
View this message in context: http://old.nabble.com/-WFS-T-and-Oracle--Error-performing-insert-tp26903498p27075661.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

Jukka_Rahkonen · January 8, 2010, 1:51pm

Hi,

Schema says:

    <xsd:choice minOccurs="0" maxOccurs="unbounded">
            <xsd:element ref="wfs:Insert"/>
            <xsd:element ref="wfs:Update"/>
            <xsd:element ref="wfs:Delete"/>
            <xsd:element ref="wfs:Native"/>
         </xsd:choice>

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?

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

-Jukka Rahkonen-

-----Alkuperäinen viesti-----
Lähettäjä: emptiness [mailto:Patrick.Mayrand@anonymised.com]
Lähetetty: 8. tammikuuta 2010 15:07
Vastaanottaja: geoserver-users@lists.sourceforge.net
Aihe: Re: [Geoserver-users] [WFS-T and Oracle] Error performing insert

Hi,

In openlayers mailing list:

http://openlayers.org/pipermail/users/2010-January/015641.html

Is this a GeoServer issue ??

regards,

Pat

emptiness wrote:
>
> Hi,
>
> Geoserver: stable 2.0
>
> my wfs-t only works when I make one or more inserts or
updates and deletes
> but it does not work with inserts and updates or inserts
and deletes.
>
>
> Not Work:
>
> <wfs:Transaction xmlns:wfs="http://www.opengis.net/wfs"
service="WFS"
> version="1.1.0" xsi:schemaLocation="http://www.opengis.net/wfs
> http://schemas.opengis.net/wfs/1.1.0/wfs.xsd"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
> <wfs:Delete typeName="fadq:SAGR_V3"
> xmlns:fadq="http://sig.fool.qc/fadq"><ogc:Filter (
> 'http://mrsig.fadq.qc/fadq" )
> xmlns:ogc="http://www.opengis.net/ogc"><ogc:FeatureId (
> 'http://www.opengis.net/ogc" )
> fid="SAGR_V3.17"/></ogc:Filter></wfs:Delete>
> <wfs:Insert><feature:SAGR_V3
>
xmlns:feature="http://sig.fool.qc/fadq"><feature:GEOM><gml:Mul
tiSurface (
> 'http://sig.fool.qc/fadq" ) xmlns:gml="http://www.opengis.net/gml"
>
srsName="EPSG:32198"><gml:surfaceMember><gml:Polygon><gml:exte
rior><gml:LinearRing><gml:posList>-206413.01818846
> 292765.09570319 -206182.22900389 292089.51281744 -205745.8276367
> 292269.94799811 -205917.87048338 292479.75634772 -206413.01818846
>
292765.09570319</gml:posList></gml:LinearRing></gml:exterior><
/gml:Polygon></gml:surfaceMember></gml:MultiSurface></feature:
GEOM></feature:SAGR_V3></wfs:Insert>
> </wfs:Transaction>
>
> In geoserver log:
>
> Request: transaction
> handle = null
> service = WFS
> version = 1.1.0
> baseUrl = http://sig.fool.qc:80/geoserver/ (
> http://mrsig.fadq.qc:80/geoserver/ )
> providedVersion = null
> lockId = null
> group =
>
[wfs:delete=net.opengis.wfs.impl.DeleteElementTypeImpl@anonymised.com
e (filter: [
> SAGR_V3.17 ], handle: null, typeName:
{http://sig.fool.qc/fadq\}SAGR_V3),
>
wfs:insert=net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com
(feature:
> [SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute: GEOM<GEOM
> id=fid--20068e19_12592a87d6b_6e15>=MULTIPOLYGON (((-206413.01818846
> 292765.09570319, -206182.22900389 292089.51281744, -205745.8276367
> 292269.94799811, -205917.87048338 292479.75634772, -206413.01818846
> 292765.09570319))), SimpleFeatureImpl.Attribute: NAME<NAME
> id=fid--20068e19_12592a87d6b_6e15>=null]], handle: null,
idgen: <unset>,
> inputFormat: <unset>, srsName: null)]
> insert =
[net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com
> (feature: [SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute:
> GEOM<GEOM id=fid--20068e19_12592a87d6b_6e15>=MULTIPOLYGON
> (((-206413.01818846 292765.09570319, -206182.22900389
292089.51281744,
> -205745.8276367 292269.94799811, -205917.87048338 292479.75634772,
> -206413.01818846 292765.09570319))), SimpleFeatureImpl.Attribute:
> NAME<NAME id=fid--20068e19_12592a87d6b_6e15>=null]],
handle: null, idgen:
> <unset>, inputFormat: <unset>, srsName: null)]
> update =
> delete =
[net.opengis.wfs.impl.DeleteElementTypeImpl@anonymised.com
> (filter: [ SAGR_V3.17 ], handle: null, typeName:
> {http://sig.fool.qc/fadq\}SAGR_V3)]
> native =
> releaseAction = ALL
>
> org.geoserver.wfs.WFSException: Error performing insert
> at
>
org.geoserver.wfs.response.TransactionResponse.v_1_1(Transacti
onResponse.java:197)
> at
>
org.geoserver.wfs.response.TransactionResponse.write(Transacti
onResponse.java:67)
> at
org.geoserver.ows.Dispatcher.response(Dispatcher.java:705)
> at
>
org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.
java:213)
> at
>
org.springframework.web.servlet.mvc.AbstractController.handleR
equest(AbstractController.java:153)
> at
>
org.springframework.web.servlet.mvc.SimpleControllerHandlerAda
pter.handle(SimpleControllerHandlerAdapter.java:48)
> at
>
org.springframework.web.servlet.DispatcherServlet.doDispatch(D
ispatcherServlet.java:875)
> at
>
org.springframework.web.servlet.DispatcherServlet.doService(Di
spatcherServlet.java:809)
> at
>
org.springframework.web.servlet.FrameworkServlet.processReques
t(FrameworkServlet.java:571)
> at
>
org.springframework.web.servlet.FrameworkServlet.doPost(Framew
orkServlet.java:511)
> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilt
er(ApplicationFilterChain.java:269)
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli
cationFilterChain.java:188)
> at
>
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter
(SetCharacterEncodingFilter.java:108)
> at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilt
er(ApplicationFilterChain.java:215)
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli
cationFilterChain.java:188)
> at
>
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doF
ilter(FilterChainProxy.java:265)
> at
>
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invo
ke(FilterSecurityInterceptor.java:107)
> at
>
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFi
lter(FilterSecurityInterceptor.java:72)
> at
>
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doF
ilter(FilterChainProxy.java:275)
> at
>
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(Excep
tionTranslationFilter.java:124)
> at
>
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doF
ilter(FilterChainProxy.java:275)
> at
>
org.acegisecurity.providers.anonymous.AnonymousProcessingFilte
r.doFilter(AnonymousProcessingFilter.java:125)
> at
>
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doF
ilter(FilterChainProxy.java:275)
> at
>
org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(
BasicProcessingFilter.java:174)
> at
>
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doF
ilter(FilterChainProxy.java:275)
> at
>
org.acegisecurity.context.HttpSessionContextIntegrationFilter.
doFilter(HttpSessionContextIntegrationFilter.java:249)
> at
>
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doF
ilter(FilterChainProxy.java:275)
> at
>
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainPr
oxy.java:149)
> at
>
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBean
Proxy.java:98)
> at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilt
er(ApplicationFilterChain.java:215)
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli
cationFilterChain.java:188)
> at
> org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:73)
> at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilt
er(ApplicationFilterChain.java:215)
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli
cationFilterChain.java:188)
> at
>
org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxy
Filter.java:183)
> at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilt
er(ApplicationFilterChain.java:215)
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli
cationFilterChain.java:188)
> at
org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:47)
> at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilt
er(ApplicationFilterChain.java:215)
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli
cationFilterChain.java:188)
> at
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardW
rapperValve.java:213)
> at
>
org.apache.catalina.core.StandardContextValve.invoke(StandardC
ontextValve.java:172)
> at
>
org.apache.catalina.core.StandardHostValve.invoke(StandardHost
Valve.java:127)
> at
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport
Valve.java:117)
> at
>
org.apache.catalina.core.StandardEngineValve.invoke(StandardEn
gineValve.java:108)
> at
>
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdap
ter.java:174)
> at
>
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
> at
> org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
> at
> org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
> at
>
org.apache.jk.common.ChannelSocket.processConnection(ChannelSo
cket.java:703)
> at
>
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(Chan
nelSocket.java:895)
> at
>
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
ThreadPool.java:689)
> at java.lang.Thread.run(Thread.java:619)
>
>
>
> If I remove the line delete it works:
>
> <wfs:Transaction xmlns:wfs="http://www.opengis.net/wfs"
service="WFS"
> version="1.1.0" xsi:schemaLocation="http://www.opengis.net/wfs
> http://schemas.opengis.net/wfs/1.1.0/wfs.xsd"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
> <wfs:Insert><feature:SAGR_V3
>
xmlns:feature="http://sig.fool.qc/fadq"><feature:GEOM><gml:Mul
tiSurface (
> 'http://mrsig.fadq.qc/fadq" ) xmlns:gml="http://www.opengis.net/gml"
>
srsName="EPSG:32198"><gml:surfaceMember><gml:Polygon><gml:exte
rior><gml:LinearRing><gml:posList>-206413.01818846
> 292765.09570319 -206182.22900389 292089.51281744 -205745.8276367
> 292269.94799811 -205917.87048338 292479.75634772 -206413.01818846
>
292765.09570319</gml:posList></gml:LinearRing></gml:exterior><
/gml:Polygon></gml:surfaceMember></gml:MultiSurface></feature:
GEOM></feature:SAGR_V3></wfs:Insert>
> </wfs:Transaction>
>
> In geoserver log:
>
> Request: transaction
> handle = null
> service = WFS
> version = 1.1.0
> baseUrl = http://sig.fool.qc:80/geoserver/ (
> http://sig.fool.qc:80/geoserver/ )
> providedVersion = null
> lockId = null
> group =
>
[wfs:insert=net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com
(feature:
> [SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute: GEOM<GEOM
> id=fid--20068e19_12592a87d6b_6e17>=MULTIPOLYGON (((-206413.01818846
> 292765.09570319, -206182.22900389 292089.51281744, -205745.8276367
> 292269.94799811, -205917.87048338 292479.75634772, -206413.01818846
> 292765.09570319))), SimpleFeatureImpl.Attribute: NAME<NAME
> id=fid--20068e19_12592a87d6b_6e17>=null]], handle: null,
idgen: <unset>,
> inputFormat: <unset>, srsName: null)]
> insert = [net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com..
> (feature: [SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute:
> GEOM<GEOM id=fid--20068e19_12592a87d6b_6e17>=MULTIPOLYGON
> (((-206413.01818846 292765.09570319, -206182.22900389
292089.51281744,
> -205745.8276367 292269.94799811, -205917.87048338 292479.75634772,
> -206413.01818846 292765.09570319))), SimpleFeatureImpl.Attribute:
> NAME<NAME id=fid--20068e19_12592a87d6b_6e17>=null]],
handle: null, idgen:
> <unset>, inputFormat: <unset>, srsName: null)]
> update =
> delete =
> native =
> releaseAction = ALL
>
>
> best regards,
>
> Pat
>
>
>
--------------------------------------------------------------
----------------
> This SF.Net email is sponsored by the Verizon Developer Community
> Take advantage of Verizon's best-in-class app development support
> A streamlined, 14 day to market process makes app
distribution fast and
> easy
> Join now and get one step closer to millions of Verizon customers
> http://p.sf.net/sfu/verizon-dev2dev
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>

--
View this message in context:
http://old.nabble.com/-WFS-T-and-Oracle--Error-performing-inse
rt-tp26903498p27075661.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

--------------------------------------------------------------
----------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app
distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Andrea_Aime3 · January 11, 2010, 8:35am

Patrick Mayrand ha scritto:

Hi,
Geoserver: stable 2.0
my wfs-t only works when I make one or more inserts or updates and deletes but it does not work with inserts and updates or inserts and deletes.

There must be another exception in the log stating why the insert failed.
Gather that and open a ticket at jira.codehaus.org with a full report.

If you cannot any other exception related to the insert, please provide
a fully reproducable test case, that is, data and request, and attach it
to the jira issue.

Cheers
Andrea

--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

Jukka_Rahkonen · January 11, 2010, 8:55am

Hi,

In which order request are sent? Geoserver seems to take multiple
transactions only if they follow order insert/update/delete.

-Jukka Rahkonen-

Andrea Aime wrote:

Patrick Mayrand ha scritto:
> Hi,
>
> Geoserver: stable 2.0
>
> my wfs-t only works when I make one or more inserts or updates and
> deletes but it does not work with inserts and updates or
inserts and
> deletes.

There must be another exception in the log stating why the
insert failed.
Gather that and open a ticket at jira.codehaus.org with a full report.

If you cannot any other exception related to the insert,
please provide
a fully reproducable test case, that is, data and request,
and attach it
to the jira issue.

Cheers
Andrea

--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

--------------------------------------------------------------
----------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app
distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Andrea_Aime3 · January 11, 2010, 9:12am

Rahkonen Jukka ha scritto:

Hi,

In which order request are sent? Geoserver seems to take multiple
transactions only if they follow order insert/update/delete.

The code just loops over the elements it finds, there is no order
assumption. So the bug is triggering because of an unexpected
interaction.
To tell what that is I need to reproduce the problem locally

Cheers
Andrea

--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

Patrick_Mayrand · January 11, 2010, 2:23pm

Hi,

test with a rest client (http://rest-client.googlecode.com/files/restclient-ui-2.3-jar-with-dependencies.jar) in POST
Put a url
Check “POST” in tab “Method”
Put GML in tab “Body”

GEOSERVER 2.0.0:

oracle NG - Connect on oracle spatial
1 table with 2 columns = GEOM (Multipolygon) and Name (Sting)

URL:

http://mrsig.fadq.qc/geoserver/wfs

BODY:

not works:

<wfs:Transaction xmlns:wfs="http://www.opengis.net/wfs" service="WFS" version="1.1.0" xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/wfs.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<wfs:Delete typeName="fadq:SAGR_V3" xmlns:fadq="http://mrsig.fadq.qc/fadq"><ogc:Filter xmlns:ogc="http://www.opengis.net/ogc"><ogc:FeatureId fid="SAGR_V3.15"/></ogc:Filter></wfs:Delete>

<wfs:Insert><feature:SAGR_V3 xmlns:feature="http://mrsig.fadq.qc/fadq"><feature:GEOM><gml:MultiSurface xmlns:gml="http://www.opengis.net/gml" srsName="EPSG:32198"><gml:surfaceMember><gml:Polygon><gml:exterior><gml:LinearRing><gml:posList>-206601.84570313 290549.51953125 -204419.83886719 291086.62890625 -206064.73632813 291523.03027344 -206601.84570313 290549.51953125</gml:posList></gml:LinearRing></gml:exterior></gml:Polygon></gml:surfaceMember></gml:MultiSurface></feature:GEOM></feature:SAGR_V3></wfs:Insert>

</wfs:Transaction>

Log:

2010-01-11 08:45:24,773 ERROR [geoserver.wfs] - Transaction failed
org.geoserver.wfs.WFSTransactionException: Error performing insert
at org.geoserver.wfs.InsertElementHandler.execute(InsertElementHandler.java:204)
at org.geoserver.wfs.Transaction.execute(Transaction.java:334)
at org.geoserver.wfs.Transaction.transaction(Transaction.java:109)
at org.geoserver.wfs.DefaultWebFeatureService.transaction(DefaultWebFeatureService.java:163)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.geoserver.ows.util.EMFLogger.invoke(EMFLogger.java:51)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy19.transaction(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.geoserver.ows.Dispatcher.execute(Dispatcher.java:579)
at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:209)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:73)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.NullPointerException
at org.geotools.data.BatchFeatureEvent.add(BatchFeatureEvent.java:88)
at org.geotools.data.store.ContentState.fireFeatureEvent(ContentState.java:342)
at org.geotools.data.store.ContentState.fireFeatureAdded(ContentState.java:298)
at org.geotools.jdbc.JDBCInsertFeatureWriter.write(JDBCInsertFeatureWriter.java:81)
at org.geotools.data.InProcessLockingManager$1.write(InProcessLockingManager.java:335)
at org.geotools.data.store.ContentFeatureStore.addFeatures(ContentFeatureStore.java:255)
at org.vfny.geoserver.global.GeoServerFeatureStore.addFeatures(GeoServerFeatureStore.java:81)
at org.geoserver.wfs.InsertElementHandler.execute(InsertElementHandler.java:173)
… 71 more
2010-01-11 08:45:24,797 INFO [geoserver.wfs] -
Request: transaction
handle = null
service = WFS
version = 1.1.0
baseUrl = http://mrsig.fadq.qc:80/geoserver/
providedVersion = null
lockId = null
group = [wfs:delete=net.opengis.wfs.impl.DeleteElementTypeImpl@anonymised.com (filter: [ SAGR_V3.15 ], handle: null, typeName: {http://mrsig.fadq.qc/fadq}SAGR_V3), wfs:insert=net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com (feature: [SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute: GEOM=MULTIPOLYGON (((-206601.84570313 290549.51953125, -204419.83886719 291086.62890625, -206064.73632813 291523.03027344, -206601.84570313 290549.51953125))), SimpleFeatureImpl.Attribute: NAME=null]], handle: null, idgen: , inputFormat: , srsName: null)]
insert = [net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com (feature: [SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute: GEOM=MULTIPOLYGON (((-206601.84570313 290549.51953125, -204419.83886719 291086.62890625, -206064.73632813 291523.03027344, -206601.84570313 290549.51953125))), SimpleFeatureImpl.Attribute: NAME=null]], handle: null, idgen: , inputFormat: , srsName: null)]
update =
delete = [net.opengis.wfs.impl.DeleteElementTypeImpl@anonymised.com (filter: [ SAGR_V3.15 ], handle: null, typeName: {http://mrsig.fadq.qc/fadq}SAGR_V3)]
native =
releaseAction = ALL
2010-01-11 08:45:24,819 ERROR [geoserver.ows] -
org.geoserver.wfs.WFSException: Error performing insert
at org.geoserver.wfs.response.TransactionResponse.v_1_1(TransactionResponse.java:197)
at org.geoserver.wfs.response.TransactionResponse.write(TransactionResponse.java:67)
at org.geoserver.ows.Dispatcher.response(Dispatcher.java:705)
at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:213)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:73)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:619)

REST client log:

<ows:ExceptionReport version=“1.0.0”
xsi:schemaLocation=“http://www.opengis.net/ows http://mrsig.fadq.qc:80/geoserver/schemas/ows/1.0.0/owsExceptionReport.xsd”
xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance” xmlns:ows=“http://www.opengis.net/ows”>
<ows:Exception exceptionCode=“InvalidParameterValue”>
ows:ExceptionTextError performing insert</ows:ExceptionText>
</ows:Exception>
</ows:ExceptionReport>

works:

<wfs:Transaction xmlns:wfs="http://www.opengis.net/wfs" service="WFS" version="1.1.0" xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/wfs.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">


```
<wfs:Insert><feature:SAGR_V3 xmlns:feature="http://mrsig.fadq.qc/fadq"><feature:GEOM><gml:MultiSurface xmlns:gml="http://www.opengis.net/gml" srsName="EPSG:32198"><gml:surfaceMember><gml:Polygon><gml:exterior><gml:LinearRing><gml:posList>-206601.84570313 290549.51953125 -204419.83886719 291086.62890625 -206064.73632813 291523.03027344 -206601.84570313 290549.51953125</gml:posList></gml:LinearRing></gml:exterior></gml:Polygon></gml:surfaceMember></gml:MultiSurface></feature:GEOM></feature:SAGR_V3></wfs:Insert>
```

<wfs:Delete typeName="fadq:SAGR_V3" xmlns:fadq="http://mrsig.fadq.qc/fadq"><ogc:Filter xmlns:ogc="http://www.opengis.net/ogc"><ogc:FeatureId fid="SAGR_V3.15"/></ogc:Filter></wfs:Delete>

</wfs:Transaction>

**Logs:**

2010-01-11 09:06:17,005 INFO [geoserver.wfs] -
Request: transaction
        handle = null
        service = WFS
        version = 1.1.0
        baseUrl = [http://mrsig.fadq.qc:80/geoserver/](http://mrsig.fadq.qc:80/geoserver/)
        providedVersion = null
        lockId = null
        group = [wfs:insert=net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com (feature: [SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute: GEOM<GEOM id=fid--7a05802c_1261da1bd12_-7ffe>=MULTIPOLYGON (((-206601.84570313 290549.51953125, -204419.83886719 291086.62890625, -206064.73632813 291523.03027344, -206601.84570313 290549.51953125))), SimpleFeatureImpl.Attribute: NAME<NAME id=fid--7a05802c_1261da1bd12_-7ffe>=null]], handle: null, idgen: <unset>, inputFormat: <unset>, srsName: null), wfs:delete=net.opengis.wfs.impl.DeleteElementTypeImpl@anonymised.com (filter: [ SAGR_V3.15 ], handle: null, typeName: {http://mrsig.fadq.qc/fadq}SAGR_V3)]
        insert = [net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com (feature: [SimpleFeatureImpl:SAGR_V3=[SimpleFeatureImpl.Attribute: GEOM<GEOM id=fid--7a05802c_1261da1bd12_-7ffe>=MULTIPOLYGON (((-206601.84570313 290549.51953125, -204419.83886719 291086.62890625, -206064.73632813 291523.03027344, -206601.84570313 290549.51953125))), SimpleFeatureImpl.Attribute: NAME<NAME id=fid--7a05802c_1261da1bd12_-7ffe>=null]], handle: null, idgen: <unset>, inputFormat: <unset>, srsName: null)]
        update = []
        delete = [net.opengis.wfs.impl.DeleteElementTypeImpl@anonymised.com (filter: [ SAGR_V3.15 ], handle: null, typeName: {http://mrsig.fadq.qc/fadq}SAGR_V3)]
        native = []
        releaseAction = ALL

**REST client log:**

<wfs:TransactionResponse version="1.1.0" xsi:schemaLocation="[http://www.opengis.net/wfs](http://www.opengis.net/wfs) [http://mrsig.fadq.qc:80/geoserver/schemas/wfs/1.1.0/wfs.xsd](http://mrsig.fadq.qc:80/geoserver/schemas/wfs/1.1.0/wfs.xsd)" xmlns:fadq="[http://mrsig.fadq.qc/fadq](http://mrsig.fadq.qc/fadq)" xmlns:ogc="[http://www.opengis.net/ogc](http://www.opengis.net/ogc)" xmlns:tiger="[http://www.census.gov](http://www.census.gov)" xmlns:wfs="[http://www.opengis.net/wfs](http://www.opengis.net/wfs)" xmlns:topp="[http://www.openplans.org/topp](http://www.openplans.org/topp)" xmlns:xsi="[http://www.w3.org/2001/XMLSchema-instance](http://www.w3.org/2001/XMLSchema-instance)" xmlns:sf="[http://www.openplans.org/spearfish](http://www.openplans.org/spearfish)" xmlns:ows="[http://www.opengis.net/ows](http://www.opengis.net/ows)" xmlns:gml="[http://www.opengis.net/gml](http://www.opengis.net/gml)" xmlns:xlink="[http://www.w3.org/1999/xlink"><wfs:TransactionSummary><wfs:totalInserted>1</wfs:totalInserted><wfs:totalUpdated>0</wfs:totalUpdated><wfs:totalDeleted>1</wfs:totalDeleted></wfs:TransactionSummary><wfs:TransactionResults/><wfs:InsertResults><wfs:Feature><ogc:FeatureId](http://www.w3.org/1999/xlink"><wfs:TransactionSummary><wfs:totalInserted>1</wfs:totalInserted><wfs:totalUpdated>0</wfs:totalUpdated><wfs:totalDeleted>1</wfs:totalDeleted></wfs:TransactionSummary><wfs:TransactionResults/><wfs:InsertResults><wfs:Feature><ogc:FeatureId) fid="SAGR_V3.19"/></wfs:Feature></wfs:InsertResults></wfs:TransactionResponse>

thanks,

Pat

Andrea Aime aaime@anonymised.com 01/11/10 4:12 am >>>
Rahkonen Jukka ha scritto:
Hi,

In which order request are sent? Geoserver seems to take multiple
transactions only if they follow order insert/update/delete.

The code just loops over the elements it finds, there is no order
assumption. So the bug is triggering because of an unexpected
interaction.
To tell what that is I need to reproduce the problem locally

Cheers
Andrea

–
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

Andrea_Aime3 · January 11, 2010, 4:26pm

Patrick Mayrand ha scritto:

Hi,
test with a rest client (http://rest-client.googlecode.com/files/restclient-ui-2.3-jar-with-dependencies.jar) in POST
Put a url
Check "POST" in tab "Method"
Put GML in tab "Body"

Answered in the jira:
http://jira.codehaus.org/browse/GEOS-3763

Cheers
Andrea

--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.