oracle layers: php sometime crashes

[fsozzi]

Hi Fernando and Bart,

Thanks for answer.

I've forgot the "'" in the mail, but in the map file it is correct.

Right now I did not found time to test the new version, but may be that 
next week I will find it. As soon as I will do the test I will tell you 
the result.

Bets regards

Francesco

-----Original Message-----
From: Fernando Siimon <fsimon at univali.br>
To: Bart van den Eijnden <BEN at SYNCERA-ITSOLUTIONS.NL>
Cc: MAPSERVER-USERS at LISTS.UMN.EDU, fsozzi at INTERCAD.CH
Date: Thu, 18 Aug 2005 13:15:12 -0300
Subject: Re: [UMN_MAPSERVER-USERS] oracle layers: php sometime crashes

> Hi,
>     Is it right the "," before FROM clause?
>     As Bart, I suggest to use the 4.6 version, it's more stable and 
> contains some improves in the code that can help with this problem.
>     Thanks.
> 
> -----------------------------------------------------------------------
> -
> Fernando Simon
> Mapserver and Oracle Spatial developer
> G10 - Laboratorio de Computacao Aplicada - Brazil
> http://g10.cttmar.univali.br - UNIVALI/CTTMAR
> -----------------------------------------------------------------------
> -
> 
> Bart van den Eijnden wrote:
> 
> >Are you able to upgrade to Mapserver/Mapscript 4.6 and see if the
> problem is still there?
> >
> >Best regards,
> >Bart
> >
> >Bart van den Eijnden
> >Syncera IT Solutions
> >Postbus 270
> >2600 AG  DELFT
> >
> >tel.nr.: 015-7512436
> >email: BEN at Syncera-ITSolutions.nl
> >
> >  
> >
> >>>>Francesco Sozzi <fsozzi at INTERCAD.CH> 08/18/05 05:20pm >>>
> >>>>        
> >>>>
> >Hi all,
> >
> >I have a trouble in using QueryByAttributes or QueryByShape on an
> Oracle Spatial layer: PHP sometime crashes.
> >The strange thing is that it happens only on some layer and on some
> PC.
> >I have a test installation with exactly the same php code, Apache
> version, Mapserver version, Oracle Version, OS version (Windows XP
> Professional) and on one machine works fine and on another php crashes
> (and only on one oracle layer, for the other oracle layers it works
> fine).
> >
> >Has anybody already experimented a problem like this?....
> >
> >Bets regards
> >
> >
> >
> >I use:
> >- PHP 4.3.10
> >- Mapserver 4.4.1
> >- Apache 2
> >- Windows XP
> >
> >The test code is:
> ><?php
> >
> >$gMap = ms_newMapObj("C:/App/QueryMapWEB/data/AIL/gas.map");
> >$gLayer = $gMap->getLayerByName("Condotte");
> >
> >$rectDrawnedMapCoord = ms_newrectObj();
> >$rectDrawnedMapCoord->setextent(716765.866548,
> >    89471.4128114 ,
> >    717831.590747,
> >    87732.5996441);
> >
> >$qresult = $gLayer->queryByRect($rectDrawnedMapCoord);
> >$layer->open();
> >
> >?>
> >
> >The layer definition is:
> >#
> -----------------------------------------------------------------------
> -
> ># Condotte
> >#
> -----------------------------------------------------------------------
> -
> >LAYER
> > NAME "Condotte"
> > TYPE LINE 
> > CONNECTIONTYPE oraclespatial
> > CONNECTION "ail_gas/avs at tb"
> > DATA "GEOM FROM (SELECT fid,geom,FROM ga_strang WHERE geom is not
> null AND DELETED=0) USING UNIQUE fid NONE"
> > STATUS DEFAULT 
> > SYMBOLSCALE 200
> >        
> > CLASS  
> >  NAME "nessuna"
> >  COLOR 0 0 0
> >  SYMBOL 1
> >  SIZE 8
> >  TEMPLATE "templates/default.html"
> > END
> > 
> >END
> >
> >  
> >
>