[Mapserver-users] oracle spatial mapfile

Sat Jun 12 05:06:04 PDT 2004

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C45075.14BB5F9A
Content-Type: text/plain;
	charset="iso-8859-1"

 Sylvain,

The error message indicates that Oracle Spatial support was not compiled in
to mapserver. If you are using the unix/linux version you will need to add
--with-oraclespatial=/path/to/oraclehome option to your configure command
and re-make the build. If you are using Windows, there is a build including
oraclespatial on the Mapserver download page but you'll need the oracle
client dll's from otn.oracle.com .

In either case, the data string is "geometry_column from table_name" so
GEOLOC needs to be your geometry column. If you loaded your spatial data
using OGR, the column is probably called ogr_geometry.

Mike Smith
ERDC/USACE
michael.smith at erdc.usace.army.mil

-----Original Message-----
From: Sylvain Beorchia
To: mapserver-users at lists.gis.umn.edu
Sent: 6/11/2004 5:52 AM
Subject: [Mapserver-users] oracle spatial mapfile

Hi list,

I try to display some data from oracle spatial in my mapserver project.
It
doesn't work.
Here is my mapfile layer:

LAYER
    NAME spa
    METADATA
        "DESCRIPTION" "Spatial"
        "LEGENDE" "1"
        "TYPE_LAYER" "ORA"
    END
    STATUS ON
    CONNECTIONTYPE oraclespatial
    CONNECTION "spa/sig at spa"
    DATA "GEOLOC from FP10010_LINES"
    TYPE LINE
    CLASS
        OUTLINECOLOR 0 0 0
        COLOR 0 128 128
    END

  END

The data in the database are from some Mapinfo TabFiles. SO i've got a
table
FP10010_LINES with the GEOLOC field, that's why i've tried to retreive
data
with "GEOLOC from FP10010_LINES".

So, when i launch my IE, i've got the following errors :

    "Warning: MapServer Error in msOracleSpatialLayerOpen():
OracleSpatial
is not supported in C:\ms4w\apps\gmap\htdocs\gmap.php3 on line 616"
    "Fatal error: Call to a member function on a non-object in
C:\ms4w\apps\gmap\htdocs\gmap.php3 on line 617"

My oracle version is 8i (8.1.7)

Any ideas ?
Thank u.

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

------_=_NextPart_001_01C45075.14BB5F9A
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2655.35">
<TITLE>RE: [Mapserver-users] oracle spatial mapfile</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2> Sylvain,</FONT>
</P>

<P><FONT SIZE=3D2>The error message indicates that Oracle Spatial =
support was not compiled in to mapserver. If you are using the =
unix/linux version you will need to add =
--with-oraclespatial=3D/path/to/oraclehome option to your configure =
command and re-make the build. If you are using Windows, there is a =
build including oraclespatial on the Mapserver download page but you'll =
need the oracle client dll's from otn.oracle.com .</FONT></P>

In either case, the data string is =
"geometry_column from table_name" so GEOLOC needs to be your =
geometry column. If you loaded your spatial data using OGR, the column =
is probably called ogr_geometry.

<P><FONT SIZE=3D2>Mike Smith</FONT>
<BR><FONT SIZE=3D2>ERDC/USACE</FONT>
<BR><FONT SIZE=3D2>michael.smith at erdc.usace.army.mil</FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Sylvain Beorchia</FONT>
<BR><FONT SIZE=3D2>To: mapserver-users at lists.gis.umn.edu</FONT>
<BR><FONT SIZE=3D2>Sent: 6/11/2004 5:52 AM</FONT>
<BR><FONT SIZE=3D2>Subject: [Mapserver-users] oracle spatial =
mapfile</FONT>
</P>

<P><FONT SIZE=3D2>Hi list,</FONT>
</P>

<P><FONT SIZE=3D2>I try to display some data from oracle spatial in my =
mapserver project.</FONT>
<BR><FONT SIZE=3D2>It</FONT>
<BR><FONT SIZE=3D2>doesn't work.</FONT>
<BR><FONT SIZE=3D2>Here is my mapfile layer:</FONT>
</P>

<P><FONT SIZE=3D2>LAYER</FONT>
<BR><FONT SIZE=3D2>    NAME spa</FONT>
<BR><FONT SIZE=3D2>    METADATA</FONT>
<BR><FONT SIZE=3D2>        =
"DESCRIPTION" "Spatial"</FONT>
<BR><FONT SIZE=3D2>        =
"LEGENDE" "1"</FONT>
<BR><FONT SIZE=3D2>        =
"TYPE_LAYER" "ORA"</FONT>
<BR><FONT SIZE=3D2>    END</FONT>
<BR><FONT SIZE=3D2>    STATUS ON</FONT>
<BR><FONT SIZE=3D2>    CONNECTIONTYPE =
oraclespatial</FONT>
<BR><FONT SIZE=3D2>    CONNECTION =
"spa/sig at spa"</FONT>
<BR><FONT SIZE=3D2>    DATA "GEOLOC from =
FP10010_LINES"</FONT>
<BR><FONT SIZE=3D2>    TYPE LINE</FONT>
<BR><FONT SIZE=3D2>    CLASS</FONT>
<BR><FONT SIZE=3D2>        =
OUTLINECOLOR 0 0 0</FONT>
<BR><FONT SIZE=3D2>        COLOR 0 =
128 128</FONT>
<BR><FONT SIZE=3D2>    END</FONT>
</P>

<P><FONT SIZE=3D2>  END</FONT>
</P>

The data in the database are from some Mapinfo =
TabFiles. SO i've got a
 table
 FP10010_LINES with the GEOLOC field, that's why i've =
tried to retreive
 data
 with "GEOLOC from FP10010_LINES".

<P><FONT SIZE=3D2>So, when i launch my IE, i've got the following =
errors :</FONT>
</P>

<P><FONT SIZE=3D2>    "Warning: MapServer Error in =
msOracleSpatialLayerOpen():</FONT>
<BR><FONT SIZE=3D2>OracleSpatial</FONT>
<BR><FONT SIZE=3D2>is not supported in =
C:\ms4w\apps\gmap\htdocs\gmap.php3 on line 616"</FONT>
<BR><FONT SIZE=3D2>    "Fatal error: Call to a =
member function on a non-object in</FONT>
<BR><FONT SIZE=3D2>C:\ms4w\apps\gmap\htdocs\gmap.php3 on line =
617"</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>My oracle version is 8i (8.1.7)</FONT>
</P>

<P><FONT SIZE=3D2>Any ideas ?</FONT>
<BR><FONT SIZE=3D2>Thank u.</FONT>
</P>

<P><FONT =
SIZE=3D2>_______________________________________________</FONT>
<BR><FONT SIZE=3D2>Mapserver-users mailing list</FONT>
<BR><FONT SIZE=3D2>Mapserver-users at lists.gis.umn.edu</FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://lists.gis.umn.edu/mailman/listinfo/mapserver-users" =
TARGET=3D"_blank">http://lists.gis.umn.edu/mailman/listinfo/mapserver-us=
ers</A></FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C45075.14BB5F9A--