[mapserver-users] oracle spatial 9i

[Mikael Grønfeldt]

Hi Tim and Rodrigo

We have the same problem here in Copenhagen.

We're using Oracle 9.2.0.1.0 and IAS with Server version: Apache/1.3.12
(Unix),Server built:   Aug 18 2000 16:14:55
both running on a HP-UX B.11.00 64 bit.

We have mapserver 3.6.1 running on a NT platform (Apache/1.3.23) and the NT
mapserver are able to connect to our database and display objects from the
database without any problems.

We have also compiled a version of mapserver on our Unix platform, we have
compiled it as 64 bit, as long as we dont try to connect to the Oracle
database mapserver works fine, but when we try to access the database the
mapserver craches and Apache returns with a "internal server Error" and the
following is added to the Apache error_log:

/oracle/oasTEST/OAS9i/Apache/Apache/cgi-bin/map[6]: 13629 Bus
error(coredump)
[Tue Aug 20 11:23:24 2002] [error] [client 10.1.100.78] Premature end of
script 
headers: /oracle/oasTEST/OAS9i/Apache/Apache/cgi-bin/map

We think we have located the problem to line 283 in maporaclespatial.c:

TRY( layerinfo,
    /* allocate envhp */
    OCIEnvCreate( &layerinfo->envhp, OCI_OBJECT, (dvoid *)0, 0, 0, 0,
(size_t) 0, (dvoid **)0 ) )
  &&

If we /* */  the TRY call and compile a new mapserver we get:
"msOCIConnect() in msOracleSpatialLayerOpen(): OracleSpatial error.
OCI_INVALID_HANDLE" back from the mapserver when we try to connect to the
database.


I hope this information can help 


Mikael Gronfeldt
Head of Section
Danish Directorate of Fisheries
http://www.fd.dk


-----Original Message-----
From: Mackey Timothy [mailto:Timothy.Mackey at ga.gov.au]
Sent: Tuesday, August 20, 2002 6:08 AM
To: Rodrigo Zanato Tripodi
Cc: mapserver-users at lists.gis.umn.edu
Subject: RE: [mapserver-users] oracle spatial 9i


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