AW: [UMN_MAPSERVER-USERS] AW: [UMN_MAPSERVER-USERS] Error in drawquery with OracleSpatiall

Wed Apr 25 10:43:30 EDT 2007

Hi Fernando,

I found the mistakes. I´ve got a function to zoom in to all the selected
shapes.
I use my searchlayer to perform the query and then i open it to get the
extends of the selected shapes. But i didn´t close my searchlayer. 
You get this error when you perform another query on this layer before
you close it. 

Tanks for your help !!

mit freundlichen Grüßen

Dominik Gierse, Dipl. Ing. (FH)
Softwareentwicklung	
mailto:gierse at systemtechnik.net	
Tel./Fax: +49 291 9929-70 / 7691
-----------------------------------------------------------------------	
Sitz der Gesellschaft:
HST Hydro-Systemtechnik GmbH
Sophienweg 3
D-59872 Meschede, Germany	
Tel./Fax: +49 291 9929-0 / 7691
http://www.systemtechnik.net
-----------------------------------------------------------------------	
Geschäftsführer: Dipl.-Ing. Martin Frigger, Dipl.-Ing. Richard Ernst	
Registergericht: Amtsgericht Arnsberg - HRB 3396	
UST-IDNR.: DE 191 917 337	
Steuer-Nr.: 334 5706 0269

-----Ursprüngliche Nachricht-----
Von: Fernando Simon [mailto:fsimon at univali.br] 
Gesendet: Mittwoch, 25. April 2007 14:56
An: Dominik Gierse
Betreff: Re: [UMN_MAPSERVER-USERS] AW: [UMN_MAPSERVER-USERS] Error in
drawquery with OracleSpatiall

Hi Dominik,
    In the begin of this year another Oracle spatial user sent a message

with a relate fetch error.
    On error, in that case, was with the UNIQUE column defined. The 
length of the data stored was bigger than 10 digits and had some 
duplicated data. In your case, the EID column store unique values,
right?
    Another relate error can be with can be with the open() and close() 
fro the layer that you used. These functions are used to open and close 
some handlers for the used connection. You can find some info in the 
PHPMapscript reference.
    I will forward some messages (and the code) that I sent the user 
with the drawquery() problem. See below.

"....The first is with the drawQuery, this method perform a query in all
layers of the mapObj. This method need to be apply in the mapObj, just
draw an image when you use the query methods for the mapObj. When you
call with just the layer query's (how you how in your code) the return
will be a null imgObj...."

"....To perform the tests I use a PHP application (and the mapfile) that
I attached, in these you have some example of function to use the
getShape, and the query modes in a layerObj. In the code exist another
function that perform a query in the mapobj, to have a drawQuery you
need the QUERYMA defined in your Mapfile. You can use this application
to test your code, you can change it without problem (just reference the
source if you share it  :)  ). The functions that you need to check are
query_map and query_point, in both you can see all the modes that I
used, querybypoint, querybyshape, querybyattribute...."

"....In my  Mapfile I used  FILTER, but you can forget it without
problem, it is not a requirement. The drawQuery work correctly, but it
will generate and image as result, this image is controlled by the
QUERYMAP parameters defined in the Mapfile, the image that is generate
by the drawQuery is use as a reference from the selected objects, it is
very useful for templates in CGI mode but not common in Mapscript mode
of Mapsever.
    I don't believe that the drawQuery will help you, if you just want
to show in the map the selected objects you can use the same approach
that I used. How you see in my code I created a new layer object, this
layer is just valid for Mapscript, will not appear in the Mapfile, and
is valid until the end of the execution of the PHP script. So, I just
copy (clone) the objects that was found to this new layer...."

    Best regards from Brazil.

-------------------------------------------------
Fernando Simon
UMN Mapserver and Oracle Spatial developer
-------------------------------------------------

Dominik Gierse wrote:
> Hi Fernando,
>
> thanks for your reply.
> I use a query to get information about the objects selected and 
> highlight these objects.
>
>
> // resArr1 is an array with the ID´s selected
>
> foreach($resArr1 as $ID) {   
>     @$mysearchLayer->queryByAttributes("EID", "EID = " . $ID,
> MS_MULTIPLE);
> }
> $ANZ = $mysearchLayer->getNumResults();
> .
> .
> //Setting the map-extends
> .
> .
> $img = $gpoMap->drawQuery();     // this is the line with der Error
>
>
> And here´s the log. Ist very long, but i dont want to delete important

> information
>
> First call with zoom
>
> [Tue Apr 24 15:32:04 2007] [error] [client 127.0.0.1] 
> msOracleSpatialLayerOpen called with: GEOM FROM SDOUSER.TABLEITUNG 
> USING UNIQUE EID\r, referer: http://localhost/hst/map75.php [Tue Apr 
> 24 15:32:04 2007] [error] [client 127.0.0.1] msOracleSpatialLayerOpen.

> Shared connection not available. Creating one.\r, referer: 
> http://localhost/hst/map75.php [Tue Apr 24 15:32:04 2007] [error] 
> [client 127.0.0.1] 
> msConnPoolRegister(tableitung,sdouser/sdouser at GIERSEDB,023F3660)\r,
> referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:04 2007] [error] [client 127.0.0.1] 
> msOracleSpatialLayerFreeItemInfo was called.\r, referer: 
> http://localhost/hst/map75.php [Tue Apr 24 15:32:04 2007] [error] 
> [client 127.0.0.1] msOracleSpatialLayerInitItemInfo was called.\r, 
> referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:04 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerWhichShapes was called.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:04 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data:
> SELECT EID, SK, GEOM FROM SDOUSER.TABLEITUNG WHERE SDO_FILTER( GEOM,
> MDSYS.SDO_GEOMETRY(2003, NULL,
>
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(340895
> 3.56,5712292.86,3409605.88,5712782.1) ),'querytype=window') =
'TRUE'\r,
> referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:04 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerFreeItemInfo was called.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:04 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerClose was called. Layer connection:
> sdouser/sdouser at GIERSEDB\r, referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:04 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerClose. Cleaning layerinfo handlers.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:04 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerClose. Cleaning Oracle handlers.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:04 2007] [error] [client 127.0.0.1]
> msConnPoolRelease(tableitung,sdouser/sdouser at GIERSEDB,023F3660)\r,
> referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:04 2007] [error] [client 127.0.0.1]
> msConnPoolClose(sdouser/sdouser at GIERSEDB,023F3660)\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:04 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerClose was called. Layer connection:
> sdouser/sdouser at GIERSEDB\r, referer: http://localhost/hst/map75.php
>
> Second call with query
>
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1] 
> msOracleSpatialLayerOpen called with: GEOM FROM SDOUSER.TABLEITUNG 
> USING UNIQUE EID\r, referer: http://localhost/hst/map75.php [Tue Apr 
> 24 15:32:57 2007] [error] [client 127.0.0.1] msOracleSpatialLayerOpen.

> Shared connection not available. Creating one.\r, referer: 
> http://localhost/hst/map75.php [Tue Apr 24 15:32:57 2007] [error] 
> [client 127.0.0.1] 
> msConnPoolRegister(tableitung,sdouser/sdouser at GIERSEDB,021E8588)\r,
> referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1] 
> msOracleSpatialLayerFreeItemInfo was called.\r, referer: 
> http://localhost/hst/map75.php [Tue Apr 24 15:32:57 2007] [error] 
> [client 127.0.0.1] msOracleSpatialLayerInitItemInfo was called.\r, 
> referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerWhichShapes was called.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data:
> SELECT EID, SK, GEOM FROM SDOUSER.TABLEITUNG WHERE SDO_FILTER( GEOM,
> MDSYS.SDO_GEOMETRY(2003, NULL,
>
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(340930
> 8.86,5712666.1,3409328.86,5712686.1) ),'querytype=window') = 'TRUE'\r,
> referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerFreeItemInfo was called.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerClose was called. Layer connection:
> sdouser/sdouser at GIERSEDB\r, referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerClose. Cleaning layerinfo handlers.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerClose. Cleaning Oracle handlers.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msConnPoolRelease(tableitung,sdouser/sdouser at GIERSEDB,021E8588)\r,
> referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msConnPoolClose(sdouser/sdouser at GIERSEDB,021E8588)\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerOpen called with: GEOM FROM SDOUSER.TABLEITUNG
USING
> UNIQUE EID\r, referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerOpen. Shared connection not available. Creating
> one.\r, referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msConnPoolRegister(tableitung,sdouser/sdouser at GIERSEDB,02644528)\r,
> referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerFreeItemInfo was called.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerGetItems was called.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerInitItemInfo was called.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerGetShape was called. Using the record = 38752.\r,
> referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerGetShape. Sql: SELECT X_MANUEL, NAME, LAENGE, SK,
> EID, SCHACHTOBE, SCHACHTUNT, STRASSE, MATERIAL, PROFILART, PROFILBREI,
> PROFILHOEH, BAUJAHR, HYDRANG, KOSTENSTEL, X1, Y1, X2, Y2, OBEN, UNTEN,
> ENTWAESSER, SOHLEOBEN, SOHLEUNTEN, NETZ, GEOM FROM SDOUSER.TABLEITUNG
> WHERE EID = 38752\r, referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerFreeItemInfo was called.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerClose was called. Layer connection:
> sdouser/sdouser at GIERSEDB\r, referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerClose. Cleaning layerinfo handlers.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerClose. Cleaning Oracle handlers.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msConnPoolRelease(tableitung,sdouser/sdouser at GIERSEDB,02644528)\r,
> referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msConnPoolClose(sdouser/sdouser at GIERSEDB,02644528)\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerOpen called with: GEOM FROM SDOUSER.TABLEITUNG
USING
> UNIQUE EID\r, referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerOpen. Shared connection not available. Creating
> one.\r, referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msConnPoolRegister(tableitung,sdouser/sdouser at GIERSEDB,02621B50)\r,
> referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerFreeItemInfo was called.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerInitItemInfo was called.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerWhichShapes was called.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data:
> SELECT EID, SK, EID, GEOM FROM SDOUSER.TABLEITUNG WHERE EID = 38752
AND
> SDO_FILTER( GEOM, MDSYS.SDO_GEOMETRY(2003, NULL,
>
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(340466
> 2,5706718.13,3418395,5717017.88) ),'querytype=window') = 'TRUE'\r,
> referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerFreeItemInfo was called.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerClose was called. Layer connection:
> sdouser/sdouser at GIERSEDB\r, referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerClose. Cleaning layerinfo handlers.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerClose. Cleaning Oracle handlers.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msConnPoolRelease(tableitung,sdouser/sdouser at GIERSEDB,02621B50)\r,
> referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msConnPoolClose(sdouser/sdouser at GIERSEDB,02621B50)\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerOpen called with: GEOM FROM SDOUSER.TABLEITUNG
USING
> UNIQUE EID\r, referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerOpen. Shared connection not available. Creating
> one.\r, referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msConnPoolRegister(tableitung,sdouser/sdouser at GIERSEDB,026136F8)\r,
> referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerFreeItemInfo was called.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerGetItems was called.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerInitItemInfo was called.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerGetShape was called. Using the record = 38752.\r,
> referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerGetShape. Sql: SELECT X_MANUEL, NAME, LAENGE, SK,
> EID, SCHACHTOBE, SCHACHTUNT, STRASSE, MATERIAL, PROFILART, PROFILBREI,
> PROFILHOEH, BAUJAHR, HYDRANG, KOSTENSTEL, X1, Y1, X2, Y2, OBEN, UNTEN,
> ENTWAESSER, SOHLEOBEN, SOHLEUNTEN, NETZ, GEOM FROM SDOUSER.TABLEITUNG
> WHERE EID = 38752\r, referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerOpen called with: GEOM FROM SDOUSER.TABLEITUNG
USING
> UNIQUE EID\r, referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerFreeItemInfo was called.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerInitItemInfo was called.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerWhichShapes was called.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data:
> SELECT EID, SK, EID, GEOM FROM SDOUSER.TABLEITUNG WHERE EID = 38752
AND
> SDO_FILTER( GEOM, MDSYS.SDO_GEOMETRY(2003, NULL,
>
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(340466
> 2,5706718.13,3418395,5717017.88) ),'querytype=window') = 'TRUE'\r,
> referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerFreeItemInfo was called.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerClose was called. Layer connection:
> sdouser/sdouser at GIERSEDB\r, referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerClose. Cleaning layerinfo handlers.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerClose. Cleaning Oracle handlers.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msConnPoolRelease(tableitung,sdouser/sdouser at GIERSEDB,026136F8)\r,
> referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msConnPoolClose(sdouser/sdouser at GIERSEDB,026136F8)\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerOpen called with: GEOM FROM SDOUSER.TABLEITUNG
USING
> UNIQUE EID\r, referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerOpen. Shared connection not available. Creating
> one.\r, referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msConnPoolRegister(tableitung,sdouser/sdouser at GIERSEDB,026136F8)\r,
> referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerFreeItemInfo was called.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerGetItems was called.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerInitItemInfo was called.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerGetShape was called. Using the record = 38752.\r,
> referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerGetShape. Sql: SELECT X_MANUEL, NAME, LAENGE, SK,
> EID, SCHACHTOBE, SCHACHTUNT, STRASSE, MATERIAL, PROFILART, PROFILBREI,
> PROFILHOEH, BAUJAHR, HYDRANG, KOSTENSTEL, X1, Y1, X2, Y2, OBEN, UNTEN,
> ENTWAESSER, SOHLEOBEN, SOHLEUNTEN, NETZ, GEOM FROM SDOUSER.TABLEITUNG
> WHERE EID = 38752\r, referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerOpen called with: GEOM FROM SDOUSER.TABLEITUNG
USING
> UNIQUE EID\r, referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerFreeItemInfo was called.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerInitItemInfo was called.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerWhichShapes was called.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data:
> SELECT EID, SK, GEOM FROM SDOUSER.TABLEITUNG WHERE SDO_FILTER( GEOM,
> MDSYS.SDO_GEOMETRY(2003, NULL,
>
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(340895
> 3.56,5712292.86,3409605.88,5712782.1) ),'querytype=window') =
'TRUE'\r,
> referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerFreeItemInfo was called.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerClose was called. Layer connection:
> sdouser/sdouser at GIERSEDB\r, referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerClose. Cleaning layerinfo handlers.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerClose. Cleaning Oracle handlers.\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msConnPoolRelease(tableitung,sdouser/sdouser at GIERSEDB,026136F8)\r,
> referer: http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msConnPoolClose(sdouser/sdouser at GIERSEDB,026136F8)\r, referer:
> http://localhost/hst/map75.php
> [Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
> msOracleSpatialLayerClose was called. Layer connection:
> sdouser/sdouser at GIERSEDB\r, referer: http://localhost/hst/map75.php
>
> Best regards
>
> Dominik Gierse, Dipl. Ing. (FH)
> Softwareentwicklung	
> mailto:gierse at systemtechnik.net	
> Tel./Fax: +49 291 9929-70 / 7691
>
-----------------------------------------------------------------------	
> Sitz der Gesellschaft:
> HST Hydro-Systemtechnik GmbH
> Sophienweg 3
> D-59872 Meschede, Germany	
> Tel./Fax: +49 291 9929-0 / 7691
> http://www.systemtechnik.net
>
-----------------------------------------------------------------------	
> Geschäftsführer: Dipl.-Ing. Martin Frigger, Dipl.-Ing. Richard Ernst	
> Registergericht: Amtsgericht Arnsberg - HRB 3396	
> UST-IDNR.: DE 191 917 337	
> Steuer-Nr.: 334 5706 0269
>  
>
>   