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

[nicolas.fortin at ec.gc.ca]

Hi,

Are you sure that the SDO_GTYPE is the right one in Oracle (polygon) and
that the SRID in the map file and in Oracle are the same ?

Nick

-----Message d'origine-----
De : arie van Halem [mailto:arie at vanhalem.net] 
Envoyé : Wednesday, February 18, 2004 3:29 AM
À : mapserver-users at lists.gis.umn.edu
Objet : [Mapserver-users] Empty image with Oracle Spatial (polygons and
lines)


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 -

_______________________________________________
Mapserver-users mailing list
Mapserver-users at lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users