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 - tno...@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.l...@state.mn.us] Sent: Saturday, January 09, 2010 11:50 AM To: Nolte, Tim; mapserver-users@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-boun...@lists.osgeo.org [mapserver-users-boun...@lists.osgeo.org] On Behalf Of Nolte, Tim [tim.no...@ipcswirelessinc.com] Sent: Thursday, January 07, 2010 4:07 PM To: Lime, Steve D (DNR); mapserver-users@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 - tno...@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.l...@state.mn.us] Sent: Thursday, January 07, 2010 3:55 PM To: Nolte, Tim; mapserver-users@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-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Nolte, Tim Sent: Thursday, January 07, 2010 8:08 AM To: mapserver-users@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 - tno...@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: t...@osgeo.org [mailto:t...@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 _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users