oracle spatial connection
Gagan Bansal
gagan.bansal at RELIANCEADA.COM
Sat Sep 15 02:51:57 PDT 2007
i am trying to dispaly the oracle spatial 10g v2 data in mapserver but my
application display the blank page, not able to get where is the mistake
following has been done:
# -load shape file in oracle using shp2sdojava
- created spatial index on 'geom'
# swapping dll as described in the readme file of the mapserver
#Setting environment variables
- ORACLE_HOME : C:\oracle\product\10.2.0\db_1
- ORACLE_SID : orcl
- TNS_ADMIN : C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN
#here is the map file for oracle spatial data connection
MAP
NAME DEMO
STATUS ON
SIZE 400 300
SYMBOLSET ../etc/symbols.sym
EXTENT -1001942.225269 2155071.744446 -998438.476117 2158497.456450
UNITS METERS
SHAPEPATH "../data1"
IMAGECOLOR 255 255 255
FONTSET ../etc/fonts.txt
TRANSPARENT FALSE
# Start of web interface definition
WEB
IMAGEPATH "/ms4w/tmp/ms_tmp/"
IMAGEURL "/ms_tmp/"
LOG "/tmp/bigmaps_oracle.log"
MS_ERRORFILE "/tmp/bigmaps_oracle_error.log"
METADATA
END
END
# Start of reference map
PROJECTION
"init=epsg:32643"
END
# Start of layer definitions
LAYER
GROUP "Polygon"
NAME playground
CONECTIONTYPE oraclespatial
CONNECTION "scott/bigmaps at orcl"
DATA "GEOM FROM PLAYGROUND_UTM USING UNIQUE OBJECTID USING SRID
32643"
METADATA
"DESCRIPTION" "playground"
"RESULT_FIELDS" "OBJECTID"
"GROUP" "Polygon"
"LAYER" "playground"
END
TYPE POLYGON
STATUS ON
CLASS
NAME "playground"
COLOR 200 255 0
OUTLINECOLOR 120 120 120
END
TOLERANCE 5
END # Layer
END # Map File
log file also not being creaed in the specified folder?
Thanks of any help
Gagan
More information about the MapServer-users
mailing list