Hi, Just to have it in the archive I have found a workaround for this error. The current version of gt-jdbc-oracle uses a “new” Oracle JDBC feature to get the DB generated ID of new record inserted by using Oracle RETURNING clause feature under the hook. By reverting back to gt-jdbc-oracle-14.5.jar (simple download it from the archive and replace gt-jdbc-oracle-X-Y.jar in WEB-INF/lib and restarting geoserver resolves the ERROR.
I guess that the newer version has couple of optimizations that are lost by this fallback to old version, so the prefect solution would be to include a config option where to use this feature or not (may be by featuretype). Regards, Laszlo > On 2018. Apr 19., at 11:21, Laszlo Nemeth <nemeth.las...@me.com> wrote: > > Hi, > > We have a geoserver 2.8.5 version where the above works fine. > When we upgrade to geoserver 2.12 and try to create new feature via WFS in a > featuretype that is based on Oracle view with instead of trigger we get to > following error: > > ORA-22816: unsupported feature with RETURNING clause > > I have read the discussion when 2.9 was lauched that someone also had same > problem, but did not see any resolution. Do you have a workaround for this? > > Thank you, > Laszlo ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
