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.
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 Comment From: aaime - Time: Sun, 27 Jul 2014 03:53:05 -0500
<p>Closing, was apparently fixed in 2.5.1</p>
Mass closing all resolved issues not modified in the last 4 weeks