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
[EMAIL PROTECTED]
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
[EMAIL PROTECTED]
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
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
