[mapserver-users] Oracle Spatial + MS 5.2.0: No drawing of certain objects

[Schönhammer, Herbert]

Hi list,

( I had a similar discussion using Mapserver 4.10.x and Oracle Spatial 9i in May 2007. But the problems changed using Mapserver 5.2.0 .).


The new environmet:
===============
Server SLES10
Mapserver 5.2.0
Oracle OCI - Interface used with Oracle 11-Client-Software

DB-Server Windows 2xxx
Oracle Spatial 10g


The new problem :
==============
Line strings made up of a connected sequence of circular arcs ARE NOT DRAWN. No error message is generated by mapserver, but the objects are not shown in the map.

Example:
INSERT INTO AX_BES_GEBLINIE (FID,GEOM) VALUES (14196363,mdsys.sdo_geometry(2002,82032,null,mdsys.sdo_elem_info_array(1,2,2),mdsys.sdo_ordinate_array(4512474.1948,5426555.0979,4512473.3318,5426554.2349,4512474.1948,5426553.3719,4512475.0578,5426554.2349,4512474.1948,5426555.0979)));

(Background:
In my mailing from May 2007 I reported that these Objects are drawn correctly by mapserver. This statement is indeed reproducable correct using mapserver 4.10.x. This is independent from the used oracle version ( 9i or 10g ).
Now, using mapserver 5.2.0 these objects are not drawn anymore. No error message is produced. This is also independent from the used oracle version ( 9i or 10g ). )

The old problem:
============
Polygons  made up of a connected sequence of circular arcs ARE NOT DRAWN. No error message is generated by mapserver, but the objects are not shown in the map.

(This problem was already reported in May 2007. The behaviour did not change from mapserver 4.10.x to 5.2.0)

Example:
INSERT INTO AX_GEBAEUDE (FID,GEOM) VALUES (14079065,mdsys.sdo_geometry(2003,82032,null,mdsys.sdo_elem_info_array(1,1003,2),mdsys.sdo_ordinate_array(4505553.2585,5430757.2937,4505551.1659,5430755.2011,4505553.2585,5430753.1085,4505555.3511,5430755.2011,4505553.2585,5430757.2937)));


Oracle Documentation:
=================
Reading the Oracle Docs, I think all the objects are correct defined. The geometries are validating by oracle 9i and oracle 10g (Using the st_valid - method, e.g. SELECT a.GEOM.ST_IsValid()
FROM ax_bes_geblinie a WHERE a.fid = 14196363;).



Does anybody know a solution how to draw these objects with mapserver ?

greetings
Herbert

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20080910/9b8b4837/attachment.htm>