Thank you Andrea for the answer, read my answers bellow: - are you trying to update a column that maybe does not exist in the table? No, also in this case the error exception says clearly that the field doesn't exist.
- did the table structure change since you started GeoServer? No. It would be useful to see: - the table structure (the create table statement, or a table description of some kind). ------------------------------------------------ CREATE TABLE "public"."HOTSPOT" ( "id" SERIAL, "gid" VARCHAR(50) NOT NULL, "name" VARCHAR(80), "the_geom" "public"."geometry" NOT NULL, "information" VARCHAR(100), CONSTRAINT "HOTSPOT_gid_key" UNIQUE("gid"), CONSTRAINT "HOTSPOT_pkey" PRIMARY KEY("id"), CONSTRAINT "enforce_dims_the_geom" CHECK (st_ndims(the_geom) = 2), CONSTRAINT "enforce_geotype_the_geom" CHECK (geometrytype(the_geom) = 'POINT'::text), CONSTRAINT "enforce_srid_the_geom" CHECK (st_srid(the_geom) = (-1)) ) WITHOUT OIDS; ---------------------------------------------- - the result of calling DescribeFeatureType on that layer <xsd:schema elementFormDefault="qualified" targetNamespace="http://www.pp.fr"> <xsd:import namespace="http://www.opengis.net/gml" schemaLocation="http://localhost:80/geoserver/schemas/gml/2.1.2/feature.xsd"/> <xsd:complexType name="HOTSPOTType"> <xsd:complexContent> <xsd:extension base="gml:AbstractFeatureType"> <xsd:sequence> <xsd:element maxOccurs="1" minOccurs="1" name="id" nillable="false" type="xsd:int"/> <xsd:element maxOccurs="1" minOccurs="1" name="gid" nillable="false" type="xsd:string"/> <xsd:element maxOccurs="1" minOccurs="0" name="name" nillable="true" type="xsd:string"/> <xsd:element maxOccurs="1" minOccurs="1" name="the_geom" nillable="false" type="gml:GeometryPropertyType"/> <xsd:element maxOccurs="1" minOccurs="0" name="information" nillable="true" type="xsd:string"/> </xsd:sequence> </xsd:extension> </xsd:complexContent> </xsd:complexType> <xsd:element name="HOTSPOT" substitutionGroup="gml:_Feature" type="PP:HOTSPOTType"/> </xsd:schema> - the WFS-T request ---------------------------------------------------------------------------- var featureType = 'HOTSPOT'; var featurePrefix = 'PP'; var srsName = 'EPSG:2154'; var url = "http://localhost:80/geoserver/wfs" ; var layer = new OpenLayers.Layer.Vector("hotspot", { projection: new OpenLayers.Projection(srsName), protocol: new OpenLayers.Protocol.WFS({ version: "1.1.0", url: url, featureType: featureType, featureNS: 'http://www.pp.fr', srsName: srsName, geometryName: "the_geom", schema: url + '/DescribeFeatureType?version=1.0.0&TypeName=' +featurePrefix +':'+ featureType }), minScale: 10000, styleMap: style_Map, }); and the issued POST: -------------------------------------------------------------------------------------- <wfs:Transactionxmlns: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://www.pp.fr http://localhost:80/geoserver/wfs/DescribeFeatureType?version=1.0.0&TypeName=PP:HOTSPOT"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <wfs:UpdatetypeName="feature:HOTSPOT"xmlns:feature="http://www.pp.fr"> <wfs:Property> <wfs:Name>the_geom</wfs:Name> <wfs:Value> <gml:Pointxmlns:gml="http://www.opengis.net/gml"srsName="EPSG:2154"> <gml:pos>654215.0496587127 6861900.8752494445</gml:pos> </gml:Point> </wfs:Value> </wfs:Property> <wfs:Property> <wfs:Name>id</wfs:Name> <wfs:Value>9</wfs:Value> </wfs:Property> <wfs:Property> <wfs:Name>gid</wfs:Name> <wfs:Value>4</wfs:Value> </wfs:Property> <wfs:Property> <wfs:Name>information</wfs:Name> <wfs:Value>hotspot info</wfs:Value> </wfs:Property> <wfs:Property> <wfs:Name>name</wfs:Name> <wfs:Value>hotspot</wfs:Value> </wfs:Property> <ogc:Filterxmlns:ogc="http://www.opengis.net/ogc"> <ogc:FeatureIdfid="HOTSPOT.9"></ogc:FeatureId> </ogc:Filter> </wfs:Update> </wfs:Transaction> ------------------------------------------------------------------------- Regards, Dorin ------------------------------------------------------------------------------ BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA The must-attend event for mobile developers. Connect with experts. Get tools for creating Super Apps. See the latest technologies. Sessions, hands-on labs, demos & much more. Register early & save! http://p.sf.net/sfu/rim-blackberry-1 _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users