[Mapserver-users] Oracle Spatial and MapServer

[Averill Cate, Jr.]

Hi,

I got MapServer 4 talking to my Oracle server, however when I test the 
mapserver with:

http://dss-dev/cgi-bin/mapserv.exe?map=C:\oracle\ora92\Apache\Apache\htdocs\wg\wg.map&VERSION=1.1.0&REQUEST=GetMap

I get a blank image back from Map Server.  There should be two layers 
according to my map definition which is listed below the dashed line.

Does anyone know why the layers don't display?  Thanks for any help.


--------------------------------------------------------------------------------------------------------------------------------------------

# Generic MapServer MapFile with all potential elements (commented out)

# Begin with the 'root' map element
map
  EXTENT 580217 3503392 606269 3515517
  IMAGECOLOR 200 200 200 #IMAGECOLOR [r] [g] [b]
  IMAGETYPE PNG #IMAGETYPE [gif|png|jpeg|wbmp]
  INTERLACE ON #INTERLACE [on|off]
  NAME "WG" #NAME [name]
  # SHAPEPATH "shapefiles/" #SHAPEPATH [filename]
  SIZE 600 600 #SIZE [x][y]
  STATUS ON #STATUS [on|off]
  UNITS meters #UNITS [feet|inches|kilometers|meters|miles|dd]

  PROJECTION
     "init=epsg:26912" #"init=epsg:4326"
  END # PROJECTION
   
  WEB                           
    EMPTY "/wg/empty.html" #EMPTY [url] :relative to the web root of the 
server, in a directory from which html documents can be retreived
    TEMPLATE "wg_template.html" #TEMPLATE [filename|url]
    IMAGEPATH "/tmp/" #IMAGEPATH [path]
    IMAGEURL "/tmp/" #IMAGEURL [path]
    LOG "/tmp/map.log" #LOG [filename]
    METADATA                   
    END # METADATA             
  END # WEB

  LEGEND
     imagecolor 200 200 200
     status on
  END # Legend

  ###########################
  # The sub-basin layer
  ###########################
  LAYER
     NAME "SubWatersheds" #NAME [string]
     DATA "GEOMETRY from WATERSHEDS"
     TYPE polygon #TYPE [point|line|polygon|circle|annotation|raster|query]
     CONNECTIONTYPE oraclespatial
     CONNECTION "gis/gis at ORCL_DSS-DEV"
     LABELITEM "major_subw" #LABELITEM [attribute]
     STATUS on #STATUS [on|off|default]
     TEMPLATE "results_watersheds.html" #TEMPLATE [file|url]
         
     METADATA
     END # METADATA
    
     CLASS
    NAME "watersheds" #NAME [string]
    TITLE "Sub Watersheds"
    OUTLINECOLOR 0 0 0 #OUTLINECOLOR [r][g][b]
    LABEL
           ANTIALIAS true #ANTIALIAS [true|false]
           COLOR 255 255 255 #COLOR [r][g][b]
           SIZE medium #SIZE [integer]|[tiny|small|medium|large|giant]
       TYPE bitmap #TYPE [bitmap|truetype]
    END # LABEL
     END # CLASS
    
     PROJECTION
       "init=epsg:26912"
     END # PROJECTION
   END # Sub-Basin LAYER

   LAYER # Streams
      name "Streams"
      data "geometry from STREAMS"
      type line
      connectiontype oraclespatial
      connection "gis/gis at ORCL_DSS-DEV"
      status on
      template "results_streams.html"
     
      CLASS
         name "Streams"
         title "Streams"
         outlinecolor 0 0 255
      END # End class
     
      PROJECTION
         "init=epsg:26912"
      END # Projection
   END # Streams layer

END # MAP