[Geoserver-users] WFST & PostGIS

GeoServer GeoServer User
,
1

Hi friends

I use Apache Tomcat/6.0.35, JVM v.1.7.0_01-B08 on OS Windows7 x86. Geoserver
version is 2.1.3 (web archive). I created a simple client (OpenLayers,
GeoExt), which is capable of transaction. WFS-T thus works well, but only if
the source of my data are shapefiles. These data are in the WGS84 coordinate
system. I tried to import a shapefile into Postgre / PostGIS (v.9.1 /
v.1.5.3) database (I had to change UTF-8 to Latin1, or else import has taken
place at all and ended with an error message). I have published data from
PostGIS via Geoserver (login account is a superuser database owner). I am
able to display the data through WMS and WFS, but I can not execute the
transaction.

I tried to download uDig. uDig starts and everything looks normal, but is
unable to even connect to the WMS or the WFS. QGIS when trying to connect to
WFS freezes and crashes, so I can not tell if the problem is client side :frowning:
I only know that it is possible to edit shapefile without any problems.

If you have anyone any ideas I will be more than grateful

Regards
Tom

--
View this message in context: http://osgeo-org.1560.n6.nabble.com/WFST-PostGIS-tp4366563p4366563.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

2

SOLVED!

Problem was that PostGIS shapefile loader automatically create a certain
number of conditions and the transaction violated one of them ...

Postgre log:
2012-02-05 13:40:56 CET ERROR: new row for relation "elektricke_vedenie"
violates check constraint "enforce_dims_the_geom"
2012-02-05 13:40:56 CET STATEMENT: UPDATE "public"."elektricke_vedenie" SET
"the_geom" = GeomFromText('MULTILINESTRING ((17.850093643000037
48.60069691000007, 17.849979295000082 48.60007773500007, 17.84997108300007
48.60003327900006, 17.84997063500009 48.60003084900006, 17.886989221295853
48.59571862543119))', 4326),"dow" = '2007-07-05Z',"aut" = 1,"ach" = 1,"acv"
= 1,"soi" = 1,"cnf" = 1,"facc" = '1',"nap" = 1,"txt" = '1',"shape_leng" =
0.00076667831409 WHERE ("gid" = '37')

--
View this message in context: http://osgeo-org.1560.n6.nabble.com/WFST-PostGIS-tp4366563p4366696.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

3

Hi Tom,

check out this ticket (fixed in your GS version, but maybe related anyway)
http://jira.codehaus.org/browse/GEOS-4854

I have got many strange problems with JVM 1.7, maybe switching to 1.6 helps.

kind regards
Jørn-Vegard Røsnes

----- Original Message -----
From: "Tondo" <gpktondo@anonymised.com>
To: geoserver-users@lists.sourceforge.net
Sent: Sunday, 5 February, 2012 12:44:41 PM
Subject: [Geoserver-users] WFST & PostGIS

Hi friends

I use Apache Tomcat/6.0.35, JVM v.1.7.0_01-B08 on OS Windows7 x86. Geoserver
version is 2.1.3 (web archive). I created a simple client (OpenLayers,
GeoExt), which is capable of transaction. WFS-T thus works well, but only if
the source of my data are shapefiles. These data are in the WGS84 coordinate
system. I tried to import a shapefile into Postgre / PostGIS (v.9.1 /
v.1.5.3) database (I had to change UTF-8 to Latin1, or else import has taken
place at all and ended with an error message). I have published data from
PostGIS via Geoserver (login account is a superuser database owner). I am
able to display the data through WMS and WFS, but I can not execute the
transaction.

I tried to download uDig. uDig starts and everything looks normal, but is
unable to even connect to the WMS or the WFS. QGIS when trying to connect to
WFS freezes and crashes, so I can not tell if the problem is client side :frowning:
I only know that it is possible to edit shapefile without any problems.

If you have anyone any ideas I will be more than grateful

Regards
Tom

--
View this message in context: http://osgeo-org.1560.n6.nabble.com/WFST-PostGIS-tp4366563p4366563.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users