[Geoserver-devel] [jira] (GEOS-6554) Sql view with oracle in Geoserver 2.5

GeoServer GeoServer Developer
1

Àngela Feliu created an issue

GeoServer / BugGEOS-6554

Sql view with oracle in Geoserver 2.5

Issue Type:

BugBug

Affects Versions:

2.5

Assignee:

Andrea Aime

Components:

Oracle, WMS

Created:

26/Jun/14 6:05 AM

Environment:

Windows 32 bits, SUSE Linux Enterprise Server 11 (x86_64)

Fix Versions:

2.2.3

Priority:

MajorMajor

Reporter:

Àngela Feliu

We are publishing an Oracle Warehouse in Geoserver 2.5
Connection works fine when layers are published directly, but WMS requests returns nothing when layers are published through sql view.

Reading Geoserver logs we’ve seen the line “[oracle.sdo] - Using layer SRID: 2”

Trying to debug this strange behaviour we’ve find that Geoserver generates a geometry to intersect the original Oracle geometries. When the layer is an sql view Geoserver replaces the original srid of the layer (4326) to srid 2. After that the intersection in Oracle don’t return any record to Geoserver. This is why the WMS request return nothing but an empty image.

We’ve also tried in a Geoserver 2.2.3, and it works like a charm.

Add Comment

Add Comment

This message was sent by Atlassian JIRA (v6.1.6#6162-sha1:7af547c)

Atlassian logo