[Geoserver-devel] [JIRA] (GEOS-9712) Errors in SQL DB Query on oracle

GeoServer GeoServer Developer
1

Pietro d’Orio created an issue

GeoServer / BugGEOS-9712

Errors in SQL DB Query on oracle

Issue Type:

BugBug

Affects Versions:

2.17.1

Assignee:

Unassigned

Components:

Oracle

Created:

03/Aug/20 1:26 PM

Priority:

MediumMedium

Reporter:

Pietro d’Orio

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

Add Comment

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS

This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100141-sha1:e1d49c9)

Atlassian logo