[fdo-users] King.Oracle 0.8.14 and SetFilter in Mapguide 2.1

[Benoit Begin]

I'm using the King.Oracle provider in one of my projects and I'm getting an
error whenever I apply a spatial filter via the SetFilter method by using
the GeomFromText('POLYGON((1 1, 1 2, 2 2, 2 1))') filter.The
SetSpatialFilter using an MgGeometry as the parameter works fine, however,
doing the same process via the SetFilter does not work.

The following error occurs:
An exception occurred in FDO component.
ORA-29902: error in executing ODCIIndexStart() routine
ORA-13208: internal error  while evaluating [window SRID does not match
layer SRID] operator
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 286

I'm assuming that when doing the filter by the SetSpatialFilter, it properly
sends the SRID along with the geometry information to Oracle, while it is
not sent when using the SetFilter method. What is strange though, is that an
MgGeometry does not have any spatial context information, so it technically
should cause the same issue.

I could use the SetSpatialFilter method, however it severely lacks the
possibility to have multiple spatial filter using an OR/AND operator. It
thus forces you to gather your data using multiple queries and run the risk
of having the same records more than once.

Here is what my SetFilter filter parameter looks like:

LOC_GEOMETRY INTERSECTS GEOMFROMTEXT ('POLYGON ((-171902.24521129683
4932604.4432532601, 1483559.4684033049 5036774.5189636145,
1433007.6942911053 5913647.8632266996, -237816.74934195657
5796848.2361217476, -171902.24521129683 4932604.4432532601))')

The WKT should be valid as it went through an MgWktReaderWriter to be
projected from my Map's SRS to the Feature Source's SRS.
-- 
View this message in context: http://n2.nabble.com/King-Oracle-0-8-14-and-SetFilter-in-Mapguide-2-1-tp4681271p4681271.html
Sent from the FDO Users mailing list archive at Nabble.com.