[mapserver-users] FW: [MapServer] #3256: No valid WFSgeometries from Oracle Spatial data source via PHP MapScript

[Nolte, Tim]

Yes, actually I am successfully using Oracle spatial layers with the Fusion framework that calls the "mapserv" CGI directly. I do have an issue with some Query results however. When I pass a valid query file that has result for only 1 layer but also request other layers that don't have results I get no selection results. So there are for sure issues with both WFS & queries for Oracle Spatial layers.

- Tim

----
Timothy J Nolte - tnolte at ilpcs.com
Network Planning Engineer

4717 Broadmoor Ave, Suite G
Kentwood, MI 49512

Office:  616-656-5163
PCS:     616-706-2438
Support: 616-929-0289
Fax:     616-554-6484


-----Original Message-----
From: Lime, Steve D (DNR) [mailto:Steve.Lime at state.mn.us] 
Sent: Saturday, January 09, 2010 11:50 AM
To: Nolte, Tim; mapserver-users at lists.osgeo.org
Subject: RE: [mapserver-users] FW: [MapServer] #3256: No valid WFSgeometries from Oracle Spatial data source via PHP MapScript

Tim: Can you even draw from Oracle? I setup a super simple mapfile that works fine with 5.4 but throws an error with 5.6 in msOracleSpatialLayerWhichShapes(). I'm wondering if the root cause is well below the query functions. I'm just hitting the CGI with a call like:

  mapserv -nh "QUERY_STRING=map=test.map&mode=map&layers=all"

Steve

________________________________________
From: mapserver-users-bounces at lists.osgeo.org [mapserver-users-bounces at lists.osgeo.org] On Behalf Of Nolte, Tim [Tim.Nolte at ipcswirelessinc.com]
Sent: Thursday, January 07, 2010 4:07 PM
To: Lime, Steve D (DNR); mapserver-users at lists.osgeo.org
Subject: RE: [mapserver-users] FW: [MapServer] #3256: No valid WFS      geometries      from Oracle Spatial data source via PHP MapScript

Actually the query was the whole Oracle Spatial table(view actually). I was finally able to come up with a work around by writing a wfs.php wrapper that fully handled all of the requests via PHP MapScript. I'm actually processing the POSTed XML from the MapInfo WFS client and manually adding them to the ms_newOwsRequestObj request object. And the php wrapper is actually returning all of the results. I'm not using the CGI at all. So I can say that this is something that is broken in the CGI and not PHP MapScript.

- Tim

----
Timothy J Nolte - tnolte at ilpcs.com
Network Planning Engineer

4717 Broadmoor Ave, Suite G
Kentwood, MI 49512

Office:  616-656-5163
PCS:     616-706-2438
Support: 616-929-0289
Fax:     616-554-6484


-----Original Message-----
From: Lime, Steve D (DNR) [mailto:Steve.Lime at state.mn.us]
Sent: Thursday, January 07, 2010 3:55 PM
To: Nolte, Tim; mapserver-users at lists.osgeo.org
Subject: RE: [mapserver-users] FW: [MapServer] #3256: No valid WFS geometries from Oracle Spatial data source via PHP MapScript

It's almost certainly related to the one-pass stuff. Oracle support was gutted in the process and has been
a bit problematic since. May be related to the other issue you raised in mid-Dec.

What's the WFS query? Again a polygon?

Steve

-----Original Message-----
From: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Nolte, Tim
Sent: Thursday, January 07, 2010 8:08 AM
To: mapserver-users at lists.osgeo.org
Subject: [mapserver-users] FW: [MapServer] #3256: No valid WFS geometries from Oracle Spatial data source via PHP MapScript

Anyone have any comments on this?

----
Timothy J Nolte - tnolte at ilpcs.com
Network Planning Engineer

4717 Broadmoor Ave, Suite G
Kentwood, MI 49512

Office:  616-656-5163
PCS:     616-706-2438
Support: 616-929-0289
Fax:     616-554-6484

-----Original Message-----
From: trac at osgeo.org [mailto:trac at osgeo.org]
Sent: Thursday, January 07, 2010 9:00 AM
To: undisclosed-recipients
Subject: Re: [MapServer] #3256: No valid WFS geometries from Oracle Spatial data source via PHP MapScript

#3256: No valid WFS geometries from Oracle Spatial data source via PHP MapScript
---------------------------------+--------------------------------------
---------------------------------+----
 Reporter:  tnolte               |        Owner:  sdlime
     Type:  defect               |       Status:  new
 Priority:  normal               |    Milestone:
Component:  MapServer C Library  |      Version:  5.6
 Severity:  normal               |   Resolution:
 Keywords:  oracle, wfs          |
---------------------------------+--------------------------------------
---------------------------------+----
Comment (by tnolte):

 I have reverted my Development server back to MS 5.4.2 and the WFS is  working again. I looked at the same request using DEBUG and can see that  the process that is used to query the Oracle Spatial data is completely  different. I'm suspecting these are the single-pass query changes that  were made in 5.6 for WFS. I need to find out if there is now code changes  that need to be made in PHP MapScript or if this is indeed a 5.6 defect.
 Can anyone else verify this?

--
Ticket URL: <http://trac.osgeo.org/mapserver/ticket/3256#comment:1>
MapServer <http://mapserver.org>
MapServer