Open 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
Unauthenticated Vulnerability
GEOS-9201
Bypass for GEOS-7848
GEOS-8552
Error when trying to publish an Image Mosaic JDBC layer
GEOS-8278
Wrong background values with ImageMosaicJDBC and 32bit Real images
GEOS-7582
Rendering process failed java.io.IOException No more data to read from socket
GEOS-7021
LDAP authentication fails with "invalid DN"
GEOS-6894
WCS 2 - CRS Extension not implemented correctly
GEOS-9328
Importer DataStore connection error when running multiple tasks
GEOS-9323
Geoserver is using a version of Xstream that has known vulnerabilities
GEOS-9307
The develop manual "Implementing a RESTful Service" of GeoServer 2.14.x is incorrect
GEOS-9306
json response is not consistent for get layers REST call
GEOS-9300
GeoFence and External Web Map Server
GEOS-9294
SLDService raster classifier updates layer default style by mistake
GEOS-9208
external legend graphics problems using GeoServer 2.14
GEOS-9177
contents.ftl template parsing a hash causes Service Exception
GEOS-9089
[Backup & Restore] Improve the module Documentation with the latest fixes/improvements
GEOS-9078
TileMatrixSets' supported CRS are ignored when consuming WMTS service
GEOS-9042
File upload via /rest/resource interface results in unusable files.
GEOS-8998
[Label Placement] Baseline is displaced when the label has line breaks and descenders
GEOS-8975
Creating ImageMosaic with Geoserver REST API produces inappropriate coverage parameters types
GEOS-8745
A bunch of Accentuated words are broken since 2.13.0 (french é => � )
GEOS-8731
gwc style and layer workspace global services disabled
GEOS-8704
Problem with GeoFence roles checking
GEOS-8686
Error during GeoServer bootstrapping (InsufficientAuthenticationException)
GEOS-8654
Enabling CSW in workspace does not work
GEOS-8625
http error: 404 when install jai_imageio
GEOS-8594
NetCDF Auxiliary Store reports error file doesn't exist when file is present
GEOS-8584
REST API - Add an option to get all LayerGroups, with and without a workspace specified
GEOS-8518
NPE on cascaded WMS during GetMap (ResourcePool.getWMSLayer)
GEOS-8268
Unable to create layers using MBTiles
GEOS-8241
CLONE - GeoWebCache settings won't be persisted on Windows
GEOS-7783
After update grib file I have carusel of dimension name (depth_below_sea, depth_below_sea1, depth_below_sea2). No way to configure dimension.
GEOS-7714
Signed 8bit
GEOS-7590
Porter-Duff composite is wrong when tiled option is true
GEOS-7569
ImageMosaic GetFeatureInfo returning wrong value
GEOS-7568
WFS version 2.0.0 requests with Filter String Property Literals starting with leading zero returns not working
GEOS-7540
Windows service wrapper appears to have problematic license
GEOS-7488
Java process segfault in LCMS library
GEOS-7458
Digest authentication is broken
GEOS-7404
java.lang.ClassCastException: java.util.ArrayList cannot be cast to org.opengis.feature.type.AttributeDescriptor
GEOS-7244
bad or not json output via rest call to layergroup
GEOS-7232
ArcSDE Direct Connect not working
GEOS-7179
Inconsistent value for "Infinite" and "-Infinity" in WFS-GML : getting INF anf -Infinity
GEOS-4909
WCS Memory Leak
GEOS-3219
Update data rules (layer and layer groups) rules at runtime
GEOS-9343
Add 'Building Windows Installer' instruction to online manual
GEOS-9342
Misaligned tile contents when rendering heterogenenous CRS mosaics, with reprojection, APH enabled, and high oversampling
GEOS-9341
issue 1 of 897

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