oracle layers: php sometime crashes

[Francesco Sozzi]

Hi All,

It works!!!
The problem is on Windows XP Service Pack: after updating it to version 2 
the problem is not exposed any more.

This is the story (may be it could be useful for somebody).
Before updating Service Pack, I tried to compile Mapserver 4.6 with both 
MSVC 6 and 7 but the result did not change: what I got worked fine with 
several PC (several Windows XP Professional and one Windows 2003 Server). 
But on that PC failed: the strange thing is that it worked on 
QueryByRectangle (or QueryByShape), but failed on DrawMap: changing version 
from 4.4 to 4.6 the problem moved from one group of functions to another 
group. And another very strange thing is that PHP crashed only on one 
specific Oracle Spatial layer; it worked fine with all other layers (Oracle, 
SHP, raster, ecc...).

Best 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>
Sent: Thursday, August 18, 2005 6:15 PM
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
>>
>>
>
>
>