help w/ WFS request

[John Cartwright]

Thanks for the suggestions guys.

The following oracle query works:
select count(*) from sounding p where SDO_FILTER(
p.SHAPE,sdo_geometry(2003,8265,null,mdsys.sdo_elem_info_array(1,1003,3),mdsys.sdo_ordinate_array(-95,26.5,-94.75,26.75))
) = 'TRUE'

the GET request:
request=getFeature&service=wfs&version=1.0.0&typename=soundings&maxfeatures=10

times out, but the describefeaturetype request continues to work.  It's 
response seems to confirm that mapserver is actually connecting to oracle.

I haven't had much success w/ the mapserver debugging. I set "DEBUG on" 
in both the MAP and LAYER section of the mapfile and defined the env 
variables:
MS_ERRORFILE=/tmp/msErrors.txt
CPL_DEBUG=ON
PROJ_DEBUG=ON

I'm seeing debugging messages from PROJ, GDAL but not from Mapserver.

Any further ideas on how to proceed?

Thanks!

-- john


Pericles S. Nacionales wrote:

>John,
>
>Can you confirm that the SQL query works outside of MapServer?  This could 
>well be a MapServer bug (and I suspect is related to PostGIS query problems 
>thaat some users are experiencing).  You might have to enable the debugging 
>mode to get more info.
>
>-Perry
>
>On Thursday 20 April 2006 11:23, John Cartwright wrote:
>  
>
>>Hi Bart,
>>
>>yes, I did - same results:
>>
>><gml:Box srsName="epsg:4269">
>>          <gml:coordinates>-95,26.5 -94.75,26.75</gml:coordinates>
>></gml:Box>
>>
>>"EPSG:4269" and "epsg:4269" produce the same results in the request, but
>>the mapfile seems to only recognize the lowercase representation.
>>
>>from the mapfile:
>> DATA "SHAPE FROM BATHYUSER.SOUNDING USING SRID 8265"
>> PROJECTION
>>   "init=epsg:4269"
>> END
>>
>>Is there a way that I can see any more detail on how mapserver "sees"
>>the request?
>>
>>Thanks!
>>
>>-- john
>>
>>Eijnden, B. van den (Bart) wrote:
>>    
>>
>>>Have you tried Perry's suggestion to use:
>>>
>>>       <gml:Box srsName="EPSG:4269">
>>>          <gml:coordinates>-95,26.5 -94.75,26.75</gml:coordinates>
>>>       </gml:Box>
>>>
>>>?
>>>
>>>What's does your LAYER's PROJECTION block look like?
>>>
>>>Best regards,
>>>Bart
>>>      
>>>
>
>  
>