<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
By the way, I am using PostGIS 1.5.3 version, installed with PostgreSQL 9.1<br><br>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?<br><br><div><div id="SkyDrivePlaceholder"></div><hr id="stopSpelling">From: erndal02@hotmail.com<br>To: tinyows-dev@lists.maptools.org<br>Date: Wed, 9 May 2012 21:03:00 +0200<br>Subject: Re: [TinyOWS-dev] Error when inserting new feature with TinyOWS<br><br>
<style><!--
.ExternalClass .ecxhmmessage P
{padding:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Tahoma;}
--></style>
<div dir="ltr">
Hi,<br><br>I made another try, by adding this statement in config.xml: <br>check_schema="0"<br>so that to avoid the schema validation.<br><br>Now, another weird thing seems to be happening, taken from the log file of tinyows:<br>1. [Wed May 09 20:53:28 2012] [SQL] BEGIN;<br>2. [Wed May 09 20:53:28 2012] [SQL] SELECT nextval('public.olives_fid_seq');<br>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>')<br>4. [Wed May 09 20:53:28 2012] [SQL] SELECT ST_IsValid('01060000207A7F0000010000000103000000010000000500000000000080A0361741000000304A335141000000005C37174100000000D53251410000000008451741000000706933514100000080DB41174100000008A433514100000080A0361741000000304A335141')<br>5. [Wed May 09 20:53:28 2012] [SQL] <br>6. [Wed May 09 20:53:28 2012] [SQL] ROLLBACK;<br><br>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 <br><br>The most important thing is that I still cannot add a feature from tinyows...<br><br>I would appreciate a lot some help on this issue...<br><br>Thanks<br><br><div><div id="ecxSkyDrivePlaceholder"></div><hr id="ecxstopSpelling">From: erndal02@hotmail.com<br>To: tinyows-dev@lists.maptools.org<br>Date: Wed, 9 May 2012 10:03:00 +0200<br>Subject: Re: [TinyOWS-dev] Error when inserting new feature with TinyOWS<br><br>
<style><!--
.ExternalClass .ecxhmmessage P
{padding:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Tahoma;}
--></style>
<div dir="ltr">
Hi,<br><br>> You can't have success with WFS 1.1.0 because your geometry is in GML2<br>> <gml:coordinates<br>>
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.<br><br>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.<br><br>Anyway I still have the same error, but I see in the log files one more error which says:<br><font style="" face="Courier New">[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.</font><br><br>If I try the URL in the browser it gives me the whole schema for the layer, and it's something like this:<br><br><font style="" face="Courier New"><?xml version='1.0' encoding='UTF-8'?></font><font style="" face="Courier New"><br></font><font style="" face="Courier New"><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'></font><font style="" face="Courier New"><br></font><font style="" face="Courier New"><xs:import namespace='http://www.opengis.net/gml' schemaLocation='http://schemas.opengis.net/gml/2.1.2/feature.xsd'/></font><font style="" face="Courier New"><br></font><font style="" face="Courier New"><xs:element name='olives' type='tows:olivesType' substitutionGroup='gml:_Feature' /></font><font style="" face="Courier New"><br></font><font style="" face="Courier New"><xs:complexType name='olivesType'></font><font style="" face="Courier New"><br></font><font style="" face="Courier New"> <xs:complexContent></font><font style="" face="Courier New"><br></font><font style="" face="Courier New"> <xs:extension base='gml:AbstractFeatureType'></font><font style="" face="Courier New"><br></font><font style="" face="Courier New"> <xs:sequence></font><font style="" face="Courier New"><br></font><font style="" face="Courier New"> <xs:element name ='rrethid' type='int' nillable='true' minOccurs='0' maxOccurs='1'/></font><font style="" face="Courier New"><br></font><font style="" face="Courier New"> ......</font><font style="" face="Courier New"><br></font><font style="" face="Courier New"> ......</font><font style="" face="Courier New"><br></font><font style="" face="Courier New"> </xs:sequence></font><font style="" face="Courier New"><br></font><font style="" face="Courier New"> </xs:extension></font><font style="" face="Courier New"><br></font><font style="" face="Courier New"> </xs:complexContent></font><font style="" face="Courier New"><br></font><font style="" face="Courier New"></xs:complexType></font><font style="" face="Courier New"><br></font><font style="" face="Courier New"></xs:schema></font><br><br><br>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.<br><br>Also, if the error is at the schema, why shouldn't if fire also when editing/deleting a feature?<br><br>Thanks<br><br><div><div id="ecxSkyDrivePlaceholder"></div>> From: Jukka.Rahkonen@mmmtike.fi<br>> To: tinyows-dev@lists.maptools.org<br>> Date: Tue, 8 May 2012 19:34:43 +0000<br>> Subject: Re: [TinyOWS-dev] Error when inserting new feature with TinyOWS<br>> <br>> Hi,<br>> <br>> You can't have success with WFS 1.1.0 because your geometry is in GML2<br>> <gml:coordinates<br>> 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.<br>> <br>> -Jukka Rahkonen-<br>> <br>> Ermond Parllaku wrote:<br>> <br>> > Hi to all,<br>> <br>> > 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.<br>> <br>> In the log of TinyOWS, when I try to insert a new feature, I keep getting an error:<br>> <br>> [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 )<br>> <br>> Just before the error, in the log file I see this query:<br>> <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"><br>> <wfs:Insert><br>> <feature:olives xmlns:feature="http://www.tinyows.org/"><br>> <feature:geometry><br>> <gml:MultiPolygon xmlns:gml="http://www.opengis.net/gml" srsName="EPSG:32634"><br>> <gml:polygonMember><br>> <gml:Polygon><br>> <gml:outerBoundaryIs><br>> <gml:LinearRing><br>> <gml:coordinates decimal="." cs="," ts=" ">381781.25,4509578.125 381875,4509031.25 382656.25,4509734.375 381781.25,4509578.125</gml:coordinates><br>> </gml:LinearRing><br>> </gml:outerBoundaryIs><br>> </gml:Polygon><br>> </gml:polygonMember><br>> </gml:MultiPolygon><br>> </feature:geometry><br>> </feature:olives><br>> </wfs:Insert><br>> </wfs:Transaction><br>> <br>> <br>> The config.xml is like this:<br>> <tinyows online_resource="http://localhost:81/cgi-bin/tinyows.exe"<br>> schema_dir="C:/ms4w/apps/tinyows/schema/"<br>> log="C:/ms4w/apps/tinyows/tinyows.log"<br>> log_level="15"><br>> <pg host="127.0.0.1" user="postgres" password="***" dbname="olives_gis1" port="5432"/><br>> <metadata name="Olives WFST Server"<br>> title="WFST Olives" /><br>> <br>> <layer retrievable="1"<br>> writable="1"<br>> ns_prefix="tows"<br>> ns_uri="http://www.tinyows.org/"<br>> //srid="EPSG:32634"<br>> name="olives"<br>> title="olives"/><br>> </tinyows><br>> <br>> 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.<br>> <br>> I have declared a DrawFeature variable like this, to draw the feature that will be saved in the database:<br>> <br>> var draw = new OpenLayers.Control.DrawFeature(<br>> wfs, OpenLayers.Handler.Polygon,<br>> {<br>> title: "Add olives",<br>> displayClass: "olControlDrawFeaturePolygon",<br>> multi: "true",<br>> id: "draw"<br>> }<br>> );<br>> <br>> <br>> I would like to mention again that the editing and deleting of existing features work very well.<br>> <br>> I am using MS4W 3.0.4 (with OL included) and tinyows-1.0.0rc3. The database is in PostgreSQL & PostGIS.<br>> <br>> 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...<br>> <br>> Thanks a lot in advance for your help<br>> _______________________________________________<br>> TinyOWS-dev mailing list<br>> TinyOWS-dev@lists.maptools.org<br>> http://lists.maptools.org/mailman/listinfo/tinyows-dev<br></div> </div>
<br>_______________________________________________
TinyOWS-dev mailing list
TinyOWS-dev@lists.maptools.org
http://lists.maptools.org/mailman/listinfo/tinyows-dev</div> </div>
<br>_______________________________________________
TinyOWS-dev mailing list
TinyOWS-dev@lists.maptools.org
http://lists.maptools.org/mailman/listinfo/tinyows-dev</div> </div></body>
</html>