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/[EMAIL PROTECTED],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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 >> <[EMAIL PROTECTED]> 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-to18394152.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@lists.osgeo.org >>> http://lists.osgeo.org/mailman/listinfo/mapserver-users >>> >> > _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users