On Wed, Apr 2, 2014 at 7:20 PM, Roel De Nijs <[email protected]> wrote:
> Hi all, > > Today I upgraded our geoserver 2.4 instance to the latest stable version > (2.5). > > After this upgrade I noticed our wms-requests using viewparams (SQL-view > based layers) just return empty tiles. Same happens when you preview the > layer using e.g. openlayers. Executing exactly the same request to a > geoserver 2.4 instance returns the expected tiles. > > I checked the log, no errors are shown. Has something changed with regard > to using sql-view based layers & viewparams? > > When I looked at the request geoserver is receiving I see that the > VIEWPARAMS parameter is interpreted correctly and contains the correct > value, but the key itself is upper cased (the value is an integer). The > parameter in my SQL view is lower case. Could that be a possible cause? > I'd suggest you to enable "geotools developer logging" and see how queries are built. It may be this issue http://jira.codehaus.org/browse/GEOT-4749, if that's the case, you can solve it by installing a nightly build (2.5.1 will be released in May) http://ares.boundlessgeo.com/geoserver/2.5.x/ This is unfortunate, but apparently no one with sql views tested GeoServer 2.5 in the beta, RC1 and RC2 releases (or if they did, they did not care to report the issue). Cheers Andrea -- == Meet us at GEO Business 2014! in London! Visit http://goo.gl/fES3aK for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it -------------------------------------------------------
------------------------------------------------------------------------------
_______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
