Cannot update a postgis table using WFS 1.0/1.1
-----------------------------------------------
Key: GEOS-4342
URL: http://jira.codehaus.org/browse/GEOS-4342
Project: GeoServer
Issue Type: Bug
Components: WFS
Environment: Windows XP, Geoserver latest trunk, PostgreSQL 8.4
Reporter: Zsolt Sandor
Assignee: Andrea Aime
Attachments: wfs-bugreport.zip
Action:
I tried to use WFS to update the coordinates of a polygon in our postgis database.
Result:
The result is either no action or an Exception/Stacktrace.
"Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block."
Steps to reproduce:
- Install postgresql with postgis extension
- Create a table called gis_fence and wrote a single line in it (see attachment)
- Create a new datasource and layer, called gis_fence to the cite namespace.
- Run the WFS queries (wfs-update-10.txt,wfs-update-11.txt)
Geoserver log, SQL and WFS scripts are in the attachment.
Remarks:
One problem may be in JDBCDataStore class's getBounds() method, because the optimized table does not exists, an SQL is started to retrieve the data, and this is the point where the exception raises.
This SQL works from command line...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira