[mapguide-users] Problem with KingOracle and SpatialFilter using CurvePolygon

[Andreas Morf]

Haris
There is some strange behavior of KingOracle:
Inserting a simple polygon is working ok.
But when I try to insert a curved polygon, nothing happens: no message, no
record added to database...

Using an SQL sniffer I can see the following statement sent to DB: INSERT
INTO GEORI_AV.TEST_SIMPL ( OID,ART,GEOMETRY )  VALUES ( :1,:2,:3 )
but unfortunately I'm not able to inspect the parameters.

I'm using my own compiled version from trunk - should be up to date - or
isn't trunk==0.8.13?

Andreas

>From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Haris Kurtagic
>Sent: Thursday, February 18, 2010 9:09 PM
>To: MapGuide Users Mail List
>Subject: Re: [mapguide-users] Problem with KingOracle and SpatialFilter
using CurvePolygon

>Perhaps, King.Oracle is wrongly parsing that curved geometry.
>I remember some issue in past with it, but also it was fixed as far as I
can remember. 
>I also just runed again unittest which I have for curved polygons and it
says it is ok.

>Can you check are you using latest version ?

>As , I am writing this I just realized that in your case it is converting
from fdo to oracle geometry, so perhaps issue is there.
>You could test it if you try to insert same geometry in some test table.


>Haris
On Thu, Feb 18, 2010 at 7:13 PM, Andreas Morf <a.morf at fkl.ch> wrote:
Hi all
When invoking the command "featureSvc.SelectFeatures(featureSource,
featureClassName, query1);" with a spatial filter geometry like

CURVEPOLYGON ((757057.98399999994 245592.943 (LINESTRINGSEGMENT
(757058.40300000005 245594.383, 757034.647 245610.43299999999),
CIRCULARARCSEGMENT (757032.81790019607 245607.87801543999,
757030.73199999996 245605.52800000002), LINESTRINGSEGMENT
(757018.41400000011 245592.943, 757038.57400000002 245573.158,
757057.98399999994 245592.943))))

an MgException is thrown and mgserver logs following error

(5756) An exception occurred in FDO component.
ORA-29902: error in executing ODCIIndexStart() routine
ORA-13031: Invalid Gtype in the SDO_GEOMETRY object for point object
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 286

When using polygons without circular arcs the selection results are ok!

Anyone an idea?

Andreas

_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users