[OpenLayers-Users] Rép. : Re: [WFS] Error insert in geoserver

Thu Jan 7 08:31:15 EST 2010

Thanks,

Log in geoserver:

Request: transaction 
        handle = null 
        service = WFS 
        version = 1.1.0 
        baseUrl = http://sig.fool.qc:80/geoserver/ ( http://sig.fool.qc/geoserver/ ) ( http://sig.fool.qc:80/geoserver/ ) 
        providedVersion = null 
        lockId = null 
        group = [wfs:delete=net.opengis.wfs.impl.DeleteElementTypeImpl at 3028e92e (filter: [ SAGR_V3.17 ], handle: null, typeName: {http://sig.fool.qc/fadq}SAGR_V3), wfs:insert=net.opengis.wfs.impl.InsertElementTypeImpl at 4de4e3b5 (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 at 4de4e3b5 (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 at 3028e92e (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.
If i put the line delete in last, it works.
If i put only the line insert, it works.

regards,

Pat

>>> Andreas Hocevar <ahocevar at opengeo.org> 01/07/10 3:26 am >>>
Hi,

I do not see how the request below would make any difference if the
order was changed. According to the schema, the Transaction children are
a 0..* choice, not a sequence.

Can you please also paste the server response to the failing transaction
request?

Regards,
Andreas.

The only problem I see with the xml you pasted is that the
On 2010-01-06 22:34, Patrick Mayrand wrote:
> Hi,
>  
> with OL i use the edition of polygon. A transaction with several
> operation does not work
>  
> GML generate by Openlayers:
>  
> <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" ( '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>
>  
>  
> The order is:
>  
> DELETE - INSERT
>  
>  
> but the order should be reversed and it works
>  
> INSERT - DELETE
>  
>  
> It this normal?? a bug??
>  
>  
> regards,
>  
>  
> Pat
>
>
> _______________________________________________
> Users mailing list
> Users at openlayers.org 
> http://openlayers.org/mailman/listinfo/users 
>   

-- 
Andreas Hocevar
OpenGeo - http://opengeo.org/ 
Expert service straight from the developers.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/openlayers-users/attachments/20100107/75b0da7f/attachment.html