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
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
