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 <[email protected]> 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@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 <[email protected]> > 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 <[email protected]> >> 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 <[email protected]>: >>>> >>>> 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 <[email protected]> >>>> 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 _______________________________________________ Spanish mailing list http://lists.osgeo.org/mailman/listinfo/spanish http://es.osgeo.org http://twitter.com/osgeoes
