Hi list, Once I managed to get working inserting and deleting geometries I'm on the task of making updating work. Both options, alphanumeric and geometry modification, are required. I send the following update request:
<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://192.168.3.15/ikt http://192.168.3.15/geoserver/wfs?request=DescribeFeatureType&version=1.1.0&typename=IKT:UnidadesGestion"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";> <wfs:Update typeName="feature:UnidadesGestion" xmlns:feature="http://192.168.3.15/ikt";> <wfs:Property> <wfs:Name>GEOMETRY</wfs:Name> <wfs:Value> <gml:Polygon xmlns:gml="http://www.opengis.net/gml"; srsName="EPSG:23030"> <gml:exterior> <gml:LinearRing> <gml:posList>...</gml:posList> </gml:LinearRing> </gml:exterior> </gml:Polygon> </wfs:Value> </wfs:Property> <wfs:Property> <wfs:Name>GID</wfs:Name> <wfs:Value>104</wfs:Value> </wfs:Property> <wfs:Property> <wfs:Name>CODEX</wfs:Name> <wfs:Value>010130050002</wfs:Value> </wfs:Property> <wfs:Property> <wfs:Name>UG</wfs:Name> <wfs:Value>13</wfs:Value> </wfs:Property> <wfs:Property> <wfs:Name>VERSION</wfs:Name> <wfs:Value>1</wfs:Value> </wfs:Property> <wfs:Property> <wfs:Name>TOPONIMO</wfs:Name> <wfs:Value>UG_13</wfs:Value> </wfs:Property> <wfs:Property> <wfs:Name>PROVINCIA</wfs:Name> <wfs:Value>1</wfs:Value> </wfs:Property> <wfs:Property> <wfs:Name>MUNICIPIO</wfs:Name> <wfs:Value>13</wfs:Value> </wfs:Property> <wfs:Property> <wfs:Name>AGREGADO</wfs:Name> <wfs:Value>0</wfs:Value> </wfs:Property> <wfs:Property> <wfs:Name>ZONA</wfs:Name> <wfs:Value>0</wfs:Value> </wfs:Property> <wfs:Property> <wfs:Name>POLIGONO</wfs:Name> <wfs:Value>3</wfs:Value> </wfs:Property> <wfs:Property> <wfs:Name>PARCELA</wfs:Name> <wfs:Value>481</wfs:Value> </wfs:Property> <wfs:Property> <wfs:Name>RECINTO</wfs:Name> <wfs:Value>6</wfs:Value> </wfs:Property> <wfs:Property> <wfs:Name>CONUSUCOD</wfs:Name> <wfs:Value>lursail</wfs:Value> </wfs:Property> <wfs:Property> <wfs:Name>CONMODFEC</wfs:Name> <wfs:Value>09-ago-2011</wfs:Value> </wfs:Property> <ogc:Filter xmlns:ogc="http://www.opengis.net/ogc";> <ogc:FeatureId fid="UnidadesGestion.103"></ogc:FeatureId> </ogc:Filter> </wfs:Update> </wfs:Transaction> And I get the following error response: 2011-08-29 08:21:35,687 TRACE [org.geotools.core] - condition: Filter.INCLUDE 2011-08-29 08:21:35,687 DEBUG [org.geotools.jdbc] - CREATE CONNECTION 2011-08-29 08:21:35,687 TRACE [org.geotools.core] - ENTRY 22 2011-08-29 08:21:35,687 DEBUG [org.geotools.jdbc] - SELECT GID,CODEX,UG,VERSION,TOPONIMO,PROVINCIA,MUNICIPIO,AGREGADO,ZONA,POLIGONO,PARCELA,RECINTO,PARCELA_AG,CONUSUCOD,CONMODFEC,GRUPO,GEOMETRY as GEOMETRY FROM USRCARTO.GT_ARLOGIS_UG_ED50 WHERE (GID = ?) 2011-08-29 08:21:35,703 DEBUG [org.geotools.jdbc] - 1 = 103 2011-08-29 08:21:35,703 INFO [org.geoserver.gwc.GWCCleanser] - Deleting GWC cache for IKT:UnidadesGestion 2011-08-29 08:21:35,703 TRACE [org.geotools.core] - ENTRY 22 2011-08-29 08:21:35,703 DEBUG [org.geotools.jdbc] - SELECT GID,CODEX,UG,VERSION,TOPONIMO,PROVINCIA,MUNICIPIO,AGREGADO,ZONA,POLIGONO,PARCELA,RECINTO,PARCELA_AG,CONUSUCOD,CONMODFEC,GRUPO,GEOMETRY as GEOMETRY FROM USRCARTO.GT_ARLOGIS_UG_ED50 WHERE (GID = ?) 2011-08-29 08:21:35,703 DEBUG [org.geotools.jdbc] - 1 = 103 2011-08-29 08:21:35,703 TRACE [org.geotools.core] - ENTRY 22 2011-08-29 08:21:35,703 DEBUG [org.geotools.jdbc] - Updating features with prepared statement: UPDATE USRCARTO.GT_ARLOGIS_UG_ED50 SET GEOMETRY = ?,CODEX = ?,UG = ?,VERSION = ?,TOPONIMO = ?,PROVINCIA = ?,MUNICIPIO = ?,AGREGADO = ?,ZONA = ?,POLIGONO = ?,PARCELA = ?,RECINTO = ?,CONUSUCOD = ?,CONMODFEC = ? WHERE (GID = ?) 2011-08-29 08:21:35,703 TRACE [org.geotools.data.oracle.sdo] - ordinates D:2 2011-08-29 08:21:35,703 TRACE [org.geotools.data.oracle.sdo] - ordinates L:0 2011-08-29 08:21:35,718 INFO [org.geoserver.gwc.GWCCleanser] - GWC cache for IKT:UnidadesGestion deleted successfully 2011-08-29 08:21:35,734 DEBUG [org.geotools.data.oracle.sdo] - Using layer SRID: 82337 2011-08-29 08:21:35,734 DEBUG [org.geotools.jdbc] - Setting parameter 1 as MDSYS.SDO_GEOMETRY(2003,82337,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(542216.31591797,4748814.04248047,542216.28972476,4748813.84688567,542200.58086508,4748820.57352164,542196.9625809,4748822.38507369,542192.22516798,4748824.75757372,542186.22449539,4748827.75529862,542182.42511197,4748831.19472488,542179.5618309,4748833.78352006,542176.80178968,4748836.27986538,542166.03220318,4748841.21243124,542155.67490729,4748843.65287875,542150.78073412,4748844.80503932,542137.76901441,4748844.79973343,542127.45126087,4748847.49179368,542110.84715069,4748857.3687093,542109.20888496,4748858.87594993,542094.57454906,4748872.35803089,542093.79674258,4748873.07001813,542082.60047153,4748878.40036373,542074.95319467,4748882.04900404,542052.0660327,4748885.185525,542039.81161435,4748885.59460792,542038.60671716,4748885.63378137,542020.2138498,4748878.0094084,541998.67244229,4748872.618491,541966.36974969,4748866.34279196,541946.62701146,4748862.30343564,541946.55964653,4748862.12616417,541941.67252765,4748849.79058353,541942.42669678,4748848.46411133,541950.85528565,4748831.2019043,541955.88287354,4748820.52789307,541959.51867676,4748810.2177124,541965.34631348,4748788.45288086,541975.26971436,4748742.72528076,541982.57769775,4748710.60913086,541984.38189697,4748704.35571289,541985.69873047,4748700.53790283,541986.80749512,4748698.31988525,541987.73309326,4748696.94787598,541987.9816734,4748696.58639749,541989.01947021,4748695.89471436,541992.85107422,4748695.03369141,542003.84631348,4748692.40148926,542014.77752686,4748689.04272461,542025.03448486,4748685.121521,542034.05651856,4748680.55969238,542040.78167725,4748676.61669922,542046.33612061,4748672.74108887,542056.16271973,4748665.33587647,542069.44732666,4748654.35870361,542078.51330566,4748645.97149658,542091.99188232,4748633.48748779,542145.96307373,4748577.82788086,542188.1038715,4748533.77825123,542216.37207031,4748503.95068359,542216.53742859,4748503.78416598,542218.51646482,4748504.75505959,542221.85383917,4748506.35799044,542223.38756642,4748507.40064708,542224.85723201,4748508.84317361,542232.33444062,4748517.35978477,542235.58250309,4748521.24274215,542235.60965337,4748521.28014272,542239.36586407,4748526.01329209,542240.51370478,4748527.47246167,542245.48241961,4748534.27953886,542247.53008294,4748537.45699262,542254.01888161,4748547.52206447,542255.48828253,4748550.11884315,542257.631627,4748554.4325183,542257.9632993,4748555.03960584,542259.87199634,4748558.55131329,542260.80967927,4748560.79110383,542262.3473855,4748564.5239341,542263.55448403,4748568.58983623,542264.42762128,4748572.42097438,542265.52228339,4748576.96091633,542266.553396,4748581.81695488,542267.18725176,4748585.60008014,542267.83879084,4748592.07345451,542268.26415677,4748596.36726251,542268.31887953,4748600.82634366,542268.82639163,4748607.34537499,542269.04662169,4748612.71770141,542269.80500379,4748618.5122168,542270.71606107,4748625.08027201,542272.87132502,4748638.58146101,542274.79813161,4748652.50012621,542276.38531602,4748661.5390785,542276.70269775,4748663.35632324,542264.00189209,4748672.85650635,542261.02252197,4748675.38867188,542257.4307251,4748678.43847656,542255.29272461,4748679.93328857,542250.19207764,4748683.48571777,542247.90297073,4748685.06327845,542243.40912494,4748686.76703302,542238.84837972,4748688.21905145,542231.50330222,4748690.53826963,542227.95077429,4748691.66138506,542211.97858757,4748692.17764749,542201.67708961,4748692.17955852,542191.11232348,4748696.04287349,542185.64422742,4748698.12233246,542178.23455112,4748700.93455832,542169.47155454,4748701.19728515,542157.88323396,4748701.20067645,542157.34205596,4748701.27182519,542149.12080561,4748702.48736146,542145.96534006,4748703.60364511,542144.74432427,4748704.03365617,542145.51620992,4748707.64075601,542150.66616993,4748709.44093564,542163.80505289,4748709.95900692,542178.49035772,4748709.44404567,542194.98011676,4748703.77400467,542211.72629635,4748697.59361299,542231.04613836,4748698.10322677,542244.5993161,4748701.37929712,542245.98676264,4748701.71361899,542250.62588825,4748708.6676132,542253.45686966,4748720.25541103,542251.90926229,4748729.27509103,542251.6715132,4748730.09277297,542248.55933107,4748740.87144233,542250.80409602,4748750.94766874,542251.13705426,4748752.45768344,542251.91147363,4748754.52891828,542252.7532959,4748756.76812744,542250.89630127,4748761.57849121,542245.33190918,4748775.98168945,542237.57391357,4748790.92071533,542231.77270508,4748800.45410156,542228.42852783,4748804.4362793,542228.34588623,4748804.5100708,542223.23272705,4748809.00268555,542217.02392578,4748813.56292725,542216.31591797,4748814.04248047)) 2011-08-29 08:21:35,812 DEBUG [org.geotools.jdbc] - 1 = POLYGON ((542216.31591797 4748814.04248047, 542216.28972476 4748813.84688567, 542200.58086508 4748820.57352164, 542196.9625809 4748822.38507369, 542192.22516798 4748824.75757372, 542186.22449539 4748827.75529862, 542182.42511197 4748831.19472488, 542179.5618309 4748833.78352006, 542176.80178968 4748836.27986538, 542166.03220318 4748841.21243124, 542155.67490729 4748843.65287875, 542150.78073412 4748844.80503932, 542137.76901441 4748844.79973343, 542127.45126087 4748847.49179368, 542110.84715069 4748857.3687093, 542109.20888496 4748858.87594993, 542094.57454906 4748872.35803089, 542093.79674258 4748873.07001813, 542082.60047153 4748878.40036373, 542074.95319467 4748882.04900404, 542052.0660327 4748885.185525, 542039.81161435 4748885.59460792, 542038.60671716 4748885.63378137, 542020.2138498 4748878.0094084, 541998.67244229 4748872.618491, 541966.36974969 4748866.34279196, 541946.62701146 4748862.30343564, 541946.55964653 4748862.12616417, 541941.67252765 4748849.79058353, 541942.42669678 4748848.46411133, 541950.85528565 4748831.2019043, 541955.88287354 4748820.52789307, 541959.51867676 4748810.2177124, 541965.34631348 4748788.45288086, 541975.26971436 4748742.72528076, 541982.57769775 4748710.60913086, 541984.38189697 4748704.35571289, 541985.69873047 4748700.53790283, 541986.80749512 4748698.31988525, 541987.73309326 4748696.94787598, 541987.9816734 4748696.58639749, 541989.01947021 4748695.89471436, 541992.85107422 4748695.03369141, 542003.84631348 4748692.40148926, 542014.77752686 4748689.04272461, 542025.03448486 4748685.121521, 542034.05651856 4748680.55969238, 542040.78167725 4748676.61669922, 542046.33612061 4748672.74108887, 542056.16271973 4748665.33587647, 542069.44732666 4748654.35870361, 542078.51330566 4748645.97149658, 542091.99188232 4748633.48748779, 542145.96307373 4748577.82788086, 542188.1038715 4748533.77825123, 542216.37207031 4748503.95068359, 542216.53742859 4748503.78416598, 542218.51646482 4748504.75505959, 542221.85383917 4748506.35799044, 542223.38756642 4748507.40064708, 542224.85723201 4748508.84317361, 542232.33444062 4748517.35978477, 542235.58250309 4748521.24274215, 542235.60965337 4748521.28014272, 542239.36586407 4748526.01329209, 542240.51370478 4748527.47246167, 542245.48241961 4748534.27953886, 542247.53008294 4748537.45699262, 542254.01888161 4748547.52206447, 542255.48828253 4748550.11884315, 542257.631627 4748554.4325183, 542257.9632993 4748555.03960584, 542259.87199634 4748558.55131329, 542260.80967927 4748560.79110383, 542262.3473855 4748564.5239341, 542263.55448403 4748568.58983623, 542264.42762128 4748572.42097438, 542265.52228339 4748576.96091633, 542266.553396 4748581.81695488, 542267.18725176 4748585.60008014, 542267.83879084 4748592.07345451, 542268.26415677 4748596.36726251, 542268.31887953 4748600.82634366, 542268.82639163 4748607.34537499, 542269.04662169 4748612.71770141, 542269.80500379 4748618.5122168, 542270.71606107 4748625.08027201, 542272.87132502 4748638.58146101, 542274.79813161 4748652.50012621, 542276.38531602 4748661.5390785, 542276.70269775 4748663.35632324, 542264.00189209 4748672.85650635, 542261.02252197 4748675.38867188, 542257.4307251 4748678.43847656, 542255.29272461 4748679.93328857, 542250.19207764 4748683.48571777, 542247.90297073 4748685.06327845, 542243.40912494 4748686.76703302, 542238.84837972 4748688.21905145, 542231.50330222 4748690.53826963, 542227.95077429 4748691.66138506, 542211.97858757 4748692.17764749, 542201.67708961 4748692.17955852, 542191.11232348 4748696.04287349, 542185.64422742 4748698.12233246, 542178.23455112 4748700.93455832, 542169.47155454 4748701.19728515, 542157.88323396 4748701.20067645, 542157.34205596 4748701.27182519, 542149.12080561 4748702.48736146, 542145.96534006 4748703.60364511, 542144.74432427 4748704.03365617, 542145.51620992 4748707.64075601, 542150.66616993 4748709.44093564, 542163.80505289 4748709.95900692, 542178.49035772 4748709.44404567, 542194.98011676 4748703.77400467, 542211.72629635 4748697.59361299, 542231.04613836 4748698.10322677, 542244.5993161 4748701.37929712, 542245.98676264 4748701.71361899, 542250.62588825 4748708.6676132, 542253.45686966 4748720.25541103, 542251.90926229 4748729.27509103, 542251.6715132 4748730.09277297, 542248.55933107 4748740.87144233, 542250.80409602 4748750.94766874, 542251.13705426 4748752.45768344, 542251.91147363 4748754.52891828, 542252.7532959 4748756.76812744, 542250.89630127 4748761.57849121, 542245.33190918 4748775.98168945, 542237.57391357 4748790.92071533, 542231.77270508 4748800.45410156, 542228.42852783 4748804.4362793, 542228.34588623 4748804.5100708, 542223.23272705 4748809.00268555, 542217.02392578 4748813.56292725, 542216.31591797 4748814.04248047)) 2011-08-29 08:21:35,812 DEBUG [org.geotools.jdbc] - 3 = 010130050002 2011-08-29 08:21:35,812 DEBUG [org.geotools.jdbc] - 4 = 13 2011-08-29 08:21:35,812 DEBUG [org.geotools.jdbc] - 5 = 1 2011-08-29 08:21:35,812 DEBUG [org.geotools.jdbc] - 6 = UG_13 2011-08-29 08:21:35,812 DEBUG [org.geotools.jdbc] - 7 = 1 2011-08-29 08:21:35,812 DEBUG [org.geotools.jdbc] - 8 = 13 2011-08-29 08:21:35,812 DEBUG [org.geotools.jdbc] - 9 = 0 2011-08-29 08:21:35,812 DEBUG [org.geotools.jdbc] - 10 = 0 2011-08-29 08:21:35,812 DEBUG [org.geotools.jdbc] - 11 = 3 2011-08-29 08:21:35,812 DEBUG [org.geotools.jdbc] - 12 = 481 2011-08-29 08:21:35,812 DEBUG [org.geotools.jdbc] - 13 = 6 2011-08-29 08:21:35,812 DEBUG [org.geotools.jdbc] - 14 = lursail 2011-08-29 08:21:35,812 DEBUG [org.geotools.jdbc] - 15 = 09-ago-2011 2011-08-29 08:21:35,812 ERROR [org.geoserver.wfs] - Transaction failed org.geoserver.wfs.WFSTransactionException: update error at org.geoserver.wfs.UpdateElementHandler.execute(UpdateElementHandler.java:246) 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(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) 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(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.geoserver.ows.Dispatcher.execute(Dispatcher.java:599) at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:230) 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:647) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) 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.coyote.http11.Http11Processor.process(Http11Processor.java:879) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.RuntimeException: java.sql.SQLException: Invalid column index at org.geotools.jdbc.JDBCDataStore.update(JDBCDataStore.java:1309) at org.geotools.jdbc.JDBCFeatureStore.modifyFeatures(JDBCFeatureStore.java:354) at org.geoserver.feature.retype.RetypingFeatureStore.modifyFeatures(RetypingFeatureStore.java:76) at org.vfny.geoserver.global.GeoServerFeatureStore.modifyFeatures(GeoServerFeatureStore.java:113) at org.geoserver.wfs.UpdateElementHandler.execute(UpdateElementHandler.java:238) ... 70 more Caused by: java.sql.SQLException: Invalid column index at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208) at oracle.jdbc.driver.OraclePreparedStatement.setBigDecimalInternal(OraclePreparedStatement.java:5227) at oracle.jdbc.driver.OraclePreparedStatement.setBigDecimal(OraclePreparedStatement.java:5219) at org.apache.commons.dbcp.DelegatingPreparedStatement.setBigDecimal(DelegatingPreparedStatement.java:129) at org.apache.commons.dbcp.DelegatingPreparedStatement.setBigDecimal(DelegatingPreparedStatement.java:129) at org.geotools.jdbc.PreparedStatementSQLDialect.setValue(PreparedStatementSQLDialect.java:135) at org.geotools.jdbc.JDBCDataStore.setPreparedFilterValues(JDBCDataStore.java:2836) at org.geotools.jdbc.JDBCDataStore.updateSQLPS(JDBCDataStore.java:3621) at org.geotools.jdbc.JDBCDataStore.update(JDBCDataStore.java:1300) ... 74 more 2011-08-29 08:21:35,828 INFO [org.geoserver.wfs] - Request: transaction handle = null service = WFS version = 1.1.0 baseUrl = http://192.168.3.15:80/geoserver/ providedVersion = null lockId = null group = [wfs:update=net.opengis.wfs.impl.UpdateElementTypeImpl@26f4a3a1 (filter: [ UnidadesGestion.103 ], handle: null, inputFormat: <unset>, srsName: null, typeName: {http://192.168.3.15/ikt}UnidadesGestion)] insert = [] update = [net.opengis.wfs.impl.UpdateElementTypeImpl@26f4a3a1 (filter: [ UnidadesGestion.103 ], handle: null, inputFormat: <unset>, srsName: null, typeName: {http://192.168.3.15/ikt}UnidadesGestion)] delete = [] native = [] releaseAction = ALL My describe feature document is as follows: <xsd:schema elementFormDefault="qualified" targetNamespace="http://192.168.3.15/ikt";> <xsd:import namespace="http://www.opengis.net/gml"; schemaLocation="http://192.168.3.15:80/geoserver/schemas/gml/3.1.1/base/gml.xsd"/> <xsd:complexType name="UnidadesGestionType"> <xsd:complexContent> <xsd:extension base="gml:AbstractFeatureType"> <xsd:sequence> <xsd:element maxOccurs="1" minOccurs="0" name="GID" nillable="true" type="xsd:decimal"/> <xsd:element maxOccurs="1" minOccurs="0" name="CODEX" nillable="true" type="xsd:string"/> <xsd:element maxOccurs="1" minOccurs="0" name="UG" nillable="true" type="xsd:decimal"/> <xsd:element maxOccurs="1" minOccurs="0" name="VERSION" nillable="true" type="xsd:decimal"/> <xsd:element maxOccurs="1" minOccurs="0" name="TOPONIMO" nillable="true" type="xsd:string"/> <xsd:element maxOccurs="1" minOccurs="0" name="PROVINCIA" nillable="true" type="xsd:decimal"/> <xsd:element maxOccurs="1" minOccurs="0" name="MUNICIPIO" nillable="true" type="xsd:decimal"/> <xsd:element maxOccurs="1" minOccurs="0" name="AGREGADO" nillable="true" type="xsd:decimal"/> <xsd:element maxOccurs="1" minOccurs="0" name="ZONA" nillable="true" type="xsd:decimal"/> <xsd:element maxOccurs="1" minOccurs="0" name="POLIGONO" nillable="true" type="xsd:decimal"/> <xsd:element maxOccurs="1" minOccurs="0" name="PARCELA" nillable="true" type="xsd:decimal"/> <xsd:element maxOccurs="1" minOccurs="0" name="RECINTO" nillable="true" type="xsd:decimal"/> <xsd:element maxOccurs="1" minOccurs="0" name="PARCELA_AG" nillable="true" type="xsd:string"/> <xsd:element maxOccurs="1" minOccurs="0" name="CONUSUCOD" nillable="true" type="xsd:string"/> <xsd:element maxOccurs="1" minOccurs="0" name="CONMODFEC" nillable="true" type="xsd:string"/> <xsd:element maxOccurs="1" minOccurs="0" name="GRUPO" nillable="true" type="xsd:string"/> <xsd:element maxOccurs="1" minOccurs="0" name="GEOMETRY" nillable="true" type="gml:GeometryPropertyType"/> </xsd:sequence> </xsd:extension> </xsd:complexContent> </xsd:complexType> <xsd:element name="UnidadesGestion" substitutionGroup="gml:_Feature" type="IKT:UnidadesGestionType"/> </xsd:schema> Any ideas?? Thanks in advance. Regards, Un saludo, ·················································································· David Alda Fernández de Lezea Lurralde eta Biodibertsitate Saila / Dpto. de Territorio y Biodiversidad IKT Granja Modelo s/n · 01192 · Arkaute (Araba) ·················································································· Tlfnos.: 945-00-32-95 Fax: 945-00.32.90 ·················································································· email: [email protected] web: www.ikt.es ·················································································· ------------------------------------------------------------------------------ EMC VNX: the world's simplest storage, starting under $10K The only unified storage solution that offers unified management Up to 160% more powerful than alternatives and 25% more efficient. Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
