Fwd: Re: [UMN_MAPSERVER-USERS] Blank Image OracleSpatial

[José Ramón López]

do you know how i could solve it?

Thxs
---------- Forwarded message ----------
From: José Ramón López <joseramonlopez at gmail.com>
Date: 23-nov-2006 13:53
Subject: Re: Re: [UMN_MAPSERVER-USERS] Blank Image OracleSpatial
To: "umn-ms at hydrotec.de" <umn-ms at hydrotec.de>
Cc: mapserver-users at lists.umn.edu

I think that I don`t have any value assigned to srid

SQL> select table_name,srid from user_sdo_geom_metadata where
table_name='RED_FERROCARRIL';

TABLE_NAME                             SRID
-------------------------------- ----------
RED_FERROCARRIL


2006/11/23, umn-ms at hydrotec.de <umn-ms at hydrotec.de>:
>
>
> What about the SRID? Is it set in Oracle-Metada?
> You may query it in SQL+ with
>
> select table_name,srid from user_sdo_geom_metadata where
> table_name='RED_FERROCARRIL'
> (or
>  select "OWNER", table_name, srid from user_sdo_geom_metadata where
> table_name='RED_FERROCARRIL')
>
> UMN MapServer Users List <MAPSERVER-USERS at LISTS.UMN.EDU> schrieb am
> 23.11.2006 12:50:34:
>
> > if I execute that, it does not give back anything , and the following
> message;
> >
> > SQL> SELECT rownum, SHAPE FROM RED_FERROCARRIL WHERE SDO_FILTER( SHAPE,
> MDSYS.SDO_GEOMETRY(2003,
> > L,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3), MDSYS.SDO_ORDINATE_ARRAY(-
> 206.756757,-170,206.756757
> > ) ),'querytype=window') = 'TRUE;
> >
> > ninguna fila seleccionada
> > no selected row in english or something similar
> >
> > I supposed that it was for that reason, but either like correcting it;
> >
> > what can i do?
>
> > 2006/11/23, umn-ms at hydrotec.de < umn-ms at hydrotec.de>:
> >
> > Hi
> >
> > * Does the logged SQL-Statement produce any output if you
> >   execute it in SQL+?
> > * Did you specify an SRID in Spatial-Metadata? Than you have to specify
> it
> >    in the mapfile to.
> >
> > Benedikt
> >
> > UMN MapServer Users List <MAPSERVER-USERS at LISTS.UMN.EDU> schrieb am
> 23.11.2006 09:08:12:
> >
> >
> > > 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
> >
> >
> >
> > --
> > José Ramón López
> > Tfno: 627 88 88 24
>



-- 
José Ramón López
Tfno: 627 88 88 24


-- 
José Ramón López
Tfno: 627 88 88 24
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20061123/85c5bffa/attachment.html