Blank Image OracleSpatial

José Ramón López joseramonlopez at GMAIL.COM
Thu Nov 23 03:08:12 EST 2006


Hi People!

I have installed MS4W for Windows, with maplab, chamaleon, php 4.4.2 ...
I am with problems when I make a request on layer lodged in a oracle data
base, because always shows a blank image.
Im using Oracle 9i and Spatial. The dlls are in dlls their corresponding
directories. If I make a request on a layer lodged in a data file, this is
is correctly.

Im using oraclespatial method , not by OCI.

In error.log file it appears:

[error] [client 172.21.128.99] msOracleSpatialLayerOpen called with: SHAPE
FROM RED_FERROCARRIL USING VERSION 9i\r
[error] [client 172.21.128.99] msOracleSpatialLayerOpen. Shared connection
not available. Creating one.\r
[error] [client 172.21.128.99] msConnPoolRegister(ferrocarriles,sde/sde at SDE
,01912370)\r
[error] [client 172.21.128.99] msOracleSpatialLayerFreeItemInfo was
called.\r
[error] [client 172.21.128.99] msOracleSpatialLayerWhichShapes was called.\r
[[error] [client 172.21.128.99] msOracleSpatialLayerWhichShapes. Using this
Sql to retrieve the data: SELECT rownum, SHAPE FROM RED_FERROCARRIL WHERE
SDO_FILTER( SHAPE, MDSYS.SDO_GEOMETRY(2003, NULL, NULL,
MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-206.756757
,-170,206.756757,170) ),'querytype=window') = 'TRUE'\r
[error] [client 172.21.128.99] msOracleSpatialLayerFreeItemInfo was
called.\r
[error] [client 172.21.128.99] msOracleSpatialLayerClose was called. Layer
connection: sde/sde at SDE\r
[error] [client 172.21.128.99] msOracleSpatialLayerClose. Cleaning layerinfo
handlers.\r
[error] [client 172.21.128.99] msOracleSpatialLayerClose. Cleaning Oracle
handlers.\r
[error] [client 172.21.128.99] msConnPoolRelease(ferrocarriles,sde/sde at SDE
,01912370)\r
[error] [client 172.21.128.99] msConnPoolClose(sde/sde at SDE,01912370)\r
[error] [client 172.21.128.99] msDrawMap(): Layer 2 (ferrocarriles),
0.218s\r
[error] [client 172.21.128.99] msOracleSpatialLayerClose was called. Layer
connection: sde/sde at SDE\r

Thxs
-- 
José Ramón López
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20061123/5c1a7228/attachment.html


More information about the mapserver-users mailing list