Jukka and Andrea, Thanks for your responses. I'll have a look to what you both comment and I'll let you know.
Thanks. Un saludo, ·················································································· David Alda Fernández de Lezea Lurralde eta Biodibertsitate Saila / Dpto. de Territorio y Biodiversidad IKT Granja Modelo s/n · 01192 · Arkaute (Araba) ·················································································· Tlfnos.: 945-00-32-95 Fax: 945-00.32.90 ·················································································· email: [email protected] web: www.ikt.es ·················································································· -----Mensaje original----- De: Rahkonen Jukka [mailto:[email protected]] Enviado el: miércoles, 02 de febrero de 2011 15:58 Para: [email protected] Asunto: Re: [Geoserver-users] Problem with SLD over a layer that is amaterialized view Hi, We are using Geoserver only for WFS and thus we do not do labeling. However, we are using lots of Oracle materialized views and views built on top of materialized views without problems. I would consider to do a controlled test by having two source data sets: an original table and a full copy of that as a materialized view. Next I would make a normal view which selects everything from the original table and introduce that as a new layer for Geoserver. After checking that the layer works, including the labels, I would change the SELECT * FROM... inside the view SQL to point to the materialized view. If your labels disappear you will have an interesting problem and an almost ready jira issue report in your hands. -Jukka Rahkonen- Andrea Aime wrote: > > On Wed, Feb 2, 2011 at 11:57 AM, David Alda Fernandez de Lezea > <[email protected]> wrote: > > Hi list, > > > > I'm having some issues retrieving getmap requests with an > SLD over a layer, which is stored in oracle spatial. The layer is > linked to a materialized view. The problem is that in the SLD content > I specify what fields do I want to show, but they don't appear in the > returned image. The color style and all that stuff works fine, but for > some reason labels are not rendered. I have also the same layer in the > same DB, but using a normal view (the standard DB view), and I get > those labels rendered!! Is there something problematic with > materialized views and GeoServer. > > I'm not aware of any issue on materialized views, on the contrary, > I've heard of people going from normal views to materialized ones to > avoid issues with spatial filters not working (if the view definition > is complex or the view computes a new geometry). > > You might want to enable "geotools developer logging" and then see in > the logs what sql request is being made to the db? > > Cheers > Andrea > > -- > Ing. Andrea Aime > Technical Lead > > GeoSolutions S.A.S. > Via Poggio alle Viti 1187 > 55054 Massarosa (LU) > Italy > > phone: +39 0584962313 > fax: +39 0584962313 > > http://www.geo-solutions.it > http://geo-solutions.blogspot.com/ > http://www.linkedin.com/in/andreaaime > http://twitter.com/geowolf > > ----------------------------------------------------- > > -------------------------------------------------------------- > ---------------- > Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! > Finally, a world-class log management solution at an even better > price-free! > Download using promo code Free_Logger_4_Dev2Dev. Offer expires > February 28th, so secure your free ArcSight Logger TODAY! > http://p.sf.net/sfu/arcsight-sfd2d > _______________________________________________ > Geoserver-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users > ------------------------------------------------------------------------------ Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users ------------------------------------------------------------------------------ Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
