[TinyOWS-dev] Error when inserting new feature with TinyOWS
Ermond Parllaku
erndal02 at hotmail.com
Wed May 9 14:35:30 EST 2012
By the way, I am using PostGIS 1.5.3 version, installed with PostgreSQL 9.1
The 2.0.0. version of PostGIS I read that it officially came out on May 2012. I don't think I need to upgrade the version of PostGIS, but may it be this the case of my errors?
From: erndal02 at hotmail.com
To: tinyows-dev at lists.maptools.org
Date: Wed, 9 May 2012 21:03:00 +0200
Subject: Re: [TinyOWS-dev] Error when inserting new feature with TinyOWS
Hi,
I made another try, by adding this statement in config.xml:
check_schema="0"
so that to avoid the schema validation.
Now, another weird thing seems to be happening, taken from the log file of tinyows:
1. [Wed May 09 20:53:28 2012] [SQL] BEGIN;
2. [Wed May 09 20:53:28 2012] [SQL] SELECT nextval('public.olives_fid_seq');
3. [Wed May 09 20:53:28 2012] [SQL] SELECT ST_GeomFromGML('<gml:MultiPolygon xmlns:gml="http://www.opengis.net/gml" xmlns:feature="http://127.0.0.1:81/" xmlns:wfs="http://www.opengis.net/wfs" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" srsName="EPSG:32634"><gml:polygonMember><gml:Polygon><gml:outerBoundaryIs><gml:LinearRing><gml:coordinates decimal="." cs="," ts=" ">380328.125,4508968.75 380375,4508500 381250,4509093.75 381046.875,4509328.125 380328.125,4508968.75</gml:coordinates></gml:LinearRing></gml:outerBoundaryIs></gml:Polygon></gml:polygonMember></gml:MultiPolygon>')
4. [Wed May 09 20:53:28 2012] [SQL] SELECT ST_IsValid('01060000207A7F0000010000000103000000010000000500000000000080A0361741000000304A335141000000005C37174100000000D53251410000000008451741000000706933514100000080DB41174100000008A433514100000080A0361741000000304A335141')
5. [Wed May 09 20:53:28 2012] [SQL]
6. [Wed May 09 20:53:28 2012] [SQL] ROLLBACK;
If I try to insert directly the geometry as it is in row 3 of the log file, from postGIS, the feature is inserted in the database. So it looks like the geometry is OK. But I just cannot understand the row 5, why should it be empty, and also the row number 6 which just say "rollback". Meanwhile, if I run the query in row 4 in postgis, the result is true, which means the geometry is valid
The most important thing is that I still cannot add a feature from tinyows...
I would appreciate a lot some help on this issue...
Thanks
From: erndal02 at hotmail.com
To: tinyows-dev at lists.maptools.org
Date: Wed, 9 May 2012 10:03:00 +0200
Subject: Re: [TinyOWS-dev] Error when inserting new feature with TinyOWS
Hi,
> You can't have success with WFS 1.1.0 because your geometry is in GML2
> <gml:coordinates
>
However, you had some other problem too with the schema location. I
can't say anything about that. Anyway, be sure to use GML2 with WFS
1.0.0 and GML3 with WFS 1.1.0.
Thanks for your answer. I wasn't sure if I could use the WFS 1.1.0, so now I am sure that I cannot.
Anyway I still have the same error, but I see in the log files one more error which says:
[ERROR] Element '{http://www.w3.org/2001/XMLSchema}import': Failed to locate a schema at location 'http://localhost:81/cgi-bin/tinyows.exe?service=WFS&request=DescribeFeatureType&version=1.0.0'. Skipping the import.
If I try the URL in the browser it gives me the whole schema for the layer, and it's something like this:
<?xml version='1.0' encoding='UTF-8'?>
<xs:schema targetNamespace='http://www.tinyows.org/' xmlns:tows='http://www.tinyows.org/' xmlns:ogc='http://www.opengis.net/ogc' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns='http://www.w3.org/2001/XMLSchema' xmlns:gml='http://www.opengis.net/gml' elementFormDefault='qualified' version='1.0'>
<xs:import namespace='http://www.opengis.net/gml' schemaLocation='http://schemas.opengis.net/gml/2.1.2/feature.xsd'/>
<xs:element name='olives' type='tows:olivesType' substitutionGroup='gml:_Feature' />
<xs:complexType name='olivesType'>
<xs:complexContent>
<xs:extension base='gml:AbstractFeatureType'>
<xs:sequence>
<xs:element name ='rrethid' type='int' nillable='true' minOccurs='0' maxOccurs='1'/>
......
......
</xs:sequence>
</xs:extension>
</xs:complexContent>
</xs:complexType>
</xs:schema>
I think the error should be somewhere in the schema folder within tinyows folder that I have (but not sure at all). Anyway if someone could tell me where to get the latest schema folder version of TinyOWS, I can try to replace them, and see if the error is there.
Also, if the error is at the schema, why shouldn't if fire also when editing/deleting a feature?
Thanks
> From: Jukka.Rahkonen at mmmtike.fi
> To: tinyows-dev at lists.maptools.org
> Date: Tue, 8 May 2012 19:34:43 +0000
> Subject: Re: [TinyOWS-dev] Error when inserting new feature with TinyOWS
>
> Hi,
>
> You can't have success with WFS 1.1.0 because your geometry is in GML2
> <gml:coordinates
> However, you had some other problem too with the schema location. I can't say anything about that. Anyway, be sure to use GML2 with WFS 1.0.0 and GML3 with WFS 1.1.0.
>
> -Jukka Rahkonen-
>
> Ermond Parllaku wrote:
>
> > Hi to all,
>
> > I configured a layer with TinyOWS and MS4W in Windows. I have other layers in the map viewer too, configured with OpenLayers, but the layer that I configured with TinyOWS is supposed to be editable. Anyway, I can edit and delete features from the layer. But unfortunately I haven't managed yet to insert new features.
>
> In the log of TinyOWS, when I try to insert a new feature, I keep getting an error:
>
> [ERROR] Element '{http://www.tinyows.org/}olives': This element is not expected. Expected is one of ( {http://www.opengis.net/gml}_Feature, {http://www.opengis.net/wfs}FeatureCollection )
>
> Just before the error, in the log file I see this query:
> <wfs:Transaction xmlns:wfs="http://www.opengis.net/wfs" service="WFS" version="1.1.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/WFS-transaction.xsd">
> <wfs:Insert>
> <feature:olives xmlns:feature="http://www.tinyows.org/">
> <feature:geometry>
> <gml:MultiPolygon xmlns:gml="http://www.opengis.net/gml" srsName="EPSG:32634">
> <gml:polygonMember>
> <gml:Polygon>
> <gml:outerBoundaryIs>
> <gml:LinearRing>
> <gml:coordinates decimal="." cs="," ts=" ">381781.25,4509578.125 381875,4509031.25 382656.25,4509734.375 381781.25,4509578.125</gml:coordinates>
> </gml:LinearRing>
> </gml:outerBoundaryIs>
> </gml:Polygon>
> </gml:polygonMember>
> </gml:MultiPolygon>
> </feature:geometry>
> </feature:olives>
> </wfs:Insert>
> </wfs:Transaction>
>
>
> The config.xml is like this:
> <tinyows online_resource="http://localhost:81/cgi-bin/tinyows.exe"
> schema_dir="C:/ms4w/apps/tinyows/schema/"
> log="C:/ms4w/apps/tinyows/tinyows.log"
> log_level="15">
> <pg host="127.0.0.1" user="postgres" password="***" dbname="olives_gis1" port="5432"/>
> <metadata name="Olives WFST Server"
> title="WFST Olives" />
>
> <layer retrievable="1"
> writable="1"
> ns_prefix="tows"
> ns_uri="http://www.tinyows.org/"
> //srid="EPSG:32634"
> name="olives"
> title="olives"/>
> </tinyows>
>
> I thought the error might happen because in the database the geometry of the table olives is declared as POLYGON, so I changed it to MULTIPOLYGON, but I still got the same error. I also changed the WFS schema to 1.0.0, but still the same error.
>
> I have declared a DrawFeature variable like this, to draw the feature that will be saved in the database:
>
> var draw = new OpenLayers.Control.DrawFeature(
> wfs, OpenLayers.Handler.Polygon,
> {
> title: "Add olives",
> displayClass: "olControlDrawFeaturePolygon",
> multi: "true",
> id: "draw"
> }
> );
>
>
> I would like to mention again that the editing and deleting of existing features work very well.
>
> I am using MS4W 3.0.4 (with OL included) and tinyows-1.0.0rc3. The database is in PostgreSQL & PostGIS.
>
> Since I don't have much experience with these technologies (more than 1 month) I might have made some stupid error, but I cannot find it anyway...
>
> Thanks a lot in advance for your help
> _______________________________________________
> TinyOWS-dev mailing list
> TinyOWS-dev at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/tinyows-dev
_______________________________________________
TinyOWS-dev mailing list
TinyOWS-dev at lists.maptools.org
http://lists.maptools.org/mailman/listinfo/tinyows-dev
_______________________________________________
TinyOWS-dev mailing list
TinyOWS-dev at lists.maptools.org
http://lists.maptools.org/mailman/listinfo/tinyows-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/tinyows-dev/attachments/20120509/7df90c4d/attachment-0001.htm
More information about the TinyOWS-dev
mailing list