Correct. I raised the issue and also check commercial support.

Regards,
Laszlo

> On 2018. Apr 19., at 17:51, Ian Turton <ijtur...@gmail.com 
> <mailto:ijtur...@gmail.com>> wrote:
> 
> Don't randomly change the jars in a GeoServer install, many bad things can 
> happen and there is no guarantee that it will continue to work in the future 
> even if you get away with it now. 
> 
> Instead please raise an issue 
> (http://docs.geoserver.org/latest/en/user/introduction/gettinginvolved.html#bug-tracking
>  
> <http://docs.geoserver.org/latest/en/user/introduction/gettinginvolved.html#bug-tracking>)
>  and make sure that it gets fixed in later versions of GeoServer.  Since you 
> can afford Oracle you can find some time or cash to fix this issue too, right?
> 
> Ian
> 
> On 19 April 2018 at 16:41, Laszlo Nemeth <nemeth.las...@me.com 
> <mailto:nemeth.las...@me.com>> wrote:
> 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 
> > <mailto: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://slashdot.org/>! 
> http://sdm.link/slashdot <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#/ 
> <http://www.ianturton.com/talks/foss4g.html#/>
> - The GeoServer user list posting guidelines: 
> http://geoserver.org/comm/userlist-guidelines.html 
> <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
>  
> <https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer>
> 
> 
> Geoserver-users@lists.sourceforge.net 
> <mailto:Geoserver-users@lists.sourceforge.net>
> https://lists.sourceforge.net/lists/listinfo/geoserver-users 
> <https://lists.sourceforge.net/lists/listinfo/geoserver-users>
> 
> 
> 
> -- 
> Ian Turton
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org <http://slashdot.org/>! 
> http://sdm.link/slashdot_______________________________________________ 
> <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#/ 
> <http://www.ianturton.com/talks/foss4g.html#/>
> - The GeoServer user list posting guidelines: 
> http://geoserver.org/comm/userlist-guidelines.html 
> <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
>  
> <https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer>
> 
> 
> Geoserver-users@lists.sourceforge.net 
> <mailto:Geoserver-users@lists.sourceforge.net>
> https://lists.sourceforge.net/lists/listinfo/geoserver-users

------------------------------------------------------------------------------
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

Reply via email to