[mapserver-users] FW: [MapServer] #3256: No valid WFS geometries from Oracle Spatial data source via PHP MapScript
Lime, Steve D (DNR)
Steve.Lime at state.mn.us
Sat Jan 9 08:49:31 PST 2010
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
More information about the MapServer-users
mailing list