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.do...@siag.it] Sent: Tuesday, 4 August 2020 7:40 PM To: rdmaili...@duif.net; andrea.a...@geo-solutions.it; Rahkonen Jukka (MML) <jukka.rahko...@maanmittauslaitos.fi> 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 <rdmaili...@duif.net> Inviato: lunedì 3 agosto 2020 20:20 A: andrea.a...@geo-solutions.it; Rahkonen Jukka (MML) <jukka.rahko...@maanmittauslaitos.fi> 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%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C961fdcc5f6344f5f98e908d83867ae67%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637321366417078070&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.rahko...@maanmittauslaitos.fi > <mailto:jukka.rahko...@maanmittauslaitos.fi>> 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.pr...@gmail.com <mailto:mc.pr...@gmail.com>> > 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%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C961fdcc5f6344f5f98e908d83867ae67%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637321366417078070&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%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C961fdcc5f6344f5f98e908d83867ae67%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637321366417078070&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%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C961fdcc5f6344f5f98e908d83867ae67%7C64ebab8accf44b5ca2d32b4e972d96b2%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%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& > ;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%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C961fdcc5f6344f5f98e908d83867ae67%7C64ebab8accf44b5ca2d32b4e972d96b2%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%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& > ;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& > ;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%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C961fdcc5f6344f5f98e908d83867ae67%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637321366417088067&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%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C961fdcc5f6344f5f98e908d83867ae67%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637321366417088067&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%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C961fdcc5f6344f5f98e908d83867ae67%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637321366417088067&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%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C961fdcc5f6344f5f98e908d83867ae67%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637321366417088067&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%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C961fdcc5f6344f5f98e908d83867ae67%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637321366417088067&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%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C961fdcc5f6344f5f98e908d83867ae67%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637321366417088067&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%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C961fdcc5f6344f5f98e908d83867ae67%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637321366417088067&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%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C961fdcc5f6344f5f98e908d83867ae67%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637321366417088067&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. _______________________________________________ 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
