All issues

WFS-T is not working anymore with oracle updatable view
GEOS-9338
Uploading Geojson format to geonode 2.10.1, not all records in the features gets uploaded
GEOS-9325
Getting error in ysld and css style in GeoServer
GEOS-9310
Layer disappears when zooming out
GEOS-9233
Unauthenticated Vulnerability
GEOS-9201
App-Schema postgis online build is failling on GeoJsonOutputFormatWfsTest
GEOS-8999
Improper configuration exposing many sensitive credentials.
GEOS-8862
Centralize Freemarker configuration
GEOS-8825
PostScriptTransformTest recursively deletes entire system temporary directory
GEOS-8797
Bypass for GEOS-7848
GEOS-8552
CSS plugin not usable due to conflicting asm - versions
GEOS-8524
Cache client wms request
GEOS-8508
GetLegendGraphic request not working with layer groups in workspace
GEOS-8485
Style API : Unknown style format when charset is in content-type
GEOS-8475
Errors when trying to update Tile Layers property from GeoServer GUI
GEOS-8416
No HTTP resource was found
GEOS-8381
Issue in generating layer using SQL View
GEOS-8377
GetMap Request fails with NullPointerException
GEOS-8327
GWC returns a 400 error when trying to use default bounds for seeding layer
GEOS-8313
GWC Seed Form returns blank page when seeding a layer.
GEOS-8312
Error when trying to publish an Image Mosaic JDBC layer
GEOS-8278
On adding layers,some error occurs-"Oops, something went wrong... Sorry, something unexpected happened on the server."
GEOS-8233
On adding layers,some error occurs-"Oops, something went wrong... Sorry, something unexpected happened on the server."
GEOS-8232
WFS geometry or/and attributes issues
GEOS-8109
CapabilitiesCacheHeadersCallback should not set eTag, causes clients to cache capabilities when dimension values changes
GEOS-8071
GWC Data Security Vulnerability
GEOS-8041
Cannot edit style after adding the gwc-sqlite plugin
GEOS-7925
Memory leak in WMS GetFeatureInfo GML3 encoding
GEOS-7887
Unable to create layer with ImageMosiac
GEOS-7879
WFS v2.0 getFeature KVP requests using typenames parameter fail
GEOS-7842
GeoServer 2.10-RC1 not known to windows "smartscreen"
GEOS-7808
CSW Service does not work anymore due to "EntityResolver" bean circular reference
GEOS-7805
GEOS-7753 fix that makes it impossible to create any WMS Cascaded store
GEOS-7776
XYZ tile server host name
GEOS-7765
XYZ tile server host name
GEOS-7764
Cannot update existing store configuration, GeoServer complains with a "store already exists" error
GEOS-7753
GeoServer tiled layer are not loaded due Spring beans cyclic dependencies, GWC integration deletes the layer configurations as a result
GEOS-7750
Window installer changes port not working
GEOS-7677
Recursive copy method on Resources fails with infinite recursion
GEOS-7611
Wrong background values with ImageMosaicJDBC and 32bit Real images
GEOS-7582
WFS-T Error While Committing Changes in 3857
GEOS-7581
geoserver 2.9RC1 does not start with imagemap extension installed
GEOS-7539
Error Startup GeoServer
GEOS-7528
Windows exe installer fails to start GeoServer
GEOS-7527
Unable to start DMG due to spring-security exception
GEOS-7508
update to spring 4
GEOS-7504
2.9 Master does not start on Windows
GEOS-7485
problems with INSPIRE xsd schema use in Application schema
GEOS-7484
Fails to start in Tomcat with extensions installed
GEOS-7472
Invalid directory timestamp assumptions in ResourceTest break build on Windows
GEOS-7436
issue 1 of 9352

WFS-T is not working anymore with oracle updatable view

Description

Hello dears,
previously I was working with geoserver 2.11.2 using WFS-T with oracle updatable view.
But now in the version 2.15.1 it is not working anymore. I am getting the exception:
ERROR [org.geoserver.ows] - org.geoserver.wfs.WFSTransactionException: {http://www.opengeospatial.net/cite}TESTVIEW is read-only

To working with oracle updatable view, I follow the steps:
a) create the view:
CREATE VIEW TESTVIEW AS
SELECT a.ID, foo.somefield, a.some_other_id, a.GEOMETRY
FROM FOO foo, AREA a
WHERE foo.ID = a.SOME_OTHER_ID;

b) create the trigger on this view to accept "update" statement:
CREATE OR REPLACE TRIGGER AREA_INSERT
INSTEAD OF INSERT ON TESTVIEW
REFERENCING NEW AS n
FOR EACH ROW
BEGIN
insert into area (id, some_other_id, geometry) values (:n.ID, :n.some_other_id, :n.geometry);
END;
/

c) insert in sdo_geom_metadata
insert into USER_SDO_GEOM_METADATA (table_name, column_name, diminfo, srid)
values ('TESTVIEW ',
'GEOMETRY',
SDO_DIM_ARRAY
(
SDO_DIM_ELEMENT('X',50199, 761274,0.5),
SDO_DIM_ELEMENT('Y',6582464, 7799839,0.5)
),
3047);

d) create "disable" primary key on the view:
alter view TESTVIEW add constraint TESTVIEW_PK primary key (ID) disable;

So, if I do all the steps below on geoserver 2.11.2 it will work.
If I miss the step (d) above, I have the "read-only" exception. So, this step (d) is needed

But now in the version 2.15.1 it is not working anymore if I execute all the steps above.
Some changes was done in the oracle-plugin?

I will apreciate if anyone can check this problem!!!

Many Thanks guys!!!!!!

Paulo

Environment

None

Status

Assignee

Unassigned

Reporter

Paulo Aragão

Triage

Fix versions

None

Affects versions

2.15.1

Components

Priority

Highest
Configure