oracle spatial connection

[Rahkonen Jukka]

Hi,

I would check first if the extents of the map file and data returned from Oracle match. Oracle used to have only its own SRID system (nothing to do with epsg codes) before 10g version. Make a simple SQL request directly with SQL*Plus for one feature 
only and check if the coordinates you get really fall inside your map extents.

-Jukka Rahkonen-

-----Original Message-----
From: UMN MapServer Users List on behalf of Gagan Bansal
Sent: Sat 15.9.2007 12:51
To: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: [UMN_MAPSERVER-USERS] oracle spatial connection
 
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