Hi all, i'm writting again regarding my wfs-t update problem. Has anyone experienced such problem with the last 2.1.1 version?
Regards, Dorin On 02.08.2011 15:04, Dorin Tcaci wrote: > Hi Jukka, > you are right about the problems related to the reserved Postgres(i have > doubts here, > maybe is a GeoServer+Postgres problem?) keywords like "name" or > "description" used as fields, > i know this fact. But this is not the case. When i use the > "DescribeFeatureType" request with version=1.0.0, the returned xml is > Ok, the problems appears when i use version=1.1.0 (it refuses to > describe the "name" or"description"-like fields). Even changing the > field name hasn't solved the update problem.. > > Best, > Dorin > > On 02.08.2011 14:07, Rahkonen Jukka wrote: >> Hi, >> >> Try to rename the "name" attribute to something else, like name_debug. >> PostgreSQL reserved keywords may cause odd problems. >> >> -Jukka Rahkonen- >> ________________________________________ >> Lähettäjä: Dorin Tcaci [[email protected]] >> Lähetetty: 2. elokuuta 2011 12:12 >> Vastaanottaja: [email protected] >> Aihe: Re: [Geoserver-users] WFS-T update doesn't work >> >> 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 >> > ------------------------------------------------------------------------------ uberSVN's rich system and user administration capabilities and model configuration take the hassle out of deploying and managing Subversion and the tools developers use with it. Learn more about uberSVN and get a free download at: http://p.sf.net/sfu/wandisco-dev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
