[mapserver-users] oracle spatial 9i

[Hugues Parvillers]

Hello Yu_Hsin,

You should try Spatial 9i :  it works very much faster with MapServer for my own tests and this really comes from Oracle.

H/P


Yu-Hsin Chen a écrit :

> Yes, as Hugues pointed out in 0202/msg00333.html, I did get specific Oracle error messages.
>
> It is not an effortless task to use MapServer with its native Oracle cupport, however, isn't that the reason why we love computer work?
>
> First of all you have to know for sure that MapServer is talking to Oracle already.  For me, running Mandrake Linux and Apache I had to modify my commonhttpd.conf to include the ORACLE_HOME and ORACLE_SID before the MapServer started to communicate with Oracle.  If you never seen an Oracle error there might be a high probability that MapServer is not talking to Oracle yet.  Once you overcome this communications hurdle then you need to have operating knowledge about Oracle's SDO schema which is the spatial option of Oracle.  Oracle's SDO implementation is highly object orientated and not the same as the traditional relational database model as we're familiar with.
>
> One final note, I was on MapServer 3.5 and Oracle 8.1.7i.  I haven't got time to play with either 3.6 or 9i.
>
> Yu-Hsin
>
> -----Original Message-----
> From: Hugues Parvillers [mailto:Hugues.Parvillers at AgdF.com]
> Sent: Tuesday, August 20, 2002 7:55 AM
> To: Mackey Timothy
> Cc: Rodrigo Zanato Tripodi; mapserver-users at lists.gis.umn.edu
> Subject: Re: [mapserver-users] oracle spatial 9i
>
> Tim,
>
> Don't you have the Oracle Error ?
>
> For example look at :  http://mapserver.gis.umn.edu/wilma/mapserver-users/0202/msg00333.html
>
> Yu had a defined  Oracle error !
>
> H/P
>
> Mackey Timothy a écrit :
>
> > Hi Rodrigo,
> >
> > We're using Oracle 9.2.0.1.0, and IAS 1.0.2.2.0.
> > We have installed the version of Oracle Spatial that came with Oracle 9i (release 2).
> >
> > The 3.6.1 code compiles fine, but requesting a map using mapserver CGI gives a mapserver error: "msOCIConnect() in msOracleSpatialLayerOpen(): OracleSpatial error."
> >
> > MapServer version 3.6.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP SUPPORTS=PROJ SUPPORTS=TTF SUPPORTS=WMS_SERVER INPUT=TIFF INPUT=EPPL7 INPUT=JPEG INPUT=SDE INPUT=ORACLESPATIAL INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE
> >
> > Tim
> >
> > -----Original Message-----
> > From: Rodrigo Zanato Tripodi [mailto:tripodi at cttmar.univali.br]
> > Sent: Tuesday, 20 August 2002 1:54 PM
> > To: mapserver-users at lists.gis.umn.edu
> > Subject: Re: [mapserver-users] oracle spatial 9i
> >
> > Hi,
> >
> > I'm working with Rodrigo Cabral at Oracle Spatial support for mapserver.
> >
> > Sorry about the lack of support. I was busy with a project at the last weeks.
> >
> > I never tried to compile the mapserver with OCI libs from Oracle 9i. But, I
> > will test this at this week and try to fix the code if I found any error.
> >
> > Can you send me the version of all libraries and the error that you get?
> >
> > Are you using Oracle IAS?
> >
> > Rodrigo Zanato Tripodi
> > Laboratório de Computação Aplicada - CTTMar/Univali
> > tripodi at cttmar.univali.br
> > http://g10.cttmar.univali.br
> >
> > At 16:55 19/08/02 +1000, Mackey Timothy wrote:
> > >Hi all,
> > >
> > >I've got mapserver 3.6.1 CGI to compile and work with Oracle Spatial
> > >8.1.7. However, when I compile and run against Oracle 9i (9.2.0.1.0) I get
> > >an OracleSpatial error.
> > >
> > >Does Oracle Spatial support only work with 8.x? If so, is it on the plans
> > >to upgrade to 9i?
> > >
> > >
> > >Tim Mackey
> > >Web Applications Manager
> > >Geoscience Australia
> > >timothy.mackey at ga.gov.au
> > >http://www.ga.gov.au