oracle spatial connection

Gagan Bansal gagan.bansal at RELIANCEADA.COM
Sat Sep 15 05:51:57 EDT 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