[mapserver-users] ms4w (fastcgi) and oracle 10?

[Smith, Michael ERDC-CRREL-NH]

Zach,

Your DATA statement is almost correct. If you are going to use the UNIQUE
keyword (for supporting queries), you must put a column name after UNIQUE
and before the SRID.

Either of these would work:

DATA ' GEOM from STATES using UNIQUE ID srid 90112'

or

DATA ' GEOM from STATES using srid 90112'

Assuming you have a column named ID, of course.

Mike


-- 
Michael Smith
RSGIS Center
ERDC - CRREL
US Army Corps of Engineers




On 11/17/08  8:21 PM, "zach cruise" <zachc1980 at gmail.com> wrote:

> troubleshooting info on 4.8 box with /ignored-libmap/oracle10g/libmap.dll:
> shp2img -m oracle.map -o oracle.png -all_debug 10
> msOracleSpatialLayerOpen called with: GEOMETRY from STATES using
> unique srid 90112
> msOracleSpatialLayerOpen. Shared connection not available. Creating one.
> msConnPoolRegister(layername,username/password at databasename,019A68E8)
> msOracleSpatialLayerFreeItemInfo was called.
> msOracleSpatialLayerWhichShapes was called.
> msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error parsing
> OracleSpatial DATA variable. Must be:'geometry_column FROM table_name
> [USING UNIQUE <column> SRID srid# FUNCTION]' or 'geometry_column FROM
> (SELECT stmt) [USING UNIQUE <column> SRID srid# FUNCTION]'. If want to
> set the FUNCTION statement you can use: FILTER, RELATE, GEOMRELATE or
> NONE. Your data statement: GEOM from STATES using unique srid 90112
> 
> On Mon, Nov 17, 2008 at 7:34 PM, zach cruise <zachc1980 at gmail.com> wrote:
>> btw i got oracle 10 client (with tnsnames.ora) on 4.8 box. other than
>> returning multiple ora-xxxx errors, 4.8 also returns "web template
>> error" if i use /ignored-libmap/oracle10g/libmap.dll. this error is
>> even for only shapefile maps. error goes away when i switch back to
>> normal libmap.dll.
>> 
>> On Mon, Nov 17, 2008 at 5:56 PM, zach cruise <zachc1980 at gmail.com> wrote:
>>> looks like mod_fastcgi is not an option with ms4w and oracle 10.
>>> anyway it had little benefits.
>>> 
>>> i now got mapserver 5.2 and 4.8:
>>> i thought 5.2 had native built-in support for oracle 10, but it is
>>> giving me "OracleSpatial is not supported" error. i also thought 4.8
>>> could get ogr support for oracle 10 by following the steps on
>>> 
http://www.maptools.org/ms4w/index.phtml?page=README_INSTALL.html#oracle-10g>>>
.
>>> 4.8 connects, but returns multiple ORA-xxxx errors.
>>> 
>>> so:
>>> do i have to install oracle 10 client locally and make changes to
>>> httpd.conf for 5.2 to work?
>>> how do i find correct srid for 4.8 to work? (DATA "GEOMETRY from
>>> (select GEOMETRY from STATES where NAME = 'New York')")
>>> any performance difference between native built-in and ogr supports?
>>> 
>>> On Fri, Nov 14, 2008 at 6:22 PM, Jeff McKenna
>>> <jmckenna at gatewaygeomatics.com> wrote:
>>>> zach cruise wrote:
>>>>> 
>>>>> does current ms4w with fastcgi work with oracle 10?
>>>>> 
>>>>> here're warnings
>>>>> http://www.maptools.org/ms4w/?page=README_INSTALL.html#f-fastcgi
>>>>> 
>>>>> http://www.nabble.com/fastcgi-connections-to-Oracle-and-SDE-on-Windows-to1
>>>>> 8394152.html
>>>>> in testing this was successful with PostgreSQL 8.3.1 / PostGIS 1.3.3,
>>>>> but unsuccessful with Oracle 10.2.0.1.0 (Apache logs: "mod_fcgid: get
>>>>> overlap result error")
>>>>> 
>>>>> if not, any workarounds?
>>>> 
>>>> I tested and wrote that note...and am not aware of a workaround yet. You
>>>> should also send this question to the MS4W mailing list (subscribe at:
>>>> http://lists.maptools.org/mailman/listinfo/ms4w-users)
>>>> 
>>>> 
>>>> --
>>>> Jeff McKenna
>>>> FOSS4G Consulting and Training Services
>>>> http://www.gatewaygeomatics.com/
>>>> 
>>>> 
>>>> _______________________________________________
>>>> mapserver-users mailing list
>>>> mapserver-users at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>>>> 
>>> 
>> 
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users