Jukka, I was trying to make what you told me, but I've found an earlier problem. I've tried to display the labels with the style directly against a layer that is the DB table, but I can't get the labels!! So I stopped there because it seems to me that it could be a problem related with db definition. I've been talking to our DBA and he has told me that this is how we have the DB:
Schema: ADMCARTO Tablespace: CARTO Data: Table and normal view --> I can get the labels Schema: USRCARTO Tablespace: CARTO_D Data: Table and materialized view --> I can't get the labels Any suggestions?? 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 ------------------------------------------------------------------------------ The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: Pinpoint memory and threading errors before they happen. Find and fix more than 250 security defects in the development cycle. Locate bottlenecks in serial and parallel code that limit performance. http://p.sf.net/sfu/intel-dev2devfeb _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
