On 03-08-2020 11:00, d'Orio, Pietro wrote:
If an Oracle NG (JNDI) layer contain a field “DATE” the WFS does not
work for this layer.
Also other “sensitive” oracle DB tags like “SIZE” or “LOCATION” cause
the same problem.
A special note: "TYPE" does not cause problems
TYPE is not in the list:
https://docs.oracle.com/database/121/SQLRF/ap_keywd001.htm#SQLRF55621
(but neither is LOCATION or SIZE so I'm not sure what is going on there)
If you set up geoserver with geotools developer or debug logging you can
see the generated queries in the log.
As linked there
https://docs.oracle.com/database/121/REFRN/GUID-6D03E5B5-A23B-499C-B6BC-A31A12FC6C7D.htm#REFRN30204
talks about which words vcaanot be used where in Orcla, documented in
V$RESERVED_WORDS in your database (the list can/will vary between versions)
- M
_______________________________________________
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
