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

[Haris Kurtagic]

trunk should be ok, latest version is in trunk
it looks like problem in conversation to oracle geometry

I will try to test it soon.

Haris


On Fri, Feb 19, 2010 at 8:56 AM, Andreas Morf <a.morf at fkl.ch> wrote:

> 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
>
>
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20100219/6489abc9/attachment.html