Home > postgis > geoserver wfs insert error

geoserver wfs insert error

April 27Hits:4
Advertisement

I keep getting an insert error from geoserver when trying to save a point, poly etc etc to my postgis table. any ideas, my code is below

    var Projection = new OpenLayers.Projection("EPSG:4326");       var map = new OpenLayers.Map("Map", {         //projection: new OpenLayers.Projection("EPSG:900913"),         displayProjection:Projection,         controls:[]         }     );      //add google map     var GoogleMap = new OpenLayers.Layer.Google(         "GoogleSatellite",{             type:G_SATELLITE_MAP,             isBaseLayer:true,             sphericalMercator:true,             maxExtent: new OpenLayers.Bounds(-20037508.34, -20037508.34, 20037508.34, 20037508.34),             numZoomLevels: 21           }      );        var NYC = new OpenLayers.Layer.WMS(       "nyc_buildings - Tiled", "http://soiisdev:8080/geoserver/wms",         {             layers: 'cite:nyc_buildings',             styles: '',             format: "image/png",             tiled: 'true',             transparent: true,             Projection:Projection          },         {             buffer: 0,             displayOutsideMaxExtent: true         }                   );      var saveStrategy = new OpenLayers.Strategy.Save({auto:true})      var vectors = new OpenLayers.Layer.Vector("Vectors", {         strategies: [             new OpenLayers.Strategy.BBOX(),              saveStrategy         ],         Projection:Projection,          protocol: new OpenLayers.Protocol.WFS({             version: "1.1.0",              url:  "http://soiisdev:8080/geoserver/wfs",             featureNS : "http://www.opengeospatial.net/cite",              featureType: "nyc_vectors",             srsName: "EPSG:4326"         })     });      map.addLayers([GoogleMap, NYC, vectors]);      //map.zoomToMaxExtent();      var LonLat = new OpenLayers.LonLat(-73.988113, 40.750898);     LonLat.transform(Projection, map.getProjectionObject());       map.setCenter(LonLat, 15);  

ive checked the header in fiddler and below is the xml sent to geoserver

<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.xsd"> <wfs:Insert>  <feature:nyc_vectors xmlns:feature="http://www.opengeospatial.net/cite">    <feature:the_geom>      <gml:Point xmlns:gml="http://www.opengis.net/gml" srsName="EPSG:4326">        <gml:pos>-73.986374928559 40.742379645006</gml:pos>      </gml:Point>    </feature:the_geom>  </feature:nyc_vectors> 

Answers

You should also post the version of PostGIS and PostgreSQL you are using.

To determine that use:

SELECT postgis_full_version(); SELECT version();

Note in PostGIS 2.0 we dropped a lot of deprecated functions. This has caused some people running GeoServer some problems. If you are running GeoServer latest RC and PostGIS 2.0 and you are still having problems. Install the legacy.sql file packaged with PostGIS 2.0.

http://www.postgis.org/documentation/manual-svn/PostGIS_FAQ.html#legacy_faq

Related Articles

  • geoserver wfs insert errorApril 27

    I keep getting an insert error from geoserver when trying to save a point, poly etc etc to my postgis table. any ideas, my code is below var Projection = new OpenLayers.Projection("EPSG:4326"); var map = new OpenLayers.Map("Map", { //p

  • Geoserver WFS-T insert no response. bug?December 1

    I use Geoserver + Openlayers and want to add and save some new Points via WFS-T. I created insert transaction (correct) and sent it, but no response (include errors) was returned. In console was only: 01 dec 17:34:16 INFO [geoserver.wfs] - Request: g

  • Geoserver WFS-T "Feature type 'Workspace:Layer' is not available" Error on update / deleteDecember 1

    I am using the following code for insert / update (changed from this source: http://wordpress-dbauszus.rhcloud.com/?p=71): var formatWFS = new ol.format.WFS(); // GML Format zur Interaktion mit WFS var formatGML = new ol.format.GML({ featureNS: 'http

  • Drupal-Geoserver WFS error September 24

    I am having trouble getting a WFS layer working using Geoserver, OpenLayers and GeoExt. I get the following error: XMLHttpRequest cannot load http://10.0.0.155/geoserver/wfs. Origin http://10.0.0.155:8080 is not allowed by Access-Control-Allow-Origin

  • Transactions in Geoserver / WFS - Is it possible to know which "action" failed?June 4

    I'm trying to implement transactions for some queries to Geoserver. I'm using plain HTTP Post to make the requests, from Java. One of those queries looks something like : <wfs:Transaction service='WFS' version='1.0.0' xmlns:wfs='http://www.opengis.ne

  • QGIS does not update data in Geoserver WFS-TNovember 14

    I am trying to edit a WFS from geoserver (using PostGIS data) within QGIS. This is the request as recorded by Fiddler <Transaction xmlns="http://www.opengis.net/wfs" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version=&quo

  • Oracle / GeoServer / WFS-T / Openlayers many polygons as one featureFebruary 26

    Newbie question regarding Oracle / GeoServer / WFS-T / Openlayers. I am creating a table that will hold geometry features a user creates/updates. My question is, I would like to have just one record in the table per customer (customerId). Can I creat

  • Geoserver returning Translator Error when I use PropertyIsLikeJuly 16

    I'm converting a WFS app from MapServer to GeoServer (2.1.4) and have hit a snag around PropertyIsLike. Whenever I include it in a getFeature's filter I get back a ServiceException as seen below. This is the filter sent to getFeature: <Filter xmlns='

  • Geoserver WFS get feature doesn't work - "SyntaxError: missing ; before statement"

    Geoserver WFS get feature doesn't work - "SyntaxError: missing ; before statement"December 3

    I'm trying to use geoserver WFS json for creating vector layer (instead of using WMS) because this is a layer I redraw every 20 seconds. This is the code I use : function getJSON() { var geoJsonUrl = "http://localhost:8080/geoserver/test/ows?service=

  • Using GeoServer WFS to GetFeature by Clicking on it on the mapSeptember 4

    Can someone point me to document of crafting a Geoserver WFS GetFeature request with CQL_Filters? I've already read the GeoServer CQL_Filter Geometric filter section I have a Geoserver WMS set up to return multiple polygon geometries (from a postgres

  • How to add GeoServer wfs layer on OpenLayers?

    How to add GeoServer wfs layer on OpenLayers?March 4

    I can't seem to add a WFS layer like this. It works when i copy all this code locally but as soon as i change the values to point to my own layer within my own GeoServer this is the response viewed in firebug: Could not locate {http://www.mydomain.co

  • Why am I getting this "Missing $ inserted" error in an algorithm figure just like all my other algorithm figures?December 14

    I'm writing a paper in LaTeX, and I'm getting a strange "Missing $ inserted" error when I try to compile the paper using pdflatex, but only if it contains the following code. \begin{algorithm*}[tbh] \begin{haskell} translate :: \textsc{Featherwe

  • Allow GeoServer WFS request by featureIDApril 6

    I'm not able to use the featureID parameter in a WFS URL request for my dataset on GeoServer. Example: http://demo.opengeo.org/geoserver/wfs?version=1.1.0&service=wfs&request=GetFeature&typeName=topp:tasmania_roads&maxFeatures=10&featu

  • Releasing GeoServer WFS-T Feature LockMay 24

    For some reason I'm having trouble finding any documentation about releasing feature locks in a GeoServer WFS (or any WFS for that matter). I can easily request a FeatureLock with a request like this http://localhost:8080/geoserver/wfs?service=WFS&ve

  • GeoServer WFS OpenLayers EditingPanel ProblemJune 13

    I'm trying to use OpenLayers to edit features of vector data served from a local geoserver. So far, I'm able to pull WMS and WFS layers using OpenLayers from the same geoserver. But now, I'd like enable editing of features of the vector layers. The r

  • msWFSGetFeature(): WFS server error. FLTApplyFilterToLayer() failed

    msWFSGetFeature(): WFS server error. FLTApplyFilterToLayer() failedOctober 10

    I have the following code that generates a map with a couple of layers. var PIDS = ["NSW502756064","NSW500951450","NSW500951433","NSW500951487","NSW500951527","NSW500951536","NSW502756058&qu

  • Missing $ inserted Error

    Missing $ inserted ErrorApril 5

    I am trying to use the CRPS formula in Latex and I am very new to it. I am getting a Missing $ inserted error from the equation below. I know it's a common problem, but I haven't been able to solve it. Please help! CRPS = \int_{-\infty }^{\infty } \l

  • LaTeX getting "Missing } inserted" errorMay 13

    I'm getting "Missing } inserted" error, when compiling with pdflatex and I really don't understand why. This is occurring in a beamer frame. Maybe someone comes up with something useful. \documentclass{beamer} ... \usepackage[utf8x]{inputenc} \u

  • Linguex errors: "missing $ or } inserted" errors with qtree and glossed examplesMay 30

    this is my first question and I'm quite new to this. I have started using the linguex package and it works with all my examples except those including trees (drawn using qtree) or those with glosses. It keeps throwing back about 8 "missing } inserted

  • SQL Insert error Column name or number of supplied values September 23

    I have one of the stored procedures for my replication giving this error Insert Error: Column name or number of supplied value does not match table definition". The stored procedure is spInsertsrra and the table is srra, I have put the syntax below f

Copyright (C) 2017 ceus-now.com, All Rights Reserved. webmaster#ceus-now.com 14 q. 0.481 s.