Data stored in Oracle with a projection already assigned can not be shown properly
----------------------------------------------------------------------------------
Key: GEOS-2006
URL: http://jira.codehaus.org/browse/GEOS-2006
Project: GeoServer
Issue Type: Bug
Components: Oracle
Affects Versions: 1.6.4, 1.6.3, 1.6.2
Environment: Oracle 10.2
Tried with the bin distribution in Windows XP and the war distribution in Tomcat 5
Reporter: Sylvain Caillot
Assignee: Andrea Aime
When trying to display some GIS data stored into Oracle for which a projection has been defined (for example EPSG:4326) in the database, it is partially drawn in GeoServer. Only some of the polygons are shown. By zooming in and out, some new polygons appear and other disappear.
Using the OpenLayers client and by clicking in the map, the attributes of the polygons are shown even there are not effectively drawn in the map.
No major bug in the log, it just takes a long time to start displaying something (2 minutes) instead of 2s in the case of the same GIS data coming from Oracle without a projection already defined.
Geoserver.log:
2008-06-25 14:48:25,042 DEBUG [geoserver.global] - getting type fifao:EEZ_ORA_4326_MP
2008-06-25 14:48:25,042 DEBUG [geoserver.ows] - Getting layers and styles from LAYERS and STYLES
2008-06-25 14:48:25,042 DEBUG [geotools.styling] - number of fts set 1
2008-06-25 14:48:25,042 DEBUG [geoserver.ows] - establishing EEZ_style style for fifao:EEZ_ORA_4326_MP
2008-06-25 14:48:25,043 DEBUG [wms.responses] - setting up map
2008-06-25 14:48:25,043 DEBUG [wms.responses] - asking delegate for write to org.geoserver.ows.DispatcherOutputStream@anonymised.com
2008-06-25 14:48:25,047 INFO [geoserver.filters] - Compressing output for mimetype: text/html
2008-06-25 14:48:25,047 INFO [geoserver.filters] - 168.202.106.33 "GET /geoserver/wms?bbox=-198.0,-98.84953231811524,198.0,95.84017868041994&styles=&Format=application/openlayers&request=GetMap&layers=fifao:EEZ_ORA_4326_MP&width=800&height=369&srs=EPSG:4326" took 6ms
2008-06-25 14:48:25,408 INFO [geoserver.filters] - 168.202.106.33 "GET /geoserver/wms?LAYERS=fifao%3AEEZ_ORA_4326_MP&STYLES=&HEIGHT=553&WIDTH=1200&SRS=EPSG%3A4326&FORMAT=image%2Fpng&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&BBOX=-464.0625,-215.55350494384766,464.0625,212.54415130615234" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14" "http://figis02:8484/geoserver/wms?bbox=-198.0,-98.84953231811524,198.0,95.84017868041994&styles=&Format=application/openlayers&request=GetMap&layers=fifao:EEZ_ORA_4326_MP&width=800&height=369&srs=EPSG:4326"
2008-06-25 14:48:25,409 DEBUG [geoserver.global] - getting type fifao:EEZ_ORA_4326_MP
2008-06-25 14:48:25,409 DEBUG [geoserver.ows] - Getting layers and styles from LAYERS and STYLES
2008-06-25 14:48:25,410 DEBUG [geotools.styling] - number of fts set 1
2008-06-25 14:48:25,410 DEBUG [geoserver.ows] - establishing EEZ_style style for fifao:EEZ_ORA_4326_MP
2008-06-25 14:48:25,411 DEBUG [wms.responses] - setting up map
2008-06-25 14:48:25,411 DEBUG [wms.map] - setting up 1200x553 image
2008-06-25 14:48:25,414 DEBUG [renderer.shape] - Affine Transform is AffineTransform[[1.292929292929293, 0.0, 600.0], [0.0, -1.291761335121769, 274.5563166635586]]
2008-06-25 14:48:25,414 DEBUG [geotools.styling] - number of fts set 1
2008-06-25 14:48:25,414 DEBUG [geotools.rendering] - processing 1 stylers for EEZ_ORA_4326_MP
2008-06-25 14:48:25,414 DEBUG [geotools.rendering] - creating rules for scale denominator - 307,495,245.216
2008-06-25 14:48:25,414 DEBUG [geotools.rendering] - Expanding rendering area by 1 pixels to consider stroke width
2008-06-25 14:48:25,414 DEBUG [geotools.rendering] - Querying layer EEZ_ORA_4326_MP with bbox: ReferencedEnvelope[-464.8359375 : 464.8359375, -216.3276417544263 : 213.318288116731]
2008-06-25 14:48:25,415 DEBUG [filter.SQLEncoderOracle] - SQLEncoderOracle: Geometric Column is: GEOMETRY
2008-06-25 14:48:25,415 DEBUG [filter.SQLEncoderOracle] - SQLEncoderOracle: Geometric Column is: GEOMETRY
2008-06-25 14:48:25,415 DEBUG [data.jdbc] - calling sql builder with filter [ GEOMETRY bbox POLYGON ((-464.8359375 -216.3276417544263, -464.8359375 213.318288116731, 464.8359375 213.318288116731, 464.8359375 -216.3276417544263, -464.8359375 -216.3276417544263)) ]
2008-06-25 14:48:25,415 TRACE [geotools.core] - ENTRY 4
2008-06-25 14:48:25,415 DEBUG [filter.SQLEncoderOracle] - Visiting a Geometry filter
2008-06-25 14:48:25,415 DEBUG [geotools.filter] - exporting ExpressionAttribute
2008-06-25 14:48:25,416 DEBUG [filter.SQLEncoderOracle] - Using layer SRID: 4326
2008-06-25 14:48:25,416 DEBUG [data.jdbc] - sql is SELECT "GEOMETRY" FROM "EEZ_ORA_4326_MP" WHERE SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,4326,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-464.8359375,-216.3276417544263,464.8359375,213.318288116731)),'mask=anyinteract querytype=WINDOW') = 'TRUE'
2008-06-25 14:48:25,416 DEBUG [data.jdbc] - SELECT "GEOMETRY" FROM "EEZ_ORA_4326_MP" WHERE SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,4326,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-464.8359375,-216.3276417544263,464.8359375,213.318288116731)),'mask=anyinteract querytype=WINDOW') = 'TRUE'
2008-06-25 14:48:25,416 DEBUG [data.jdbc] - About to execute query: SELECT "GEOMETRY" FROM "EEZ_ORA_4326_MP" WHERE SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,4326,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-464.8359375,-216.3276417544263,464.8359375,213.318288116731)),'mask=anyinteract querytype=WINDOW') = 'TRUE'
2008-06-25 14:50:31,695 DEBUG [data.oracle] - About to create Geometry convertor for EEZ_ORA_4326_MP.GEOMETRY
2008-06-25 14:50:31,698 DEBUG [geotools.rendering] - Setting fill: java.awt.Color[r=238,g=85,b=85]
2008-06-25 14:50:31,795 DEBUG [geotools.rendering] - Style cache hit ratio: 0.975 , hits 39, requests 40
2008-06-25 14:50:31,795 DEBUG [renderer.shape] - Style cache hit ratio: NaN , hits 0, requests 0
2008-06-25 14:50:31,795 DEBUG [wms.responses] - asking delegate for write to org.geoserver.ows.DispatcherOutputStream@anonymised.com
2008-06-25 14:50:31,795 DEBUG [map.png] - Writing png image ...
2008-06-25 14:50:31,795 DEBUG [geotools.image] - Encoded input image for png writer
2008-06-25 14:50:31,795 DEBUG [geotools.image] - Getting a writer
2008-06-25 14:50:31,796 DEBUG [geotools.image] - Setting write parameters for this writer
2008-06-25 14:50:31,796 DEBUG [geotools.image] - Writer is NOT native
2008-06-25 14:50:31,796 DEBUG [geotools.image] - About to write png image
2008-06-25 14:50:31,889 DEBUG [map.png] - Writing png image ... done!
2008-06-25 14:50:31,890 INFO [geoserver.filters] - Not compressing output for mimetype: image/png
2008-06-25 14:50:31,891 INFO [geoserver.filters] - 168.202.106.33 "GET /geoserver/wms?LAYERS=fifao%3AEEZ_ORA_4326_MP&STYLES=&HEIGHT=553&WIDTH=1200&SRS=EPSG%3A4326&FORMAT=image%2Fpng&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&BBOX=-464.0625,-215.55350494384766,464.0625,212.54415130615234" took 126483ms
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira