[mapserver-dev] Oracle SQL (MS trunk)

[Smith, Michael ERDC-USACE-NH]

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
>>> 
>>> 
>> 
>> 
>> 
> 
>