[UMN_MAPSERVER-USERS] oracle spatial troubles

[Fortin,Nicolas [SteFoy]]

Yes it's a good idea!

I also had the same problems with this version that I had with the binaries from hobu site.

Few times, it works but most of the time, I get a CGI error page from oraclespatial layers.

It would be also fine to have a guide to the change we have to made to our mapfile to make it works correctly.  I read some days ago that the DATA element can't be write as it was in 4.2 for oraclespatial layers.

Thx to all who are trying to solve this problem!

Nicolas

-----Message d'origine-----
De : UMN MapServer Users List [mailto:MAPSERVER-USERS at lists.umn.edu] De la part de Trent Burton
Envoyé : Friday, December 17, 2004 11:19 AM
À : MAPSERVER-USERS at lists.umn.edu
Objet : Re: [UMN_MAPSERVER-USERS] oracle spatial troubles


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