I am getting the below exception while editing and saving data in spatial table.
Response
<ows:ExceptionReport version="1.0.0"
xsi:schemaLocation="http://www.opengis.net/ows http://x.x.x.x:80/geoserver/schemas/ows/1.0.0/owsExceptionReport.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ows="http://www.opengis.net/ows">
<ows:Exception exceptionCode="NoApplicableCode">
<ows:ExceptionText>{http://x.x.x.x/geoserver/capacity/org}EDIT_TEST is read-only</ows:ExceptionText>
</ows:Exception>
</ows:ExceptionReport>
I checked the following as suggested in a previous thread:
- Primary Key – PK is available in the spatial table and type Number.
- User access – On geoserver in stores i have a 'XXXX' user and in oracle i have granted all privileges on the table. But still getting the same issue.
Do we need to do any settings on geoserver?
#
I have noticed that every time new FEATID is generating. Spatial table has primary key and sequence(tableName_colname_sequence). Can any one help me out why the correct featid is not going in the request
<wfs:Transaction xmlns:wfs="http://www.opengis.net/wfs" service="WFS" version="1.0.0" xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<wfs:Delete typeName="capacity:EDIT_TEST" xmlns:capacity="http://x.x.x.x/geoserver/capacity/org">
<ogc:Filter xmlns:ogc="http://www.opengis.net/ogc">
<ogc:FeatureId fid="EDIT_TEST.fid-270312d3_14ce5aac044_-7ce8"/>
</ogc:Filter></wfs:Delete>
</wfs:Transaction>
Best Answer
For anyone who is having the same issue, this worked for me:
Check if writing is allowed to anonymous user for all the workspace (..w), or create a new rule giving you access to the workspace in where your wfs-t layers are.
Try Again.