oracle spatial troubles

[Valik Solorzano Barboza]

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
>
>
>