Mapserver + oracle spatial

[Maher Karim]

Dear Damien,
The best way to use such a query is to create a view in Oracle with based
on your query and it should be in this form of
create or replace view (viewname) as SELECT
    GEO.GEOM, A.*, ID as UNIQUEID
FROM
    MAILLES_CIEM GEO ,
    (
        SELECT
            C0.code_geom,
            C0.label_metric LT,
            C0.valeur VT
        FROM
            SIH_CARTE_SIG C0
        WHERE
            1 = 1
            and session_id = 'b5b89cbf8a613059c7c41b9796c66c44'
            and NUM_COUCHE = '466533b224b29'
            and C0.rang = 0
    ) A
WHERE
    1 = 1
    and A.code_geom = GEO.CODECIEM
    and trim(GEO.CODECIEM) is not null
ORDER BY
    GEO.CODECIEM)
and use this data in the map file
data "geom from "Viewname" using unique UNIQUEID"

Regards
Maher Abdel Karim
GIS systems analyst/programmer
DC Water and Environment



|---------+--------------------------------->
|         |           Damien Corpataux      |
|         |           <damien.corpataux at CAMP|
|         |           TOCAMP.COM>           |
|         |           Sent by: UMN MapServer|
|         |           Users List            |
|         |           <MAPSERVER-USERS at LISTS|
|         |           .UMN.EDU>             |
|         |                                 |
|         |                                 |
|         |           06/05/2007 05:33 PM   |
|         |           Please respond to     |
|         |           Damien Corpataux      |
|---------+--------------------------------->
  >--------------------------------------------------------------------------------------------------------------------------------------------------|
  |                                                                                                                                                  |
  |        To:      MAPSERVER-USERS at LISTS.UMN.EDU                                                                                                    |
  |        cc:                                                                                                                                       |
  |        Subject: [UMN_MAPSERVER-USERS] Mapserver + oracle spatial                                                                                 |
  >--------------------------------------------------------------------------------------------------------------------------------------------------|



Hello list,

I have a problem with a mapserver oracle spatial laye: when dynamically
adding a oraclespatial layer with this kind of query:
GEOM FROM (
SELECT
    GEO.GEOM, A.*, ID as UNIQUEID
FROM
    MAILLES_CIEM GEO ,
    (
        SELECT
            C0.code_geom,
            C0.label_metric LT,
            C0.valeur VT
        FROM
            SIH_CARTE_SIG C0
        WHERE
            1 = 1
            and session_id = 'b5b89cbf8a613059c7c41b9796c66c44'
            and NUM_COUCHE = '466533b224b29'
            and C0.rang = 0
    ) A
WHERE
    1 = 1
    and A.code_geom = GEO.CODECIEM
    and trim(GEO.CODECIEM) is not null
ORDER BY
    GEO.CODECIEM) USING UNIQUE UNIQUEID NONE


any mapserver operation leads to mapserver crash. Has anyone faced this
situation?


Here is the output of gdb, when performing a $layer->whichShapes().

_gdb output_
#0  0xb7b7b2ac in free () from /lib/tls/libc.so.6
#1  0xb7b7ccff in malloc () from /lib/tls/libc.so.6
#2  0xb70101d1 in msOracleSpatialLayerWhichShapes ()
   from /usr/lib/php5/20060613+lfs/php_mapscript.so
#3  0xb70040e5 in msLayerWhichShapes ()
   from /usr/lib/php5/20060613+lfs/php_mapscript.so
#4  0xb6fc87cf in layerObj_whichShapes ()
   from /usr/lib/php5/20060613+lfs/php_mapscript.so
#5  0xb6fbb453 in php3_ms_lyr_whichShapes ()
   from /usr/lib/php5/20060613+lfs/php_mapscript.so
#6  0xb752972f in execute () from /usr/lib/apache2/modules/libphp5.so
#7  0xb7519128 in execute () from /usr/lib/apache2/modules/libphp5.so
#8  0xb7529111 in execute () from /usr/lib/apache2/modules/libphp5.so
#9  0xb7519128 in execute () from /usr/lib/apache2/modules/libphp5.so
#10 0xb7529111 in execute () from /usr/lib/apache2/modules/libphp5.so
#11 0xb7519128 in execute () from /usr/lib/apache2/modules/libphp5.so
#12 0xb7529111 in execute () from /usr/lib/apache2/modules/libphp5.so
#13 0xb7519128 in execute () from /usr/lib/apache2/modules/libphp5.so
#14 0xb7529111 in execute () from /usr/lib/apache2/modules/libphp5.so
#15 0xb7519128 in execute () from /usr/lib/apache2/modules/libphp5.so

apache.err (mapserver v4.8):
*** glibc detected *** corrupted double-linked list: 0x08f74d30 ***
[Fri Jun 01 16:34:24 2007] [notice] child pid 11105 exit signal Aborted (6)


apache.err (mapserver v4.10):
*** glibc detected *** malloc(): memory corruption: 0x08ebe720 ***
[Fri Jun 01 12:20:01 2007] [notice] child pid 1977 exit signal Aborted (6)




Best regards,
Damien Corpataux


--
                                                        
                                                        
                                                        
 Camptocamp SA                                          
 Damien Corpataux                                       
 PSE A                                                  
 CH-1015 Lausanne                                       
                                                        
 +41 21 619 10 22 (Direct)                              
 +41 21 619 10 10 (Centrale)                            
 +41 21 619 10 00 (Fax)                                 
                                                        
 P Please consider the environment                      
 Do you really need to print this email?