[Mapserver-users] Empty image with Oracle Spatial (polygons and lines)

[arie van Halem]

Hi List,

I've installed mapserver version 4.0.1 with Oracle input
(ms401_png_oracle.zip) on a windows2000 machine with apache 2. As I try to
get a map based on an oracle table I get an empty image.

The map definition I use is:

  MAP

    IMAGETYPE PNG

    EXTENT -14000 294000 283750 641250
    UNITS METERS
    SIZE 600 400
    IMAGECOLOR 255 255 0
    SHAPEPATH "data"
    DEBUG ON

    WEB
      LOG "\mslog.txt"
    END

    LAYER
      DEBUG ON
      NAME regio
      CONNECTIONTYPE oraclespatial
      CONNECTION "usr/pwd at orcl"
      DATA "geom FROM regio USING SRID 90112"
      STATUS DEFAULT
      TYPE POLYGON
      CLASS
        COLOR 128 128 128 # gray-filled
        OUTLINECOLOR 0 0 0 # black contour
      END

    END

  END

The request I use:
  http://localhost/cgi-bin/mapserv.exe?map=/mapdata/test.map&mode=map

The logfile (\mslog.txt) shows:
  Wed Feb 18 08:59:16 2004,2532,127.0.0.1,MS,3,-125988.125000 294000.000000
395738.125000 641250.000000,-1.000000   -1.000000,,normal execution

The apache error file shows:
  [Wed Feb 18 08:59:16 2004] [error] [client 127.0.0.1] Wed Feb 18 08:59:16
2004 - msBuildPath: Unable to access file.
The query in oracle that mapsserver is running returns 25 rows (with
polygons), I tested that.
When I try to show point data based on an oracle table, mapserver does draw
it correctly. Polygon and line data is not drawn.
When I try to show the same data from a shape-file, mapserver does draw the
polygons correctly.

Can someone help me out?

Arie van Halem
arie at vanhalem.net

- sorry for poor enlish -