[mapserver-dev] Oracle SQL (MS trunk)

[bartvde at osgis.nl]

Hi Mike,

they do work fine now, and I also believe in the past (at least whenever I
have been using them :-) ).

Best regards,
Bart

> Bart,
>
> I don't the the GML Excludes or Includes work for Oracle. Or they didn't
> previously when I submitted the patch.
>
> Mike
>
>
> --
> Michael Smith
> RSGIS Center
> US Army Corps of Engineers
>
>
>
>
> On 12/10/09 7:11 AM, "bartvde at osgis.nl" <bartvde at osgis.nl> wrote:
>
>> Ofcourse, I can also add "GML_EXCLUDE_ITEMS" "null" to exclude it, but
>> it
>> would be nicer if this would be automagically :-)
>>
>> Best regards,
>> Bart
>>
>>> Hi Mike,
>>>
>>> thanks, right, it is an SE_ANNO_CAD_DATA column, but nulling it out
>>> also
>>> means it is also output in the WFS GML, which is unwanted (shows up in
>>> attribute tables etc.):
>>>
>>> ..
>>> <rws:PERIMETER>13507.68</rws:PERIMETER>
>>> <rws:null/>
>>> </rws:AAA35>
>>> ..
>>>
>>> Do you see a solution?
>>>
>>> Or do I need to change my DATA statement to exclude it (but then again,
>>> I
>>> need to always change the SQL when the datamodel changes).
>>>
>>> TIA.
>>>
>>> Best regards,
>>> Bart
>>>
>>>> Bart,
>>>>
>>>> I'm not sure about the 2 objectid's, but it is probably due to
>>>> requesting
>>>> unique OBJECTID. This gets added to the column list with has all the
>>>> columns
>>>> already present. The NULL is probably a blob column, perhaps an
>>>> SE_ANNO_CAD_DATA column. NULLing it out was a patch I submitted to
>>>> allow
>>>> WFS
>>>> to work when you have a blob column.
>>>>
>>>> Mike
>>>>
>>>>
>>>> --
>>>> Michael Smith
>>>> RSGIS Center
>>>> US Army Corps of Engineers
>>>>
>>>>
>>>>
>>>>
>>>> On 12/10/09 6:30 AM, "bartvde at osgis.nl" <bartvde at osgis.nl> wrote:
>>>>
>>>>> Hi list,
>>>>>
>>>>> using Mapserver trunk I see the following SQL being generated for
>>>>> Oracle
>>>>> Spatial layers:
>>>>>
>>>>> SELECT OBJECTID, OBJECTID, VOOR, LETTER, CYFER, KALK, ACHTER, SCHOP,
>>>>> HEL,
>>>>> GWT, CODE, OMSCHR, EERSTE_BOD, EERSTE_GWT, KLEUR_BOD, KLEUR_GWT,
>>>>> AREA,
>>>>> PERIMETER, null, SHAPE FROM BODEM.BODEMKAART50 WHERE  ROWNUM<=5  AND
>>>>> SDO_FILTER( SHAPE, MDSYS.SDO_GEOMETRY(2003, :srid,
>>>>> NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates
>>>>> ),'querytype=window')
>>>>> = 'TRUE'
>>>>>
>>>>> Questions:
>>>>>
>>>>> 1) why is OBJECTID requested twice? DATA statement is "SHAPE FROM
>>>>> BODEM.BODEMKAART50 USING UNIQUE OBJECTID".
>>>>> 2) where is the null after PERIMETER coming from?
>>>>>
>>>>> Best regards,
>>>>> Bart
>>>>>
>>>>> _______________________________________________
>>>>> mapserver-dev mailing list
>>>>> mapserver-dev at lists.osgeo.org
>>>>> http://lists.osgeo.org/mailman/listinfo/mapserver-dev
>>>>
>>>>
>>>
>>>
>>>
>>
>>
>
>