[mapserver-users] oracle spatial layer not shown

[Gregor Friedrich]

Hi Folks
I have trouble to set up a mapservice with a oracle spatial layer. The 
setup in the mapfile (EXTENT, LAYER, TEMPLATE) is the same like the 
shapefile version and the shapefile has been uploaded with the oracle 
shapefile uploader for Oracle 9i. (shp2sdo) The are no error messages from 
mapserv(ORA... etc), but the map is still emty (blank). The shapefile 
version works fine and the logfiles are exactly the same ....
The mapserver (3.6)  works on a PII Linux system (SUSE 7.3) with Oracle 9i 
Client
----------------------------------------
oracle -log
Fri Jun  7 10:33:11 2002,7770,141.65.97.151,Biotoptypen,0,4582813.250000 
5616806.700000 4602365.750000 5632464.300000,-1.000000 -1.000000,biotges 
,normal execution
------------------------------------------
file-log
Fri Jun  7 10:32:39 2002,7769,141.65.97.151,DEMO,0,4582813.250000 
5616806.700000 4602365.750000 5632464.300000,-1.000000 -1.000000, biotges 
,normal execution
--------------------------------------
Here are the map definitions:
--------------------------------------------
file - version:
#
# Start of map file
#
NAME DEMO
STATUS ON
SIZE 550 440
EXTENT 4582813.250 5619330.750 4602365.750 5629940.250
UNITS METERS
FONTSET /usr/local/httpd/htdocs/fonts/fonts.list
SHAPEPATH "../data"
IMAGECOLOR 255 255 255
#
# Start of web interface definition (including WMS enabling metadata)
#
WEB
   #HEADER demo_header.html
   TEMPLATE biotop.html
   #FOOTER demo_footer.html
   MINSCALE 1000
   MAXSCALE 1550000
   LOG "/usr/local/httpd/htdocs/tmp/test4.log"
   IMAGEPATH "/usr/local/httpd/htdocs/tmp/"
   IMAGEURL "/tmp/"
   METADATA
     WMS_TITLE "UFZ MapServer "
     WMS_ABSTRACT "Biotoptypen und Brunnen Beispiel 1"
     WMS_ACCESSCONSTRAINTS none
     # change this value to match your setup
     WMS_ONLINERESOURCE "http://host/test4/index.html"
     WMS_SRS "EPSG:4326"
   END
END
QUERYMAP
   SIZE 200 200
   STATUS ON
   STYLE HILITE
   COLOR 255 0 0
END
#
# Start of reference map
#
REFERENCE
   SIZE 150 160
   IMAGE graphics/ref_map.png
   EXTENT 4583702.000 5619813.000 4601477.000 5629458.000
   STATUS ON
   COLOR -1 -1 -1
   OUTLINECOLOR 255 0 0
END
#
LEGEND
STATUS ON
   LABEL
     TYPE TRUETYPE
     FONT arial
     SIZE 10
     COLOR 0 0 0
#    ANTIALIAS
   END  #Label
END   #LEGEND
#
# Start of scalebar
#
SCALEBAR
   IMAGECOLOR 255 255 255
   LABEL
     COLOR 0 0 0
     SIZE SMALL
   END  #LABEL
   SIZE 300 5
   COLOR 255 255 255
   BACKGROUNDCOLOR 0 0 0
   OUTLINECOLOR 0 0 0
   UNITS meters
   INTERVALS 10
   STATUS ON
END   #SCALEBAR
# Start of layer definitions
#
LAYER
   NAME biotges
   TYPE Polygon
   STATUS on
   DATA biotges

   CLASS
      COLOR 128 128 128
      OUTLINECOLOR 0 0 0
   END  # CLASS
END  # LAYER
END  # MAPFILE
---------------------------------------------------------------------------------
oracle spatial version:
#
# Start of map file
#
NAME Biotoptypen
STATUS ON
SIZE 550 440
EXTENT 4582813.250 5619330.750 4602365.750 5629940.250
UNITS METERS
FONTSET /usr/local/httpd/htdocs/fonts/fonts.list
IMAGECOLOR 255 255 255

# Start of web interface definition (including WMS enabling metadata)
#
WEB
   #HEADER demo_header.html
   TEMPLATE index.html
   #FOOTER demo_footer.html
   LOG "/usr/local/httpd/htdocs/tmp/bio_spatial.log"
   IMAGEPATH "/usr/local/httpd/htdocs/tmp/"
   IMAGEURL "/tmp/"
   METADATA
     WMS_TITLE "UFZ MapServer "
     WMS_ABSTRACT "Biotoptypen und Brunnen Beispiel 1"
     WMS_ACCESSCONSTRAINTS none
     # change this value to match your setup
     WMS_ONLINERESOURCE "http://host/bio_spatial/init.html"
     WMS_SRS "EPSG:4326"
   END
END

#
# Start of reference map
#
REFERENCE
   SIZE 150 160
   IMAGE graphics/ref_map.png
   EXTENT 4583702.000 5619813.000 4601477.000 5629458.000
   STATUS ON
   COLOR -1 -1 -1
   OUTLINECOLOR 255 0 0
END
#
#
# Start of scalebar
#
SCALEBAR
   IMAGECOLOR 255 255 255
   LABEL
     COLOR 0 0 0
     SIZE SMALL
   END  #LABEL
   SIZE 300 5
   COLOR 255 255 255
   BACKGROUNDCOLOR 0 0 0
   OUTLINECOLOR 0 0 0
   UNITS meters
   INTERVALS 10
   STATUS ON
END   #SCALEBAR

# ***
# Start of layer definitions
#
#
LAYER
   NAME biotges
   CONNECTIONTYPE oraclespatial
   CONNECTION "user/passwd at sid"
   TYPE Polygon
   STATUS on
   DATA "geom FROM BIOTGES"

   CLASS
     COLOR 128 128 128
     OUTLINECOLOR 0 0 0
   END  # CLASS

END  # LAYER

END  # MAPFILE

Any ideas ???

Thanks in advance

  Gregor