[Geoserver-users] WFS GetFeature does not work with field "DATE"

Jukka_Rahkonen · August 3, 2020, 5:27pm

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.prins@anonymised.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

Andrea_Aime4 · August 3, 2020, 6:07pm

Hi Jukka,
having a quick look at the code, indeed the name quoting is explicitly disabled in Oracle,
and it has been since many years (probably since the version of the Oracle support code).
If memory serves me correctly, Oracle Spatial has some weird naming limitations on top
of the already restrictive Oracle naming conventions… something like, table and geometry
columns must actually be all uppercase in the queries for anything to work (can’t remember exactly).
Cheers

Andrea

···

Regards, Andrea Aime

== GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A 55054 Massarosa (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it ------------------------------------------------------- Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia. This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail.

Richard_Duivenvoord1 · August 3, 2020, 6:20pm

Also see the answer of Stefan in the issue Pietro created:
https://osgeo-org.atlassian.net/browse/GEOS-9712

Regards,

Richard Duivenvoorde

On 8/3/20 8:07 PM, Andrea Aime wrote:

Hi Jukka,
having a quick look at the code, indeed the name quoting is explicitly disabled in Oracle,
and it has been since many years (probably since the version of the Oracle support code).
If memory serves me correctly, Oracle Spatial has some weird naming limitations on top
of the already restrictive Oracle naming conventions... something like, table and geometry
columns must actually be all uppercase in the queries for anything to work (can't remember exactly).
Cheers
Andrea

On Mon, Aug 3, 2020 at 7:41 PM Rahkonen Jukka (MML) <jukka.rahkonen@...6847... <mailto:jukka.rahkonen@…6847…>> wrote:

    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.prins@...84... <mailto:mc.prins@…84…>>
    Lähetetty: maanantai 3. elokuuta 2020 18.01
    Vastaanottaja: geoserver-users@lists.sourceforge.net <mailto: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 <mailto: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 <mailto:Geoserver-users@lists.sourceforge.net>
    https://lists.sourceforge.net/lists/listinfo/geoserver-users

--

Regards, Andrea Aime

== GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A 55054 Massarosa (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it ------------------------------------------------------- /Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia. This email is intended only for the person or entity to which it is addressed and may contain
information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail./

_______________________________________________
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

d_Orio_Pietro · August 4, 2020, 9:39am

The following keywords don't make problem:
- ID, GEOMETRY, TYPE

The query on DB is like: SELECT GEOMETRY AS GEOMETRY FROM TABLE

The following makes problem:
- LEVEL, DATE

i have to rename the view fields, but i think is a mistake that some sensible oracle keywords works and other not…

If I have an obligation to display the data according to specifications, I can't! For example, Inspire provides for some fields called "LEVEL".

Regards

-----Messaggio originale-----
Da: Richard Duivenvoorde <rdmailings@...5924...>
Inviato: lunedì 3 agosto 2020 20:20
A: andrea.aime@...1107...; Rahkonen Jukka (MML) <jukka.rahkonen@...6847...>
Cc: geoserver-users@lists.sourceforge.net
Oggetto: Re: [Geoserver-users] WFS GetFeature does not work with field "DATE"

Also see the answer of Stefan in the issue Pietro created:
https://osgeo-org.atlassian.net/browse/GEOS-9712

Regards,

Richard Duivenvoorde

On 8/3/20 8:07 PM, Andrea Aime wrote:

Hi Jukka,
having a quick look at the code, indeed the name quoting is explicitly
disabled in Oracle, and it has been since many years (probably since the version of the Oracle support code).
If memory serves me correctly, Oracle Spatial has some weird naming
limitations on top of the already restrictive Oracle naming
conventions... something like, table and geometry columns must actually be all uppercase in the queries for anything to work (can't remember exactly).
Cheers
Andrea

On Mon, Aug 3, 2020 at 7:41 PM Rahkonen Jukka (MML) <jukka.rahkonen@...6847... <mailto:jukka.rahkonen@…6847…>> wrote:

    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.prins@...84... <mailto:mc.prins@…84…>>
    Lähetetty: maanantai 3. elokuuta 2020 18.01
    Vastaanottaja: geoserver-users@lists.sourceforge.net <mailto: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-an
d-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

    _______________________________________________
    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-an
d-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

--

Regards, Andrea Aime

== GeoServer Professional Services from the experts! Visit
http://goo.gl/it488V for more information. == Ing. Andrea Aime
@geowolf Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A
55054 Massarosa (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob:
+39 339 8844549 http://www.geo-solutions.it
http://twitter.com/geosolutions_it
------------------------------------------------------- /Con
riferimento alla normativa sul trattamento dei dati personali (Reg. UE
2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si
precisa che ogni circostanza inerente alla presente email (il suo
contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è
riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il
messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra
operazione è illecita. Le sarei comunque grato se potesse darmene
notizia. This email is intended only for the person or entity to which
it is addressed and may contain information that is privileged,
confidential or otherwise protected from disclosure. We remind that -
as provided by European Regulation 2016/679 “GDPR” - copying,
dissemination or use of this e-mail or the information herein by
anyone other than the intended recipient is prohibited. If you have
received this email by mistake, please notify us immediately by
telephone or e-mail./

_______________________________________________
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-an
d-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

ianturton · August 4, 2020, 12:11pm

It should be relatively easy to modify encodeColumnName in OracleDialect to surround reserved words with " - and possibly make use of the sqlNameEscape value and escapeName function in FilterToSql too

Ian

···

Ian Turton

Andrea_Aime4 · August 4, 2020, 12:20pm

Hi Ian,
the thing is, that would be the default behavior, and it has been explicitly overridden so it does not happen.
Goes way back, it’s not covered by the git history, one would have to check in the old SVN history to
see if there is a commit about it.

Had a very quick look, 2.6.0 is the first tag where the OracleDialect class appears in its present location,
and it was already like that, search for “getNameEscape”:
https://svn.osgeo.org/geotools/tags/2.6.0/modules/plugin/jdbc/jdbc-oracle/src/main/java/org/geotools/data/oracle/OracleDialect.java

Going back to the pre-JDBCDataStore times, the stand-alone oracle-spatial module also did not escape names, e.g.:
https://svn.osgeo.org/geotools/tags/2.5.0/modules/unsupported/oracle-spatial/src/main/java/org/geotools/data/oracle/SqlStatementEncoder.java

Cheers
Andrea

···

Regards, Andrea Aime

== GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A 55054 Massarosa (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it ------------------------------------------------------- Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia. This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail.

ianturton · August 4, 2020, 12:29pm

That is odd, especially as OraclFilterToSQL calls setSqlNameEscape(“"”) in it’s constructor. Since we currently have working Oracle CI tests I may have a quick go at an update,

Note that encodeColumnName does include the following:
// need to quote column names with spaces in
if (raw.contains(" ")) {
raw = “"” + raw + “"”;
}

Ian

···

Ian Turton

Andrea_Aime4 · August 4, 2020, 12:32pm

Sure. If you want to run tests locally the same docker setup can be duplicated locally easy enough, there is some description here:
https://docs.geotools.org/latest/developer/conventions/test/online.html#oracle-xe

Cheers
Andrea

···

== GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A 55054 Massarosa (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it ------------------------------------------------------- Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia. This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail.

Humphries_Graham · August 4, 2020, 9:55pm

Can you use an alias, eg:
Select my_level as "LEVEL", my_date as "DATE" from table

-----Original Message-----
From: d'Orio, Pietro [mailto:Pietro.dOrio@…10303…]
Sent: Tuesday, 4 August 2020 7:40 PM
To: rdmailings@...5924...; andrea.aime@...1107...; Rahkonen Jukka (MML) <jukka.rahkonen@...6847...>
Cc: geoserver-users@lists.sourceforge.net
Subject: [Geoserver-users] R: WFS GetFeature does not work with field "DATE"

The following keywords don't make problem:
- ID, GEOMETRY, TYPE

The query on DB is like: SELECT GEOMETRY AS GEOMETRY FROM TABLE

The following makes problem:
- LEVEL, DATE

i have to rename the view fields, but i think is a mistake that some sensible oracle keywords works and other not…

If I have an obligation to display the data according to specifications, I can't! For example, Inspire provides for some fields called "LEVEL".

Regards

-----Messaggio originale-----
Da: Richard Duivenvoorde <rdmailings@...5924...>
Inviato: lunedì 3 agosto 2020 20:20
A: andrea.aime@...1107...; Rahkonen Jukka (MML) <jukka.rahkonen@...6847...>
Cc: geoserver-users@lists.sourceforge.net
Oggetto: Re: [Geoserver-users] WFS GetFeature does not work with field "DATE"

Also see the answer of Stefan in the issue Pietro created:
https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fosgeo-org.atlassian.net%2Fbrowse%2FGEOS-9712&data=02|01|graham.humphries%40stategrowth.tas.gov.au|961fdcc5f6344f5f98e908d83867ae67|64ebab8accf44b5ca2d32b4e972d96b2|0|0|637321366417078070&sdata=uWK%2BksO7dB7AA6%2F30KpIWDuMTlvKSTyCWxqFjMnBXW8%3D&reserved=0

Regards,

Richard Duivenvoorde

On 8/3/20 8:07 PM, Andrea Aime wrote:

Hi Jukka,
having a quick look at the code, indeed the name quoting is explicitly
disabled in Oracle, and it has been since many years (probably since the version of the Oracle support code).
If memory serves me correctly, Oracle Spatial has some weird naming
limitations on top of the already restrictive Oracle naming
conventions... something like, table and geometry columns must actually be all uppercase in the queries for anything to work (can't remember exactly).
Cheers
Andrea

On Mon, Aug 3, 2020 at 7:41 PM Rahkonen Jukka (MML) <jukka.rahkonen@...6847... <mailto:jukka.rahkonen@…6847…>> wrote:

    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.prins@...84... <mailto:mc.prins@…84…>>
    Lähetetty: maanantai 3. elokuuta 2020 18.01
    Vastaanottaja: geoserver-users@lists.sourceforge.net <mailto: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://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.oracle.com%2Fdatabase%2F121%2FSQLRF%2Fap_keywd001.htm%23SQLRF55621&data=02|01|graham.humphries%40stategrowth.tas.gov.au|961fdcc5f6344f5f98e908d83867ae67|64ebab8accf44b5ca2d32b4e972d96b2|0|0|637321366417078070&sdata=5Dx7XwlmoQAEY3HxJuZlWxSUrWIcYGWihlB9Rjc1mMA%3D&reserved=0
    (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://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.oracle.com%2Fdatabase%2F121%2FREFRN%2FGUID-6D03E5B5-A23B-499C-B6BC-A31A12FC6C7D.htm%23REFRN30204&data=02|01|graham.humphries%40stategrowth.tas.gov.au|961fdcc5f6344f5f98e908d83867ae67|64ebab8accf44b5ca2d32b4e972d96b2|0|0|637321366417078070&sdata=qJziSJsx6zliYQohAyOvM3FaQVLWHsfXTtqcGdpRBdc%3D&reserved=0
    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: https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.ianturton.com%2Ftalks%2Ffoss4g.html%23%2F&data=02|01|graham.humphries%40stategrowth.tas.gov.au|961fdcc5f6344f5f98e908d83867ae67|64ebab8accf44b5ca2d32b4e972d96b2|0|0|637321366417078070&sdata=I56KsEcHPrASTe775t1a5Bbkh%2BVV1CVJBQEoNhuUKoM%3D&reserved=0
    - The GeoServer user list posting guidelines:
https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgeose
rver.org%2Fcomm%2Fuserlist-guidelines.html&data=02%7C01%7Cgraham.h
umphries%40stategrowth.tas.gov.au%7C961fdcc5f6344f5f98e908d83867ae67%7
C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637321366417078070&sda
ta=rYnBUrqCp4s0fQZejNud7X%2F0%2FknxN4Iq2raFGSJI06Q%3D&reserved=0

    If you want to request a feature or an improvement, also see this:
https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgith
ub.com%2Fgeoserver%2Fgeoserver%2Fwiki%2FSuccessfully-requesting-an&amp
;data=02%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C961fdcc5f6
344f5f98e908d83867ae67%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C63
7321366417078070&sdata=bkOtBCDyIkOVkLOr2rE2DZnES88kAXQ5FeKe4UmM5hI
%3D&reserved=0
d-integrating-new-features-and-improvements-in-GeoServer

    Geoserver-users@lists.sourceforge.net <mailto:Geoserver-users@lists.sourceforge.net>

https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flist
s.sourceforge.net%2Flists%2Flistinfo%2Fgeoserver-users&data=02%7C0
1%7Cgraham.humphries%40stategrowth.tas.gov.au%7C961fdcc5f6344f5f98e908
d83867ae67%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C63732136641707
8070&sdata=PsCYdBR3ITVBiHpQZFgaX2TTEm3C5VtAYGg23xbt28s%3D&rese
rved=0

    _______________________________________________
    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: https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.ianturton.com%2Ftalks%2Ffoss4g.html%23%2F&data=02|01|graham.humphries%40stategrowth.tas.gov.au|961fdcc5f6344f5f98e908d83867ae67|64ebab8accf44b5ca2d32b4e972d96b2|0|0|637321366417078070&sdata=I56KsEcHPrASTe775t1a5Bbkh%2BVV1CVJBQEoNhuUKoM%3D&reserved=0
    - The GeoServer user list posting guidelines:
https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgeose
rver.org%2Fcomm%2Fuserlist-guidelines.html&data=02%7C01%7Cgraham.h
umphries%40stategrowth.tas.gov.au%7C961fdcc5f6344f5f98e908d83867ae67%7
C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637321366417078070&sda
ta=rYnBUrqCp4s0fQZejNud7X%2F0%2FknxN4Iq2raFGSJI06Q%3D&reserved=0

    If you want to request a feature or an improvement, also see this:
https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgith
ub.com%2Fgeoserver%2Fgeoserver%2Fwiki%2FSuccessfully-requesting-an&amp
;data=02%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C961fdcc5f6
344f5f98e908d83867ae67%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C63
7321366417078070&sdata=bkOtBCDyIkOVkLOr2rE2DZnES88kAXQ5FeKe4UmM5hI
%3D&reserved=0
d-integrating-new-features-and-improvements-in-GeoServer

    Geoserver-users@lists.sourceforge.net <mailto:Geoserver-users@lists.sourceforge.net>

https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flist
s.sourceforge.net%2Flists%2Flistinfo%2Fgeoserver-users&data=02%7C0
1%7Cgraham.humphries%40stategrowth.tas.gov.au%7C961fdcc5f6344f5f98e908
d83867ae67%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C63732136641707
8070&sdata=PsCYdBR3ITVBiHpQZFgaX2TTEm3C5VtAYGg23xbt28s%3D&rese
rved=0

--

Regards, Andrea Aime

== GeoServer Professional Services from the experts! Visit
https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgoo.g
l%2Fit488V&data=02%7C01%7Cgraham.humphries%40stategrowth.tas.gov.a
u%7C961fdcc5f6344f5f98e908d83867ae67%7C64ebab8accf44b5ca2d32b4e972d96b
2%7C0%7C0%7C637321366417078070&sdata=UztavBVfPlcQyx5URCJb6ghJz4aB2
IYWnl0jGaEqmvQ%3D&reserved=0 for more information. == Ing. Andrea
Aime @geowolf Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A
55054 Massarosa (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob:
+39 339 8844549
+https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.
+geo-solutions.it%2F&data=02%7C01%7Cgraham.humphries%40stategrowth
+.tas.gov.au%7C961fdcc5f6344f5f98e908d83867ae67%7C64ebab8accf44b5ca2d3
+2b4e972d96b2%7C0%7C0%7C637321366417078070&sdata=Z6DgPtateorrMMso8
+Vfq7NndW1T6HB37x%2F6QO%2FYbRzw%3D&reserved=0
https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Ftwitt
er.com%2Fgeosolutions_it&data=02%7C01%7Cgraham.humphries%40stategr
owth.tas.gov.au%7C961fdcc5f6344f5f98e908d83867ae67%7C64ebab8accf44b5ca
2d32b4e972d96b2%7C0%7C0%7C637321366417078070&sdata=75THPOEfgg3tBuY
GMY1i1iBl%2Fr66ufmnIqI9htbZXjc%3D&reserved=0
------------------------------------------------------- /Con
riferimento alla normativa sul trattamento dei dati personali (Reg. UE
2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si
precisa che ogni circostanza inerente alla presente email (il suo
contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è
riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il
messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra
operazione è illecita. Le sarei comunque grato se potesse darmene
notizia. This email is intended only for the person or entity to which
it is addressed and may contain information that is privileged,
confidential or otherwise protected from disclosure. We remind that -
as provided by European Regulation 2016/679 “GDPR” - copying,
dissemination or use of this e-mail or the information herein by
anyone other than the intended recipient is prohibited. If you have
received this email by mistake, please notify us immediately by
telephone or e-mail./

_______________________________________________
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:
https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.i
anturton.com%2Ftalks%2Ffoss4g.html%23%2F&data=02%7C01%7Cgraham.hum
phries%40stategrowth.tas.gov.au%7C961fdcc5f6344f5f98e908d83867ae67%7C6
4ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637321366417078070&sdata
=I56KsEcHPrASTe775t1a5Bbkh%2BVV1CVJBQEoNhuUKoM%3D&reserved=0
- The GeoServer user list posting guidelines:
https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgeose
rver.org%2Fcomm%2Fuserlist-guidelines.html&data=02%7C01%7Cgraham.h
umphries%40stategrowth.tas.gov.au%7C961fdcc5f6344f5f98e908d83867ae67%7
C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637321366417088067&sda
ta=5AQXDG5c0RiK9yhqNpJmPOU2F7f8QINhOCKYN0HG3I8%3D&reserved=0

If you want to request a feature or an improvement, also see this:
https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgith
ub.com%2Fgeoserver%2Fgeoserver%2Fwiki%2FSuccessfully-requesting-an&amp
;data=02%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C961fdcc5f6
344f5f98e908d83867ae67%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C63
7321366417088067&sdata=kQYM2gS%2BZ1tY7K%2FCkap3mxkMatdjSbVSU%2Bwfw
3N%2FBmY%3D&reserved=0
d-integrating-new-features-and-improvements-in-GeoServer

Geoserver-users@lists.sourceforge.net
https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flist
s.sourceforge.net%2Flists%2Flistinfo%2Fgeoserver-users&data=02%7C0
1%7Cgraham.humphries%40stategrowth.tas.gov.au%7C961fdcc5f6344f5f98e908
d83867ae67%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C63732136641708
8067&sdata=G46O%2B3q2SqkKZunlwOoIR%2BjIPXr8nr9d%2BeldKzpeXdQ%3D&am
p;reserved=0

_______________________________________________
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: https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.ianturton.com%2Ftalks%2Ffoss4g.html%23%2F&data=02|01|graham.humphries%40stategrowth.tas.gov.au|961fdcc5f6344f5f98e908d83867ae67|64ebab8accf44b5ca2d32b4e972d96b2|0|0|637321366417088067&sdata=hRSIbKe62c%2F5Chhu%2B9iXDzixkdhQCP8qUlH4WJOrxSs%3D&reserved=0
- The GeoServer user list posting guidelines: https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgeoserver.org%2Fcomm%2Fuserlist-guidelines.html&data=02|01|graham.humphries%40stategrowth.tas.gov.au|961fdcc5f6344f5f98e908d83867ae67|64ebab8accf44b5ca2d32b4e972d96b2|0|0|637321366417088067&sdata=5AQXDG5c0RiK9yhqNpJmPOU2F7f8QINhOCKYN0HG3I8%3D&reserved=0

If you want to request a feature or an improvement, also see this: https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fgeoserver%2Fgeoserver%2Fwiki%2FSuccessfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer&data=02|01|graham.humphries%40stategrowth.tas.gov.au|961fdcc5f6344f5f98e908d83867ae67|64ebab8accf44b5ca2d32b4e972d96b2|0|0|637321366417088067&sdata=yuzo971p3z36zMDhA28KapMP86%2F%2F5N6VPxfVPvmNBZc%3D&reserved=0

Geoserver-users@lists.sourceforge.net
https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.sourceforge.net%2Flists%2Flistinfo%2Fgeoserver-users&data=02|01|graham.humphries%40stategrowth.tas.gov.au|961fdcc5f6344f5f98e908d83867ae67|64ebab8accf44b5ca2d32b4e972d96b2|0|0|637321366417088067&sdata=G46O%2B3q2SqkKZunlwOoIR%2BjIPXr8nr9d%2BeldKzpeXdQ%3D&reserved=0

_______________________________________________
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: https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.ianturton.com%2Ftalks%2Ffoss4g.html%23%2F&data=02|01|graham.humphries%40stategrowth.tas.gov.au|961fdcc5f6344f5f98e908d83867ae67|64ebab8accf44b5ca2d32b4e972d96b2|0|0|637321366417088067&sdata=hRSIbKe62c%2F5Chhu%2B9iXDzixkdhQCP8qUlH4WJOrxSs%3D&reserved=0
- The GeoServer user list posting guidelines: https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgeoserver.org%2Fcomm%2Fuserlist-guidelines.html&data=02|01|graham.humphries%40stategrowth.tas.gov.au|961fdcc5f6344f5f98e908d83867ae67|64ebab8accf44b5ca2d32b4e972d96b2|0|0|637321366417088067&sdata=5AQXDG5c0RiK9yhqNpJmPOU2F7f8QINhOCKYN0HG3I8%3D&reserved=0

If you want to request a feature or an improvement, also see this: https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fgeoserver%2Fgeoserver%2Fwiki%2FSuccessfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer&data=02|01|graham.humphries%40stategrowth.tas.gov.au|961fdcc5f6344f5f98e908d83867ae67|64ebab8accf44b5ca2d32b4e972d96b2|0|0|637321366417088067&sdata=yuzo971p3z36zMDhA28KapMP86%2F%2F5N6VPxfVPvmNBZc%3D&reserved=0

Geoserver-users@lists.sourceforge.net
https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.sourceforge.net%2Flists%2Flistinfo%2Fgeoserver-users&data=02|01|graham.humphries%40stategrowth.tas.gov.au|961fdcc5f6344f5f98e908d83867ae67|64ebab8accf44b5ca2d32b4e972d96b2|0|0|637321366417088067&sdata=G46O%2B3q2SqkKZunlwOoIR%2BjIPXr8nr9d%2BeldKzpeXdQ%3D&reserved=0

________________________________

CONFIDENTIALITY NOTICE AND DISCLAIMER
The information in this transmission may be confidential and/or protected by legal professional privilege, and is intended only for the person or persons to whom it is addressed. If you are not such a person, you are warned that any disclosure, copying or dissemination of the information is unauthorised. If you have received the transmission in error, please immediately contact this office by telephone, fax or email, to inform us of the error and to enable arrangements to be made for the destruction of the transmission, or its return at our cost. No liability is accepted for any unauthorised use of the information contained in this transmission.

ianturton · August 7, 2020, 2:33pm

I’ve opened and resolved this issue (https://osgeo-org.atlassian.net/browse/GEOT-6676) - can you try a nightly build from tomorrow and let me know if it solves the problem?

If it doesn’t can you let me know via that ticket and add the exact table structure you are querying.

Ian

···

Ian Turton