[Mon Mar 15 16:48:28 2010].375000 CGI Request 1 on process 264 [Mon Mar 15 16:48:28 2010].375000 msOracleSpatialLayerOpen called with: GEOMETRIE FROM MY_LINE_TABLE using unique ID srid 82015 (Layer pointer 01F9D568) [Mon Mar 15 16:48:28 2010].485000 msOracleSpatialLayerOpen. Shared connection not available. Creating one. [Mon Mar 15 16:48:28 2010].485000 msConnPoolRegister(labels,MY_CONNECTION,022A2CA0) [Mon Mar 15 16:48:28 2010].500000 msOracleSpatialLayerFreeItemInfo was called. [Mon Mar 15 16:48:28 2010].500000 msOracleSpatialLayerGetItems was called. [Mon Mar 15 16:48:28 2010].500000 msOracleSpatialLayerInitItemInfo was called. [Mon Mar 15 16:48:28 2010].500000 msOracleSpatialLayerInitItemInfo was called. [Mon Mar 15 16:48:28 2010].500000 msOracleSpatialLayerWhichShapes was called. [Mon Mar 15 16:48:28 2010].500000 msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: SELECT ID, NAME, GEOMETRIE FROM MY_LINE_TABLE WHERE SDO_FILTER( GEOMETRIE, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 'TRUE' [Mon Mar 15 16:48:28 2010].500000 msOracleSpatialLayerWhichShapes. Bind values: srid:82015 minx:2434248.916000 miny:5406417.084000 maxx:2765508.084000 maxy:5670471.916000 [Mon Mar 15 16:48:28 2010].500000 msOracleSpatialLayerWhichShapes getting ordinate definition. [Mon Mar 15 16:48:28 2010].500000 msOracleSpatialLayerWhichShapes converting to OCIColl. [Mon Mar 15 16:48:28 2010].500000 msOracleSpatialLayerWhichShapes bind by name and object. [Mon Mar 15 16:48:28 2010].500000 msOracleSpatialLayerWhichShapes name and object now bound. [Mon Mar 15 16:48:28 2010].875000 msOracleSpatialLayerNextShape on layer 01F9D568, row_num: 0 [Mon Mar 15 16:48:28 2010].875000 msOracleSpatialLayerNextShape on layer 01F9D568, row_num: 1 [Mon Mar 15 16:48:28 2010].875000 msOracleSpatialLayerNextShape on layer 01F9D568, row_num: 2 [Mon Mar 15 16:48:28 2010].875000 msOracleSpatialLayerNextShape on layer 01F9D568, row_num: 3 [...and so on...] [Mon Mar 15 16:48:28 2010].985000 msOracleSpatialLayerNextShape on layer 01F9D568, row_num: 1024 [Mon Mar 15 16:48:29 2010].282000 msOracleSpatialLayerNextShape on layer 01F9D568, Fetched 1024 more rows (2048 total) [Mon Mar 15 16:48:29 2010].282000 msOracleSpatialLayerNextShape on layer 01F9D568, row_num: 1025 [...and so on...] [Mon Mar 15 16:48:29 2010].297000 msOracleSpatialLayerNextShape on layer 01F9D568, row_num: 1095 [Mon Mar 15 16:48:29 2010].297000 msOracleSpatialLayerNextShape on layer 01F9D568, row_num: 1096 [Mon Mar 15 16:48:29 2010].297000 msOracleSpatialLayerNextShape on layer 01F9D568, row_num: 1097 [Mon Mar 15 16:48:30 2010].407000 msConnPoolClose(): Closing connection .... even though ref_count=1. [Mon Mar 15 16:48:30 2010].407000 msConnPoolClose(): General error message. Closing connection MY_CONNECTION even though ref_count=1. [Mon Mar 15 16:48:30 2010].407000 msConnPoolClose(MY_CONNECTION,022A2CA0)