Jukka, I haven't got any control over that. I use an openlayers layer with WFS Protocol and a SaveStrategy, and it does all the updating process on it's own. Maybe I can take the request and modify it manually.
Anyway, it seems quite strange if the problem is what you mentioned, moreover knowing that the insertion process works, isn't it? Besides, while configurating the SaveStrategy, I set the schema of the typename, so it should know all the fields. I've noticed in the GeoServer's SQL sentence that there are 2 fields missing (PARCELA_AG,GRUPO) but they might be null. The GeoServer sentence is as follows UPDATE USRCARTO.GT_ARLOGIS_UG_ED50 SET GEOMETRY = ?,CODEX = ?,UG = ?,VERSION = ?,TOPONIMO = ?,PROVINCIA = ?,MUNICIPIO = ?,AGREGADO = ?,ZONA = ?,POLIGONO = ?,PARCELA = ?,RECINTO = ?,CONUSUCOD = ?,CONMODFEC = ? WHERE (GID = ?) Do I have to set those fields to some other value, just in case?? Thanks. 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 ·················································································· -----Mensaje original----- De: Rahkonen Jukka [mailto:[email protected]] Enviado el: lunes, 29 de agosto de 2011 9:07 Para: '[email protected]' Asunto: Re: [Geoserver-users] Error performing update over wfs-t 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 ------------------------------------------------------------------------------ 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
