Andrea, I get this messages when I click the Layer Preview link. Then, it loads the OpenLayers interface with the default style, and then I switch to the style I've created. I've noticed that it's getting some values of a feature (label is 8:9:151:3) but it doesn't render it. Do you see something unusual??
10 Feb 11:33:50 DEBUG [org.geotools.styling] - number of fts set 1 10 Feb 11:33:50 DEBUG [org.geotools.jdbc] - CREATE CONNECTION 10 Feb 11:33:50 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION 10 Feb 11:33:50 DEBUG [org.geotools.styling] - number of fts set 1 10 Feb 11:33:50 DEBUG [org.geotools.renderer.shape] - Affine Transform is AffineTransform[[0.469225885186853, 0.0, -250496.62767461286], [0.0, -0.469225885147807, 2232747.567751679]] 10 Feb 11:33:50 DEBUG [org.geotools.rendering] - Computed scale denominator: 7611.320441126929 10 Feb 11:33:50 DEBUG [org.geotools.styling] - number of fts set 1 10 Feb 11:33:50 DEBUG [org.geotools.rendering] - processing 1 stylers for http://192.168.3.15/ikt:Recintos_SIGPAC_Explotacion_USRCARTO 10 Feb 11:33:50 DEBUG [org.geotools.rendering] - creating rules for scale denominator - 7,611.32 10 Feb 11:33:50 DEBUG [org.geotools.rendering] - Expanding rendering area by 1 pixels to consider stroke width 10 Feb 11:33:50 DEBUG [org.geotools.rendering] - Querying layer Recintos_SIGPAC_Explotacion_USRCARTO with bbox: ReferencedEnvelope[533848.6975731566 : 534944.1188110434, 4757507.286812376 : 4758366.148211024] 10 Feb 11:33:50 DEBUG [org.geotools.jdbc] - CREATE CONNECTION 10 Feb 11:33:50 TRACE [org.geotools.core] - ENTRY 4 10 Feb 11:33:50 DEBUG [org.geotools.filter] - exporting PropertyName 10 Feb 11:33:50 DEBUG [org.geotools.jdbc] - SELECT GID,RECINTO,PARCELA,GEOMETRY as GEOMETRY FROM USRCARTO.GV_SIGPAC_REC_ED50 WHERE SDO_FILTER(GEOMETRY, ?, 'mask=anyinteract querytype=WINDOW') = 'TRUE' 10 Feb 11:33:50 DEBUG [org.geotools.data.oracle.sdo] - Using layer SRID: 82337 10 Feb 11:33:50 DEBUG [org.geotools.jdbc] - Setting parameter 1 as MDSYS.SDO_GEOMETRY(2003,82337,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(533848.6975731566,4757507.286812376,534944.1188110434,4758366.148211024)) 10 Feb 11:33:50 DEBUG [org.geotools.jdbc] - 1 = POLYGON ((533848.6975731566 4757507.286812376, 533848.6975731566 4758366.148211024, 534944.1188110434 4758366.148211024, 534944.1188110434 4757507.286812376, 533848.6975731566 4757507.286812376)) 10 Feb 11:33:50 DEBUG [org.geotools.rendering] - creating text style 10 Feb 11:33:50 DEBUG [org.geotools.rendering] - geomName = null 10 Feb 11:33:50 DEBUG [org.geotools.rendering] - label is 43:3 10 Feb 11:33:50 DEBUG [org.geotools.rendering] - setting pointPlacement 10 Feb 11:33:50 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION 10 Feb 11:33:50 DEBUG [org.geotools.rendering] - Style cache hit ratio: 0.99 , hits 99, requests 100 10 Feb 11:33:50 DEBUG [org.geotools.renderer.shape] - Style cache hit ratio: NaN , hits 0, requests 0 10 Feb 11:33:50 DEBUG [org.geotools.image] - Encoded input image for png writer 10 Feb 11:33:50 DEBUG [org.geotools.image] - Getting a writer 10 Feb 11:33:50 DEBUG [org.geotools.image] - Setting write parameters for this writer 10 Feb 11:33:50 DEBUG [org.geotools.image] - Writer is NOT native 10 Feb 11:33:50 DEBUG [org.geotools.image] - About to write png image This message is the one I get when I preview the layer of the DB table, the one that is not a materialized view. The query seems to be a bit different because it doesn't ask for the GID parameter. 10 Feb 11:38:20 DEBUG [org.geotools.styling] - number of fts set 1 10 Feb 11:38:20 DEBUG [org.geotools.jdbc] - CREATE CONNECTION 10 Feb 11:38:20 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION 10 Feb 11:38:20 DEBUG [org.geotools.styling] - number of fts set 1 10 Feb 11:38:20 DEBUG [org.geotools.renderer.shape] - Affine Transform is AffineTransform[[0.469225885186803, 0.0, -250708.62767460238], [0.0, -0.469225885148318, 2233011.5677537583]] 10 Feb 11:38:20 DEBUG [org.geotools.rendering] - Computed scale denominator: 7611.320441127741 10 Feb 11:38:20 DEBUG [org.geotools.styling] - number of fts set 1 10 Feb 11:38:20 DEBUG [org.geotools.rendering] - processing 1 stylers for http://192.168.3.15/ikt:Recintos_SIGPAC_Explotacion_ADMCARTO 10 Feb 11:38:20 DEBUG [org.geotools.rendering] - creating rules for scale denominator - 7,611.32 10 Feb 11:38:20 DEBUG [org.geotools.rendering] - Expanding rendering area by 1 pixels to consider stroke width 10 Feb 11:38:20 DEBUG [org.geotools.rendering] - Querying layer Recintos_SIGPAC_Explotacion_ADMCARTO with bbox: ReferencedEnvelope[534300.5055545765 : 535395.9267924635, 4758069.915618677 : 4758928.777017323] 10 Feb 11:38:20 DEBUG [org.geotools.jdbc] - CREATE CONNECTION 10 Feb 11:38:20 TRACE [org.geotools.core] - ENTRY 4 10 Feb 11:38:20 DEBUG [org.geotools.filter] - exporting PropertyName 10 Feb 11:38:20 DEBUG [org.geotools.jdbc] - SELECT RECINTO,PARCELA,GEOMETRY as GEOMETRY FROM ADMCARTO.GV_SIGPAC_REC_ED50 WHERE SDO_FILTER(GEOMETRY, ?, 'mask=anyinteract querytype=WINDOW') = 'TRUE' 10 Feb 11:38:20 DEBUG [org.geotools.data.oracle.sdo] - Using layer SRID: 82337 10 Feb 11:38:20 DEBUG [org.geotools.jdbc] - Setting parameter 1 as MDSYS.SDO_GEOMETRY(2003,82337,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(534300.5055545765,4758069.915618677,535395.9267924635,4758928.777017323)) 10 Feb 11:38:20 DEBUG [org.geotools.jdbc] - 1 = POLYGON ((534300.5055545765 4758069.915618677, 534300.5055545765 4758928.777017323, 535395.9267924635 4758928.777017323, 535395.9267924635 4758069.915618677, 534300.5055545765 4758069.915618677)) 10 Feb 11:38:20 DEBUG [org.geotools.rendering] - creating text style 10 Feb 11:38:20 DEBUG [org.geotools.rendering] - geomName = null 10 Feb 11:38:20 DEBUG [org.geotools.rendering] - label is 90001:23 10 Feb 11:38:20 DEBUG [org.geotools.rendering] - setting pointPlacement 10 Feb 11:38:20 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION 10 Feb 11:38:20 DEBUG [org.geotools.rendering] - Style cache hit ratio: 0.989247311827957 , hits 92, requests 93 10 Feb 11:38:20 DEBUG [org.geotools.renderer.shape] - Style cache hit ratio: NaN , hits 0, requests 0 10 Feb 11:38:20 DEBUG [org.geotools.image] - Encoded input image for png writer 10 Feb 11:38:20 DEBUG [org.geotools.image] - Getting a writer 10 Feb 11:38:20 DEBUG [org.geotools.image] - Setting write parameters for this writer 10 Feb 11:38:20 DEBUG [org.geotools.image] - Writer is NOT native 10 Feb 11:38:20 DEBUG [org.geotools.image] - About to write png image I've to mention that the materialized view and the DB table are in different tablespaces, although I think it isn't relevant. 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: [email protected] [mailto:[email protected]] En nombre de Andrea Aime Enviado el: miércoles, 02 de febrero de 2011 14:57 Para: David Alda Fernandez de Lezea CC: [email protected] Asunto: Re: [Geoserver-users] Problem with SLD over a layer that is a materialized view 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 ----------------------------------------------------- ------------------------------------------------------------------------------ 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
