[mapserver-users] oracle8.1.7 and mapserver
nida Khan
nida@webstar.co.uk
Fri, 15 Nov 2002 14:28:25 -0000
This is a multi-part message in MIME format.
------=_NextPart_000_006B_01C28CB3.42274660
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
Thank you so much Yu-Hsin for your reply,
luckily I found a windows binary for oracle on some site!
It works fine when it reads a shape file, but when I try to connect to =
oracle database it does'nt any image! as if it didnt find any thing =
(nothing in log file either).
I've got a demo data from "mapviewer" in my oracle database!
and this is what I'm using in my layer
(this is a example layer from postgres)
NAME ORA
EXTENT -159.6 28.77 -71.4667 70.5
SIZE 400 300
LAYER # start of the "cities" layer object
CONNECTIONTYPE oraclespatial
NAME "cheshire"
CONNECTION scott/tiger@MYDB
DATA "select geom from cities"
#FILTER "city =3D 'Albany' "
STATUS DEFAULT
TYPE POINT
CLASS
COLOR 120 120 220
OUTLINECOLOR 10 10 0
END # end of class object
END # end of layer object
END # end of map file
(from my Oracle db)
SQL> select * from cities where city=3D'Albany';
LOCATION(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, =
SDO_ORDINATES)
-------------------------------------------------------------------------=
-------
CITY ST POP90 RANK90
------------------------------------------ -- ---------- ----------
SDO_GEOMETRY(2001, NULL, SDO_POINT_TYPE(-73.799017, 42.66575, NULL), =
NULL, NULL)
Albany NY 101082 192
Now is there anything I need to change in the layer to get this data =
from the database???
I really appreciate your help!
Kind Regards
Nida.
----- Original Message -----=20
From: Yu-Hsin Chen=20
To: nida Khan ; mapserver-users@lists.gis.umn.edu=20
Sent: Friday, November 15, 2002 1:34 PM
Subject: RE: [mapserver-users] oracle8.1.7 and mapserver
Nida:
You need to compile MapServer with oraclespacial.
Your Oracle RDBMS needs to have Spacial option loaded. Hopefully =
you've already got this part, it is a good learning curve if you havn't.
What web server are you using? You might need to modify the =
configuration a little.
Once you have all the correct environment and settings it WILL work. =
I'm running MapServer on a Mandrake Linux server accessing Oracle 8.0.5 =
data on a UnixWare server through CGI.
Yu-Hsin
-----Original Message-----
From: nida Khan [mailto:nida@webstar.co.uk]
Sent: Friday, November 15, 2002 6:29 AM
To: mapserver-users@lists.gis.umn.edu
Subject: [mapserver-users] oracle8.1.7 and mapserver
Hi Everyone,
Is there anyway to connect to Oracle 8.1.7 database on Solaris via =
Mapserver?
I've compiled Mapserver with Postgress, but have no idea how to do =
it for Oracle now!
I would really appreciate if anyone can guide me to right =
documentation or just give me some codes!!!!
Looking forward for your replies
Regards
Nida.
------=_NextPart_000_006B_01C28CB3.42274660
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Hi,</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Thank you so much Yu-Hsin for your =
reply,</FONT></DIV>
<DIV><FONT size=3D2>luckily I found a windows binary for oracle on some=20
site!</FONT></DIV>
<DIV><FONT size=3D2>It works fine when it reads a shape file, but when I =
try to=20
connect to oracle database it does'nt any image! as if it didnt find any =
thing=20
(nothing in log file either).</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I've got a demo data from "mapviewer" in my oracle=20
database!</FONT></DIV>
<DIV><FONT size=3D2>and this is what I'm using in my layer</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>(this is a example layer from postgres)</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>NAME ORA<BR>EXTENT -159.6 28.77 -71.4667 =
70.5<BR>SIZE 400=20
300<BR>LAYER # start of the "cities" layer object<BR> =
CONNECTIONTYPE=20
oraclespatial<BR> NAME "cheshire"<BR> CONNECTION <A=20
href=3D"mailto:scott/tiger@MYDB">scott/tiger@MYDB</A><BR> DATA =
"select geom=20
from cities"<BR> #FILTER "city =3D 'Albany' "<BR> =
STATUS=20
DEFAULT<BR> TYPE POINT<BR> CLASS<BR> COLOR =
120 120=20
220<BR> OUTLINECOLOR 10 10 0<BR> END # end of =
class=20
object<BR>END # end of layer object<BR>END # end of map =
file<BR></FONT></DIV>
<DIV><FONT size=3D2>(from my Oracle db)</FONT></DIV>
<DIV><FONT size=3D2>SQL> select * from cities where =
city=3D'Albany';</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>LOCATION(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z),=20
SDO_ELEM_INFO,=20
SDO_ORDINATES)<BR>-------------------------------------------------------=
-------------------------<BR>CITY &nbs=
p;  =
; =
=20
ST POP90 =20
RANK90<BR>------------------------------------------ -- ----------=20
----------<BR>SDO_GEOMETRY(2001, NULL, SDO_POINT_TYPE(-73.799017, =
42.66575,=20
NULL), NULL,=20
NULL)<BR>Albany &nbs=
p;  =
; =
=20
NY =
101082 =20
192</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Now is there anything I need to change in the layer =
to get=20
this data from the database???</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I really appreciate your help!</FONT></DIV>
<DIV><FONT size=3D2>Kind Regards</FONT></DIV>
<DIV><FONT size=3D2>Nida.</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A title=3Dychen@yorktel.com href=3D"mailto:ychen@yorktel.com">Yu-Hsin =
Chen</A>=20
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
title=3Dnida@webstar.co.uk=20
href=3D"mailto:nida@webstar.co.uk">nida Khan</A> ; <A=20
title=3Dmapserver-users@lists.gis.umn.edu=20
=
href=3D"mailto:mapserver-users@lists.gis.umn.edu">mapserver-users@lists.g=
is.umn.edu</A>=20
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Friday, November 15, 2002 =
1:34=20
PM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> RE: [mapserver-users]=20
oracle8.1.7 and mapserver</DIV>
<DIV><FONT size=3D2></FONT><FONT size=3D2></FONT><FONT =
size=3D2></FONT><BR></DIV>
<DIV><SPAN class=3D545462213-15112002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Nida:</FONT></SPAN></DIV>
<DIV><SPAN class=3D545462213-15112002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D545462213-15112002><FONT face=3DArial =
color=3D#0000ff size=3D2>You=20
need to compile MapServer with oraclespacial.</FONT></SPAN></DIV>
<DIV><SPAN class=3D545462213-15112002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D545462213-15112002><FONT face=3DArial =
color=3D#0000ff size=3D2>Your=20
Oracle RDBMS needs to have Spacial option loaded. Hopefully =
you've=20
already got this part, it is a good learning curve if you=20
havn't.</FONT></SPAN></DIV>
<DIV><SPAN class=3D545462213-15112002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D545462213-15112002><FONT face=3DArial =
color=3D#0000ff size=3D2>What=20
web server are you using? You might need to modify the =
configuration a=20
little.</FONT></SPAN></DIV>
<DIV><SPAN class=3D545462213-15112002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D545462213-15112002><FONT face=3DArial =
color=3D#0000ff size=3D2>Once=20
you have all the correct environment and settings it WILL work. =
I'm=20
running MapServer on a Mandrake Linux server accessing Oracle 8.0.5 =
data on a=20
UnixWare server through CGI.</FONT></SPAN></DIV>
<DIV><SPAN class=3D545462213-15112002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D545462213-15112002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Yu-Hsin</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> nida Khan=20
[mailto:nida@webstar.co.uk]<BR><B>Sent:</B> Friday, November 15, =
2002 6:29=20
AM<BR><B>To:</B> =
mapserver-users@lists.gis.umn.edu<BR><B>Subject:</B>=20
[mapserver-users] oracle8.1.7 and mapserver<BR><BR></FONT></DIV>
<DIV><FONT size=3D2>Hi Everyone,</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Is there anyway to connect to Oracle 8.1.7 =
database on=20
Solaris via Mapserver?</FONT></DIV>
<DIV><FONT size=3D2>I've compiled Mapserver with Postgress, but have =
no idea=20
how to do it for Oracle now!</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I would really appreciate if anyone can guide me =
to right=20
documentation or just give me some codes!!!!</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Looking forward for your replies</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Regards</FONT></DIV>
<DIV><FONT size=3D2>Nida.</FONT></DIV>
<DIV> </DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_006B_01C28CB3.42274660--