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

2020-08-03 Thread Richard Duivenvoorde
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

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

2020-08-03 Thread Andrea Aime
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

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

2020-08-03 Thread Rahkonen Jukka (MML)
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

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

2020-08-03 Thread Mark Prins
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

Re: [Geoserver-users] Use of $SCALE-info in an SQL View?

2020-08-03 Thread Andrea Aime
wms_scale_denominator is a "env" variable that only the "env" function sees, while view params follow a completely different path. It would be possible to load up all env variables into the view params map I guess, I assume it would have to be done with a new config flag to avoid potential

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

2020-08-03 Thread d'Orio, Pietro
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 Pietro d'Orio ___

Re: [Geoserver-users] Use of $SCALE-info in an SQL View?

2020-08-03 Thread Richard Duivenvoorde
On 8/3/20 12:40 PM, Ian Turton wrote: > It might be easier to do this in a custom function in GeoTools rather than in > PostGIS - then you could pass in the scale env variable along with the > feature that you are drawing.  > > Ian Mmm, that is (at least in my opinion) a little over the top...

Re: [Geoserver-users] Use of $SCALE-info in an SQL View?

2020-08-03 Thread Ian Turton
It might be easier to do this in a custom function in GeoTools rather than in PostGIS - then you could pass in the scale env variable along with the feature that you are drawing. Ian On Mon, 3 Aug 2020 at 10:15, Richard Duivenvoorde wrote: > Hi, > > In QGIS there is something what we call

[Geoserver-users] Use of $SCALE-info in an SQL View?

2020-08-03 Thread Richard Duivenvoorde
Hi, In QGIS there is something what we call 'Geometry-generators': you actually generate a geometry based on some other geometry and some parameters, coming from 'expressions'. In this way it is for example possible to create some kind of polygon based on a point layer. My goal: create