Hello everyone,<br><br>I have a bug which I cannot solve. Was wandering if anyone could help.<br><br>I am trying to save a single point to a vector layer (this is originally a shp file which I uploaded to GeoServer in two ways - as the shapefile itself and as a postgis table, both of them produce the same error) following the wfs-t example that comes with geoserver (geoserver/www/wfs-t.html).<br>
When I try with the default page it works and saves the point to topp:tasmania_cities.<br><br>Anyone has any ideas. I'm kind of in the dark. If you want any more info about my data feel free to ask. I will answer immediately.<br>
<br>
Thanks, João<br>
<br><br>Logs below:<br><br>When I send this POST Request:<br><br><code class="focusRow subFocusRow "><wfs:Transaction
xmlns:wfs="<a href="http://www.opengis.net/wfs">http://www.opengis.net/wfs</a>" version="1.0.0"
service="WFS"><br></code><div style="margin-left: 40px;"><code class="focusRow subFocusRow "><wfs:Insert></code><br><code class="focusRow subFocusRow "></code></div><div style="margin-left: 40px;"><div style="margin-left: 40px;">
<code class="focusRow subFocusRow "><feature</code><code class="focusRow subFocusRow ">:pontos_interesse_min_postgis
xmlns:feature="<a href="http://localhost:8080/geoserver/peniche">http://localhost:8080/geoserver/peniche</a>"></code><br></div><code class="focusRow subFocusRow "></code></div><div style="margin-left: 40px;">
<div style="margin-left: 80px;"><code class="focusRow subFocusRow "><feature:the_geom</code><code class="focusRow subFocusRow ">></code><br></div><code class="focusRow subFocusRow "></code></div><div style="margin-left: 40px;">
<div style="margin-left: 120px;"><code class="focusRow subFocusRow "><gml:MultiPoint
xmlns:gml="<a href="http://www.opengis.net/gml">http://www.opengis.net/gml</a>"></code><br></div><code class="focusRow subFocusRow "></code></div><div style="margin-left: 40px;"><div style="margin-left: 160px;">
<code class="focusRow subFocusRow "><gml:pointMember></code><br></div><code class="focusRow subFocusRow "></code></div><div style="margin-left: 40px;"><div style="margin-left: 200px;"><code class="focusRow subFocusRow "><gml:Point></code><br>
</div><code class="focusRow subFocusRow "></code></div><div style="margin-left: 40px;"><div style="margin-left: 240px;"><code class="focusRow subFocusRow "><gml:coordinates</code><code class="focusRow subFocusRow "> decimal="." cs="," ts="
"><br></code><div style="margin-left: 40px;"><code class="focusRow subFocusRow ">14337.787617188,31343.8228125<br></code></div><code class="focusRow subFocusRow "></gml:coordinates></code><br></div><code class="focusRow subFocusRow "></code></div>
<div style="margin-left: 40px;"><div style="margin-left: 200px;"><code class="focusRow subFocusRow "></gml:Point></code><br></div><code class="focusRow subFocusRow "></code></div><div style="margin-left: 40px;"><div style="margin-left: 160px;">
<code class="focusRow subFocusRow "></gml:pointMember</code><code class="focusRow subFocusRow ">></code><br></div><code class="focusRow subFocusRow "></code></div><div style="margin-left: 40px;"><div style="margin-left: 120px;">
<code class="focusRow subFocusRow "></gml:MultiPoint></code><br></div><code class="focusRow subFocusRow "></code></div><div style="margin-left: 40px;"><div style="margin-left: 80px;"><code class="focusRow subFocusRow "></feature:the_geom></code><br>
</div><code class="focusRow subFocusRow "></code></div><div style="margin-left: 80px;"><code class="focusRow subFocusRow "></feature:pontos_interesse_min_postgis><br></code></div><div style="margin-left: 40px;"><code class="focusRow subFocusRow "></wfs:Insert></code><br>
<code class="focusRow subFocusRow "></code></div><code class="focusRow subFocusRow "></wfs:Transaction</code><code tabindex="0" class="focusRow
subFocusRow a11yModified">></code><br><br clear="all">The Response is:<br><br><div selected class="netInfoResponseText
netInfoText "><pre><code class="wrappedText focusRow"><?xml version="1.0" encoding="UTF-8"?><br><wfs:WFS_TransactionResponse version="1.0.0" <br>xmlns:wfs="http:/</code><code class="wrappedText focusRow">/<a href="http://www.opengis.net/wfs">www.opengis.net/wfs</a>" <br>
xmlns:ogc="<a href="http://www.opengis.net/ogc">http://www.opengis.net/ogc</a>" <br>xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>"</code><code class="wrappedText focusRow"> <br>
xsi:schemaLocation="<a href="http://www.opengis.net/wfs">http://www.opengis.net/wfs</a> <a href="http://localhost:80/geoserver/schemas/wfs/1.0.0/WFS-transaction">http://localhost:80/geoserver/schemas/wfs/1.0.0/WFS-transaction</a></code><code class="wrappedText focusRow">.xsd"><br>
</code></pre><div style="margin-left: 40px;"><code class="wrappedText focusRow"><wfs:InsertResult><br></code><div style="margin-left: 40px;"><code class="wrappedText focusRow"><ogc:FeatureId fid="none"/><br>
</code></div><code class="wrappedText focusRow"></wfs:InsertResult><br><wfs:TransactionResult><br></code><div style="margin-left: 40px;"><code class="wrappedText focusRow"><wfs:Status</code><code class="wrappedText focusRow">><br>
</code><div style="margin-left: 40px;"><code class="wrappedText focusRow"><wfs:FAILED/><br></code></div><code class="wrappedText focusRow"></wfs:Status><br><wfs:Message><br></code><div style="margin-left: 40px;">
<code class="wrappedText focusRow">Error performing insert<br></code></div><code class="wrappedText focusRow"></wfs:Message><br></code></div><code class="wrappedText focusRow"></wfs:TransactionResult</code><code tabindex="0" class="wrappedText focusRow a11yModified">><br>
</code></div><code tabindex="0" class="wrappedText focusRow a11yModified"></wfs:WFS_TransactionResponse><br><br><br></code></div><br>The GeoServer Log says: <br><br>2010-05-07 15:23:53,190 ERROR [geoserver.wfs] - Transaction failed<br>
org.geoserver.wfs.WFSTransactionException: Error performing insert<br><br>2010-05-07 15:23:53,192 INFO [geoserver.wfs] - <br>Request: transaction<br> handle = null<br> service = WFS<br> version = 1.0.0<br> baseUrl = <a href="http://localhost:80/geoserver/">http://localhost:80/geoserver/</a><br>
providedVersion = null<br> lockId = null<br> group = [wfs:insert=net.opengis.wfs.impl.InsertElementTypeImpl@f53890 (feature: [SimpleFeatureImpl:pontos_interesse_min_postgis=[SimpleFeatureImpl.Attribute: objectid<objectid id=fid--6c61e3e8_128726979c6_-7fec>=null, SimpleFeatureImpl.Attribute: id<id id=fid--6c61e3e8_128726979c6_-7fec>=null, SimpleFeatureImpl.Attribute: nome<nome id=fid--6c61e3e8_128726979c6_-7fec>=null, SimpleFeatureImpl.Attribute: categoria<categoria id=fid--6c61e3e8_128726979c6_-7fec>=null, SimpleFeatureImpl.Attribute: dtcc<dtcc id=fid--6c61e3e8_128726979c6_-7fec>=null, SimpleFeatureImpl.Attribute: the_geom<the_geom id=fid--6c61e3e8_128726979c6_-7fec>=]], handle: null, idgen: <unset>, inputFormat: <unset>, srsName: null)]<br>
insert = [net.opengis.wfs.impl.InsertElementTypeImpl@f53890 (feature: [SimpleFeatureImpl:pontos_interesse_min_postgis=[SimpleFeatureImpl.Attribute: objectid<objectid id=fid--6c61e3e8_128726979c6_-7fec>=null, SimpleFeatureImpl.Attribute: id<id id=fid--6c61e3e8_128726979c6_-7fec>=null, SimpleFeatureImpl.Attribute: nome<nome id=fid--6c61e3e8_128726979c6_-7fec>=null, SimpleFeatureImpl.Attribute: categoria<categoria id=fid--6c61e3e8_128726979c6_-7fec>=null, SimpleFeatureImpl.Attribute: dtcc<dtcc id=fid--6c61e3e8_128726979c6_-7fec>=null, SimpleFeatureImpl.Attribute: the_geom<the_geom id=fid--6c61e3e8_128726979c6_-7fec>=]], handle: null, idgen: <unset>, inputFormat: <unset>, srsName: null)]<br>
update = []<br> delete = []<br> native = []<br> releaseAction = ALL<br> <br><br>The PostGre log does not report anything.<br><br><br><br><br><br><br>-- <br>"Ajude um pouco ... já é muito"<br>Projecto SOSIndia <a href="http://sosindia.net">http://sosindia.net</a><br>
---------------------------------------------<br><br>Shoot for the moon,<br>even if you miss it<br>you will land among the stars.<br>- Unknown<br><br>-------------------------------------------------<br><br>What if for a moment, as an experiment,<br>
you drop every belief that you have?<br>- Unknown<br><br>---------------------------------------------------------------<br><br>"We are all linked by a fabric of unseen connections. This fabric is constantly changing and evolving. This field is directly structured and influenced by our behavior and by our understanding."<br>
—David Bohm, quantum physicist, 1917–1992 <br>