Hi, Does it mean that Oracle NG builds queries as nonquoted and the result is SELECT DATE FROM TABLE instead of SELECT "DATE" FROM "TABLE", that would work?
>From the referred Oracle document: "This section lists Oracle SQL reserved words. You cannot use Oracle SQL reserved words as nonquoted identifiers. Quoted identifiers can be reserved words, although this is not recommended." -Jukka Rahkonen- -----Alkuperäinen viesti----- Lähettäjä: Mark Prins <mc.pr...@gmail.com> Lähetetty: maanantai 3. elokuuta 2020 18.01 Vastaanottaja: geoserver-users@lists.sourceforge.net Aihe: Re: [Geoserver-users] WFS GetFeature does not work with field "DATE" 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 _______________________________________________ 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
