Sql view with oracle in Geoserver 2.5

Description

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 "

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.

Environment

None

Activity

Show:
codehaus
April 10, 2015, 4:47 PM

CodeHaus Comment From: angela_feliu - Time: Wed, 2 Jul 2014 09:10:12 -0500
---------------------
<p>Also tried with PostGis and it fails too

But in version 2.5.1 it works well.... I guess this only happens in version 2.5</p>

codehaus
April 10, 2015, 4:47 PM

CodeHaus Comment From: aaime - Time: Sun, 27 Jul 2014 03:53:05 -0500
---------------------
<p>Closing, was apparently fixed in 2.5.1</p>

Andrea Aime
February 15, 2017, 11:48 AM

Mass closing all resolved issues not modified in the last 4 weeks

Assignee

Unassigned

Reporter

codehaus

Triage

None

Fix versions

Affects versions

Components

Priority

Medium
Configure