Hi, One idea is that the list of properties in WFS is a sequence so attributes should be in the same order than they are listed in the schema. In your schema GEOMETRY is the last attribute. I do not know if this is your trouble now but I have fased the property order issue with a certain GIS software which ordered attributes into nice alphabetical order. Rather good idea for a user selecting attributes to be fetched but it lead to failing GetFeature requests.
-Jukka Rahkonen- David Alda Fernandez de Lezea wrote: > 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,ZON > A,POLIGONO,PARCELA,RECINTO,PARCELA_AG,CONUSUCOD,CONMODFEC,GRUP > O,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,ZON > A,POLIGONO,PARCELA,RECINTO,PARCELA_AG,CONUSUCOD,CONMODFEC,GRUP > O,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.0424 > 8047,542216.28972476,4748813.84688567,542200.58086508,4748820. > 57352164,542196.9625809,4748822.38507369,542192.22516798,47488 > 24.75757372,542186.22449539,4748827.75529862,542182.42511197,4 > 748831.19472488,542179.5618309,4748833.78352006,542176.8017896 > 8,4748836.27986538,542166.03220318,4748841.21243124,542155.674 > 90729,4748843.65287875,542150.78073412,4748844.80503932,542137 > .76901441,4748844.79973343,542127.45126087,4748847.49179368,54 > 2110.84715069,4748857.3687093,542109.20888496,4748858.87594993 > ,542094.57454906,4748872.35803089,542093.79674258,4748873.0700 > 1813,542082.60047153,4748878.40036373,542074.95319467,4748882. > 04900404,542052.0660327,4748885.185525,542039.81161435,4748885 > .59460792,542038.60671716,4748885.63378137,542020.2138498,4748 > 878.0094084,541998.67244229,4748872.618491,541966.36974969,474 > 8866.34279196,541946.62701146,4748862.30343564,541946.55964653 > ,4748862.12616417,541941.67252765,4748849.79058353,541942.4266 > 9678,4748848.46411133,541950.85528565,4748831.2019043,541955.8 > 8287354,4748820.52789307,541959.51867676,4748810.2177124,54196 > 5.34631348,4748788.45288086,541975.26971436,4748742.72528076,5 > 41982.57769775,4748710.60913086,541984.38189697,4748704.355712 > 89,541985.69873047,4748700.53790283,541986.80749512,4748698.31 > 988525,541987.73309326,4748696.94787598,541987.9816734,4748696 > .58639749,541989.01947021,4748695.89471436,541992.85107422,474 > 8695.03369141,542003.84631348,4748692.40148926,542014.77752686 > ,4748689.04272461,542025.03448486,4748685.121521,542034.056518 > 56,4748680.55969238,542040.78167725,4748676.61669922,542046.33 > 612061,4748672.74108887,542056.16271973,4748665.33587647,54206 > 9.44732666,4748654.35870361,542078.51330566,4748645.97149658,5 > 42091.99188232,4748633.48748779,542145.96307373,4748577.827880 > 86,542188.1038715,4748533.77825123,542216.37207031,4748503.950 > 68359,542216.53742859,4748503.78416598,542218.51646482,4748504 > .75505959,542221.85383917,4748506.35799044,542223.38756642,474 > 8507.40064708,542224.85723201,4748508.84317361,542232.33444062 > ,4748517.35978477,542235.58250309,4748521.24274215,542235.6096 > 5337,4748521.28014272,542239.36586407,4748526.01329209,542240. > 51370478,4748527.47246167,542245.48241961,4748534.27953886,542 > 247.53008294,4748537.45699262,542254.01888161,4748547.52206447 > ,542255.48828253,4748550.11884315,542257.631627,4748554.432518 > 3,542257.9632993,4748555.03960584,542259.87199634,4748558.5513 > 1329,542260.80967927,4748560.79110383,542262.3473855,4748564.5 > 239341,542263.55448403,4748568.58983623,542264.42762128,474857 > 2.42097438,542265.52228339,4748576.96091633,542266.553396,4748 > 581.81695488,542267.18725176,4748585.60008014,542267.83879084, > 4748592.07345451,542268.26415677,4748596.36726251,542268.31887 > 953,4748600.82634366,542268.82639163,4748607.34537499,542269.0 > 4662169,4748612.71770141,542269.80500379,4748618.5122168,54227 > 0.71606107,4748625.08027201,542272.87132502,4748638.58146101,5 > 42274.79813161,4748652.50012621,542276.38531602,4748661.539078 > 5,542276.70269775,4748663.35632324,542264.00189209,4748672.856 > 50635,542261.02252197,4748675.38867188,542257.4307251,4748678. > 43847656,542255.29272461,4748679.93328857,542250.19207764,4748 > 683.48571777,542247.90297073,4748685.06327845,542243.40912494, > 4748686.76703302,542238.84837972,4748688.21905145,542231.50330 > 222,4748690.53826963,542227.95077429,4748691.66138506,542211.9 > 7858757,4748692.17764749,542201.67708961,4748692.17955852,5421 > 91.11232348,4748696.04287349,542185.64422742,4748698.12233246, > 542178.23455112,4748700.93455832,542169.47155454,4748701.19728 > 515,542157.88323396,4748701.20067645,542157.34205596,4748701.2 > 7182519,542149.12080561,4748702.48736146,542145.96534006,47487 > 03.60364511,542144.74432427,4748704.03365617,542145.51620992,4 > 748707.64075601,542150.66616993,4748709.44093564,542163.805052 > 89,4748709.95900692,542178.49035772,4748709.44404567,542194.98 > 011676,4748703.77400467,542211.72629635,4748697.59361299,54223 > 1.04613836,4748698.10322677,542244.5993161,4748701.37929712,54 > 2245.98676264,4748701.71361899,542250.62588825,4748708.6676132 > ,542253.45686966,4748720.25541103,542251.90926229,4748729.2750 > 9103,542251.6715132,4748730.09277297,542248.55933107,4748740.8 > 7144233,542250.80409602,4748750.94766874,542251.13705426,47487 > 52.45768344,542251.91147363,4748754.52891828,542252.7532959,47 > 48756.76812744,542250.89630127,4748761.57849121,542245.3319091 > 8,4748775.98168945,542237.57391357,4748790.92071533,542231.772 > 70508,4748800.45410156,542228.42852783,4748804.4362793,542228. > 34588623,4748804.5100708,542223.23272705,4748809.00268555,5422 > 17.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(UpdateElementHa > ndler.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(Default > WebFeatureService.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.invokeJoinpointUsingR > eflection(AopUtils.java:310) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.i > nvokeJoinpoint(ReflectiveMethodInvocation.java:182) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.p > roceed(ReflectiveMethodInvocation.java:149) > at org.geoserver.ows.util.EMFLogger.invoke(EMFLogger.java:51) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.p > roceed(ReflectiveMethodInvocation.java:171) > at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(Jd > kDynamicAopProxy.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.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:647) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) > 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.coyote.http11.Http11Processor.process(Http11Process > or.java:879) > at > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHa ndler.processConnection(Http11BaseProtocol.java:665) > at > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolT > cpEndpoint.java:528) > at > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(Le > aderFollowerWorkerThread.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(JDBCFeatureS > tore.java:354) > at > org.geoserver.feature.retype.RetypingFeatureStore.modifyFeatur > es(RetypingFeatureStore.java:76) > at > org.vfny.geoserver.global.GeoServerFeatureStore.modifyFeatures > (GeoServerFeatureStore.java:113) > at > org.geoserver.wfs.UpdateElementHandler.execute(UpdateElementHa > ndler.java:238) > ... 70 more > Caused by: java.sql.SQLException: Invalid column index > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseErr > or.java:112) > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseErr > or.java:146) > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseErr > or.java:208) > at > oracle.jdbc.driver.OraclePreparedStatement.setBigDecimalIntern > al(OraclePreparedStatement.java:5227) > at > oracle.jdbc.driver.OraclePreparedStatement.setBigDecimal(Oracl > ePreparedStatement.java:5219) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.setBigDeci > mal(DelegatingPreparedStatement.java:129) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.setBigDeci > mal(DelegatingPreparedStatement.java:129) > at > org.geotools.jdbc.PreparedStatementSQLDialect.setValue(Prepare > dStatementSQLDialect.java:135) > at > org.geotools.jdbc.JDBCDataStore.setPreparedFilterValues(JDBCDa > taStore.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@26f4a3a > 1 (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 > ------------------------------------------------------------------------------ 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
