oracle spatial troubles

[Trent Burton]

Can we get the Windows binaries updated on the MapServer web site with this
fix?

Thanks,

Trent Burton



Hi Francesco,

I also had some problems with mapserver 4.4.0 and Oracle and I could solve
them by doing the following changes in maporaclespatial.c:

In function msOracleSpatialLayerClose

I put the following lines in comments because I see that
msOCIClearLayerInfo still needs the connection

/*    if (layer->debug)
      msDebug("msOracleSpatialLayerClose. Cleaning Oracle handlers.\n");

    msConnPoolRelease( layer, layerinfo->orahandlers );
    layerinfo->orahandlers = NULL;
*/
    if (layer->debug)
      msDebug("msOracleSpatialLayerClose. Cleaning layerinfo handlers.\n");

    msOCIClearLayerInfo( layerinfo );

    if (layer->debug)
      msDebug("msOracleSpatialLayerClose. Cleaning Oracle handlers.\n");

    msConnPoolRelease( layer, layerinfo->orahandlers );
    layerinfo->orahandlers = NULL;


Could you also check if this changes does not affect the Linux (*nix)
implementations? I did check this changes in Windows XP, Windows 2003 and
Windows 2000 using Oracle Client 9.2 and connecting to a Oracle 10G
database.

Cheers,

Valik Solórzano Barboza

-----Original Message-----
From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On
Behalf Of Fernando S.
Sent: 16 December 2004 17:49
To: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: Re: oracle spatial troubles

Hi Francesco,
    In this last version (4.4) the Oracle driver change.
    So, how did you defined your layer data string?
    Are you using Linux (*nix) or Windows? Some users report error with
Windows binaries, Linux are working. I'm working to find the problem.
    Thanks.

----------------------------------------------------------------
Fernando Simon - simon at inf.univali.br
Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada http://g10.cttmar.univali.br
----------------------------------------------------------------


Francesco Sozzi wrote:

>Hi all,
>
>MAPSERVER 4.4
>I'm trying reading oracle spatial tables from a server Oracle 9i
>Enterprise Edition by use of mapserver 4.4.0. The problem is that on
>submitting map file from browser, in one machine I get a general
>protection fault, and in another I get a CGI error. In both case I
>can't read any oracle spatial data. I have to say that my mapserver
>installation works fine with shp and rasters. I have troubles only with
>oracle.
>
>MAPSERVER 4.2
>I've also tried this version, and it works a little better. In this
>case I can renderer points and lines, but if I try to renderer a
>polygon I get an error (mapserver says that it finds no polygon
>geometry). These tables work fine with other products (MapGuide,
>ArcView, MapObject, ecc...).
>
>Anybody can suggest me something?...
>
>regards
>
>Francesco
>
>
>