Pietro d'Orio ( https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3A9e6903d6-75ac-4ec1-97a4-309f66cec31e ) *created* an issue
GeoServer ( https://osgeo-org.atlassian.net/browse/GEOS?atlOrigin=eyJpIjoiMTdjZjIxNGU5NDg4NDc0ZTgyZWIyZTZlMjI5MGFmZDQiLCJwIjoiaiJ9 ) / Bug ( https://osgeo-org.atlassian.net/browse/GEOS-9712?atlOrigin=eyJpIjoiMTdjZjIxNGU5NDg4NDc0ZTgyZWIyZTZlMjI5MGFmZDQiLCJwIjoiaiJ9 ) GEOS-9712 ( https://osgeo-org.atlassian.net/browse/GEOS-9712?atlOrigin=eyJpIjoiMTdjZjIxNGU5NDg4NDc0ZTgyZWIyZTZlMjI5MGFmZDQiLCJwIjoiaiJ9 ) Errors in SQL DB Query on oracle ( https://osgeo-org.atlassian.net/browse/GEOS-9712?atlOrigin=eyJpIjoiMTdjZjIxNGU5NDg4NDc0ZTgyZWIyZTZlMjI5MGFmZDQiLCJwIjoiaiJ9 ) Issue Type: Bug Affects Versions: 2.17.1 Assignee: Unassigned Components: Oracle Created: 03/Aug/20 1:26 PM Priority: Medium Reporter: Pietro d'Orio ( https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3A9e6903d6-75ac-4ec1-97a4-309f66cec31e ) If an oracle view contains fields like "DATE" or "LEVEL" the SQL query performed on Oracle gives errors. As result the WFS getfeature does not work. GeoServer does call Oracle spatial with a query like this: SELECT ID, LEVEL ,GEOMETRY AS GEOMETRY FROM TABLE That's cause: ORA-01788: CONNECT BY clause required in this query block Queries with "DATE" fields cause. : ORA-00936: missing expression ( https://osgeo-org.atlassian.net/browse/GEOS-9712#add-comment?atlOrigin=eyJpIjoiMTdjZjIxNGU5NDg4NDc0ZTgyZWIyZTZlMjI5MGFmZDQiLCJwIjoiaiJ9 ) Add Comment ( https://osgeo-org.atlassian.net/browse/GEOS-9712#add-comment?atlOrigin=eyJpIjoiMTdjZjIxNGU5NDg4NDc0ZTgyZWIyZTZlMjI5MGFmZDQiLCJwIjoiaiJ9 ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8 ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100141- sha1:e1d49c9 )
_______________________________________________ Geoserver-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-devel
