[Mapserver-users] oracle spatial mapfile
Smith, Michael ERDC-CRREL-NH
Michael.Smith at erdc.usace.army.mil
Sat Jun 12 08:06:04 EDT 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>
<P><FONT SIZE=3D2>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.</FONT></P>
<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>
<P><FONT SIZE=3D2>The data in the database are from some Mapinfo =
TabFiles. SO i've got a</FONT>
<BR><FONT SIZE=3D2>table</FONT>
<BR><FONT SIZE=3D2>FP10010_LINES with the GEOLOC field, that's why i've =
tried to retreive</FONT>
<BR><FONT SIZE=3D2>data</FONT>
<BR><FONT SIZE=3D2>with "GEOLOC from FP10010_LINES".</FONT>
</P>
<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--
More information about the mapserver-users
mailing list