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
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
