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

[Paul Ramsey]

Could you do a bit more legwork and see if the problem appears at the
transition to 5.0 or the transition to 5.2? From there we can probably
find the code change that caused it.

P.

On Wed, Sep 10, 2008 at 7:03 AM, Schönhammer, Herbert
<Schoenhammer.Herbert at regensburg.de> wrote:
> 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
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>