Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem in Connection between MapServer and Oracle Spatial

480366Jan 11 2006 — edited Jan 11 2006
Hi Everybody,
First i thanks Dan Abugov for quick reply fr my previous query.

I am working on the Oracle Spatial and MapServer

I want to clear that MapServer is not Oracle MapViewer, this is Open Source UMN MapServer.

When I pass the query(shown below), the empty image is displayed in the browser without any map
http://localhost/cgi-bin/mapserv.exe?map=/ms4w/apps/sdocountry/sdocountry.map&layers=country&mode=map

I created .map file (shown below) with the Oracle Spatial Connection.

MAP
DEBUG ON
STATUS ON
SIZE 800 600
UNITS dd
IMAGECOLOR 255 255 255

PROJECTION
"proj=latlong"
"ellps=WGS84"
END

EXTENT -180 -45 180 45

LAYER
DEBUG ON
PROJECTION
"proj=latlong"
"ellps=WGS84"
END

NAME "CountryMap"
TYPE POLYGON

CONNECTIONTYPE oraclespatial
CONNECTION "world/land@orcl"
DATA "shape FROM country USING SRID 8307"

CLASS
NAME "Country_Class"
STYLE
COLOR 250 250 0
OUTLINECOLOR 32 32 32
END
END
END
END


And Set the environment variable in the apache/conf/httpd.conf file as
SetEnv ORACLE_BASE "d:/oracle/product/10.2.0"
SetEnv ORACLE_HOME "d:/oracle/product/10.2.0/db_1"
SetEnv ORACLE_SID "orcl"
SetEnv TNS_ADMIN "d:/oracle/product/10.2.0/db_1/network/admin"

This is the my whole Sample code and configuration, I dont know why the map image is not generating.

I am not receving any error message.

MapServer for windows (ms4w) binaries is downloaded from "maptools.org"

System configuration
Windows 2000 Advanced Server
Oracle 10g with Oracle Spatial
MapServer 4.6.1
Apache/2.0.55 (Win32)

I am waiting for the some solution, from you to over come this problem.

Thanks & Regards,
Prema Selvam
GISbiz.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 8 2006
Added on Jan 11 2006
1 comment
810 views