[Spanish] Editar WFST

Javier Diaz javidiaz1977 at gmail.com
Wed Jan 7 07:03:14 PST 2015 

Francisco te comento lo que hice:

- Copie la tabla al schema public en postgresql.
- La publique con geoserver 2.5.1
- Modifique mi codigo en Openlayers, con los datos correspondientes a
la nueva capa.

Y ahora si se guardaron los cambios:

<?xml version="1.0" encoding="UTF-8"?><wfs:TransactionResponse
xmlns:ssicc="lanus2" xmlns:ogc="http://www.opengis.net/ogc"
xmlns:wfs="http://www.opengis.net/wfs"
xmlns:ows="http://www.opengis.net/ows"
xmlns:xlink="http://www.w3.org/1999/xlink"
xmlns:gml="http://www.opengis.net/gml"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1.1.0"
xsi:schemaLocation="http://www.opengis.net/wfs
http://10.240.89.103:80/geoserver/schemas/wfs/1.1.0/wfs.xsd"><wfs:TransactionSummary><wfs:totalInserted>1</wfs:totalInserted><wfs:totalUpdated>0</wfs:totalUpdated><wfs:totalDeleted>0</wfs:totalDeleted></wfs:TransactionSummary><wfs:TransactionResults/><wfs:InsertResults><wfs:Feature><ogc:FeatureId
fid="parcelas_22175.107914"/></wfs:Feature></wfs:InsertResults></wfs:TransactionResponse>




El día 7 de enero de 2015, 11:47, Javier Diaz <javidiaz1977 en gmail.com> escribió:
> Aca dejo el log de geoserver:
>
> 2015-01-07 11:46:23,727 INFO [geoserver.wfs] -
> Request: transaction
>     service = WFS
>     version = 1.1.0
>     baseUrl = http://10.240.89.103:80/geoserver/
>     group[0] = wfs:insert=net.opengis.wfs.impl.InsertElementTypeImpl en 78d9234e
> (feature: [SimpleFeatureImpl:parcelas=[SimpleFeatureImpl.Attribute:
> id<id id=fid-694b1c11_14ac4d3c9bc_-7ffe>=null,
> SimpleFeatureImpl.Attribute: part<part
> id=fid-694b1c11_14ac4d3c9bc_-7ffe>=, SimpleFeatureImpl.Attribute:
> cir<cir id=fid-694b1c11_14ac4d3c9bc_-7ffe>=,
> SimpleFeatureImpl.Attribute: sec<sec
> id=fid-694b1c11_14ac4d3c9bc_-7ffe>=ZZ, SimpleFeatureImpl.Attribute:
> frac<frac id=fid-694b1c11_14ac4d3c9bc_-7ffe>=null,
> SimpleFeatureImpl.Attribute: fr_mza<fr_mza
> id=fid-694b1c11_14ac4d3c9bc_-7ffe>=, SimpleFeatureImpl.Attribute:
> parc<parc id=fid-694b1c11_14ac4d3c9bc_-7ffe>=,
> SimpleFeatureImpl.Attribute: sup_terren<sup_terren
> id=fid-694b1c11_14ac4d3c9bc_-7ffe>=null, SimpleFeatureImpl.Attribute:
> zonif<zonif id=fid-694b1c11_14ac4d3c9bc_-7ffe>=null,
> SimpleFeatureImpl.Attribute: zonif2<zonif2
> id=fid-694b1c11_14ac4d3c9bc_-7ffe>=null, SimpleFeatureImpl.Attribute:
> nom<nom id=fid-694b1c11_14ac4d3c9bc_-7ffe>=,
> SimpleFeatureImpl.Attribute: geom<geom
> id=fid-694b1c11_14ac4d3c9bc_-7ffe>=MULTIPOLYGON (((-6502548.515910238
> -4127588.7971872645, -6502533.192068559 -4127615.0101887877,
> -6502581.562917002 -4127609.6595273, -6502548.515910238
> -4127588.7971872645))), SimpleFeatureImpl.Attribute: tipo<tipo
> id=fid-694b1c11_14ac4d3c9bc_-7ffe>=5, SimpleFeatureImpl.Attribute:
> mza_letra<mza_letra id=fid-694b1c11_14ac4d3c9bc_-7ffe>=null]], handle:
> null, idgen: <unset>, inputFormat: <unset>, srsName: null)
>     insert[0]:
>         feature[0] =
> SimpleFeatureImpl:parcelas=[SimpleFeatureImpl.Attribute: id<id
> id=fid-694b1c11_14ac4d3c9bc_-7ffe>=null, SimpleFeatureImpl.Attribute:
> part<part id=fid-694b1c11_14ac4d3c9bc_-7ffe>=,
> SimpleFeatureImpl.Attribute: cir<cir
> id=fid-694b1c11_14ac4d3c9bc_-7ffe>=, SimpleFeatureImpl.Attribute:
> sec<sec id=fid-694b1c11_14ac4d3c9bc_-7ffe>=ZZ,
> SimpleFeatureImpl.Attribute: frac<frac
> id=fid-694b1c11_14ac4d3c9bc_-7ffe>=null, SimpleFeatureImpl.Attribute:
> fr_mza<fr_mza id=fid-694b1c11_14ac4d3c9bc_-7ffe>=,
> SimpleFeatureImpl.Attribute: parc<parc
> id=fid-694b1c11_14ac4d3c9bc_-7ffe>=, SimpleFeatureImpl.Attribute:
> sup_terren<sup_terren id=fid-694b1c11_14ac4d3c9bc_-7ffe>=null,
> SimpleFeatureImpl.Attribute: zonif<zonif
> id=fid-694b1c11_14ac4d3c9bc_-7ffe>=null, SimpleFeatureImpl.Attribute:
> zonif2<zonif2 id=fid-694b1c11_14ac4d3c9bc_-7ffe>=null,
> SimpleFeatureImpl.Attribute: nom<nom
> id=fid-694b1c11_14ac4d3c9bc_-7ffe>=, SimpleFeatureImpl.Attribute:
> geom<geom id=fid-694b1c11_14ac4d3c9bc_-7ffe>=MULTIPOLYGON
> (((-6502548.515910238 -4127588.7971872645, -6502533.192068559
> -4127615.0101887877, -6502581.562917002 -4127609.6595273,
> -6502548.515910238 -4127588.7971872645))),
> SimpleFeatureImpl.Attribute: tipo<tipo
> id=fid-694b1c11_14ac4d3c9bc_-7ffe>=5, SimpleFeatureImpl.Attribute:
> mza_letra<mza_letra id=fid-694b1c11_14ac4d3c9bc_-7ffe>=null]
>         idgen = GenerateNew
>         inputFormat = text/xml; subtype=gml/3.1.1
>     releaseAction = ALL
> 2015-01-07 11:46:23,727 ERROR [geoserver.ows] -
> org.geoserver.wfs.WFSException: Error performing insert: Error
> inserting features
>     at org.geoserver.wfs.response.TransactionResponse.v_1_1(TransactionResponse.java:195)
>     at org.geoserver.wfs.response.TransactionResponse.write(TransactionResponse.java:65)
>     at org.geoserver.ows.Dispatcher.response(Dispatcher.java:919)
>     at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:276)
>     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:923)
>     at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)
>     at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
>     at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
>     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
>     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
>     at org.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:27)
>     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
>     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
>     at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:74)
>     at org.geoserver.wms.animate.AnimatorFilter.doFilter(AnimatorFilter.java:70)
>     at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:70)
>     at org.geoserver.filters.SpringDelegatingFilter.doFilter(SpringDelegatingFilter.java:45)
>     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
>     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
>     at org.geoserver.platform.AdvancedDispatchFilter.doFilter(AdvancedDispatchFilter.java:49)
>     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
>     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
>     at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311)
>     at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:68)
>     at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
>     at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
>     at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:72)
>     at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91)
>     at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
>     at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:68)
>     at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
>     at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:72)
>     at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91)
>     at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
>     at org.geoserver.security.filter.GeoServerAnonymousAuthenticationFilter.doFilter(GeoServerAnonymousAuthenticationFilter.java:53)
>     at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
>     at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:68)
>     at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
>     at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:72)
>     at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91)
>     at org.geoserver.security.filter.GeoServerBasicAuthenticationFilter.doFilter(GeoServerBasicAuthenticationFilter.java:82)
>     at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
>     at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:68)
>     at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
>     at org.geoserver.security.filter.GeoServerSecurityContextPersistenceFilter$1.doFilter(GeoServerSecurityContextPersistenceFilter.java:52)
>     at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:72)
>     at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91)
>     at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
>     at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173)
>     at org.geoserver.security.GeoServerSecurityFilterChainProxy.doFilter(GeoServerSecurityFilterChainProxy.java:134)
>     at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
>     at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
>     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
>     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
>     at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:75)
>     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
>     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
>     at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:42)
>     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
>     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
>     at org.geoserver.filters.SessionDebugFilter.doFilter(SessionDebugFilter.java:47)
>     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
>     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
>     at org.geoserver.filters.FlushSafeFilter.doFilter(FlushSafeFilter.java:43)
>     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
>     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
>     at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109)
>     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
>     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
>     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
>     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
>     at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
>     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
>     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
>     at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
>     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
>     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>     at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
>     at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
>     at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
>     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>     at java.lang.Thread.run(Thread.java:745)
>
> El día 7 de enero de 2015, 11:38, Javier Diaz <javidiaz1977 en gmail.com> escribió:
>> Buen dia.
>>
>> Este es el Post en xml:
>>
>> XML
>> <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 lanus2
>> http://10.240.89.103/geoserver/ssicc/wfs?service=WFS&version=1.1.0&request=DescribeFeatureType&TypeName=ssicc:parcelas"
>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
>> <wfs:Insert>
>> <feature:parcelas xmlns:feature="lanus2">
>> <feature:geom>
>> <gml:MultiSurface xmlns:gml="http://www.opengis.net/gml" srsName="EPSG:900913">
>> <gml:surfaceMember>
>> <gml:Polygon>
>> <gml:exterior>
>> <gml:LinearRing>
>> <gml:posList>-6502548.515910238 -4127588.7971872645 -6502533.192068559
>> -4127615.0101887877 -6502581.562917002 -4127609.6595273
>> -6502548.515910238 -4127588.7971872645</gml:posList>
>> </gml:LinearRing>
>> </gml:exterior>
>> </gml:Polygon>
>> </gml:surfaceMember>
>> </gml:MultiSurface>
>> </feature:geom>
>> <feature:part></feature:part>
>> <feature:cir></feature:cir>
>> <feature:sec>ZZ</feature:sec>
>> <feature:fr_mza></feature:fr_mza>
>> <feature:mzan_letra></feature:mzan_letra>
>> <feature:nom></feature:nom>
>> <feature:tipo>5</feature:tipo>
>> <feature:parc></feature:parc>
>> </feature:parcelas>
>> </wfs:Insert>
>> </wfs:Transaction>
>>
>> Y esta la respuesta:
>>
>> <ows:ExceptionReport xmlns:ows="http://www.opengis.net/ows"
>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1.0.0"
>> xsi:schemaLocation="http://www.opengis.net/ows
>> http://10.240.89.103:80/geoserver/schemas/ows/1.0.0/owsExceptionReport.xsd">
>>   <ows:Exception exceptionCode="InvalidParameterValue">
>>     <ows:ExceptionText>Error performing insert: Error inserting
>> features</ows:ExceptionText>
>>   </ows:Exception>
>> </ows:ExceptionReport>
>>
>> Este mismo error lo habia tenido en otra maquina despues de actualizar
>> postgis a la 2.0 pero se soluciono corriendo el legacy.sql. En esta
>> ocasion no tuve la misma suerte.
>>
>>
>> El día 7 de enero de 2015, 4:16, Francisco B <fborja.manas en gmail.com> escribió:
>>> Hola Javier,
>>>
>>> Ten en cuenta que quien realiza la comunicación con la BD es Geoserver, por
>>> lo que entiendo que es la conexión Geoserver <--> BD la que deberá usar ese
>>> usuario con permisos que comentas. Otra cosa son los permisos que gestiones
>>> en Geoserver, en caso que de quieras proteger el acceso a WFST.
>>>
>>> Dicho lo cual, el error que te devuelve no parece que sea un problema de
>>> permisos, no? puedes ver la petición WFST que hace Open Layers usando
>>> Firebug, y analizar si los parámetros que le pasa...
>>>
>>> Un saludo.
>>>
>>>
>>> 2015-01-06 20:38 GMT+01:00 Javier Diaz <javidiaz1977 en gmail.com>:
>>>>
>>>> me pregunto en voz alta: deberia gestionar el usuario en GeoServer de
>>>> la misma manera que lo hice en la Base de Datos???
>>>>
>>>> El día 6 de enero de 2015, 16:18, Javier Diaz <javidiaz1977 en gmail.com>
>>>> escribió:
>>>> > Buenas tardes lista, si otra vez yo....tenerme paciencia ;)
>>>> >
>>>> > Estoy tratando de editar una capa (publicada con geoserver 2.5.1)
>>>> > mediante un servicio WFST (en Openlayers).
>>>> > Cuando creo el nuevo feature e intento salvarlo me da este error:
>>>> >
>>>> > <ows:ExceptionReport xmlns:ows="http://www.opengis.net/ows"
>>>> > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1.0.0"
>>>> > xsi:schemaLocation="http://www.opengis.net/ows
>>>> >
>>>> > http://10.240.89.103:80/geoserver/schemas/ows/1.0.0/owsExceptionReport.xsd">
>>>> >   <ows:Exception exceptionCode="InvalidParameterValue">
>>>> >     <ows:ExceptionText>Error performing insert: Error inserting
>>>> > features</ows:ExceptionText>
>>>> >   </ows:Exception>
>>>> > </ows:ExceptionReport>
>>>> >
>>>> > NOTA: la tabla postgis esta en un schema donde solo tiene privilegio
>>>> > un determinado role. Como hago para decirle que quien esta intentando
>>>> > editar desde el visor de OpenLayers, es ese usuario autorizado?
>>>> >
>>>> >
>>>> > Saludos
>>>> > Javier
>>>> _______________________________________________
>>>> Spanish mailing list
>>>> http://lists.osgeo.org/mailman/listinfo/spanish
>>>> http://es.osgeo.org
>>>> http://twitter.com/osgeoes
>>>
>>>
>>>
>>> _______________________________________________
>>> Spanish mailing list
>>> http://lists.osgeo.org/mailman/listinfo/spanish
>>> http://es.osgeo.org
>>> http://twitter.com/osgeoes

More information about the Spanish mailing list