<br><br>---------- Forwarded message ----------<br><span class="gmail_quote">From: <b class="gmail_sendername">José Ramón López</b> <<a href="mailto:joseramonlopez@gmail.com">joseramonlopez@gmail.com</a>><br>Date: 23-nov-2006 17:26
<br>Subject: Re: [UMN_MAPSERVER-USERS] Fwd: Re: [UMN_MAPSERVER-USERS] Blank Image OracleSpatial<br>To: Fernando Simon <<a href="mailto:fsimon@univali.br">fsimon@univali.br</a>><br><br></span><br><font size="2"><br>This is the definition of the layer:
<br><br></font><font size="1"><font size="2">LAYER<br> NAME ferrocarriles<br> TYPE line<br> CONNECTIONTYPE oraclespatial<br> CONNECTION "sde/sde@SDE
"<br> DATA "SHAPE FROM RED_FERROCARRIL USING VERSION 9i"<br> DUMP TRUE<br> DEBUG ON<br> TRANSPARENCY 0<br> PROJECTION <br> "init=epsg:4326"<br> END
<br> CLASS <br> NAME 'Red Ferrocarriles' <br> COLOR 0 0 255 <br> END <br> METADATA <br> "wms_title" "Red Ferrocarriles"<br> "wms_abstract" "Red Ferrocarriles"
<br> "wms_keywordlist" "WMS Red Ferrocarriles"<br> "wms_srs" "EPSG:4326"<br> END</font><br><font size="2"><br>And this is the call to Mapserver<br><a href="http://localhost:81/cgi-bin/mapserver?SERVICE=WMS&VERSION=1.1.0&REQUEST=GetMap&Layers=ferrocarriles" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://localhost:81/cgi-bin/mapserver?SERVICE=WMS&VERSION=1.1.0&REQUEST=GetMap&Layers=ferrocarriles</a></font><br></font><br>If i execute this in SQL+<span class="q"><br><br>SQL> select SDO_AGGR_MBR(shape) from RED_FERROCARRIL;
<br><br></span>SDO_AGGR_MBR(SHAPE)(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_<br>--------------------------------------------------------------------------------<br>SDO_GEOMETRY(2003, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 3), SDO_ORDINATE_ARR
<br>AY(195210,089, 4075810,31, 533545,364, 4261747,98))<br><br>Thanks for all<br><br><br><div><span class="gmail_quote">2006/11/23, Fernando Simon <<a href="mailto:fsimon@univali.br" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
fsimon@univali.br</a>>:</span><div><span class="e" id="q_10f15a3bb4fdba21_3"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi,<br> Did you have define any projection in your mapfile?<br> It is not a SRID problem bacause when occur SRID problem the Oracle<br>error related appear.<br> How did you call the Mapserver to generate this error? How it's your
<br>map extent? Try to define the extent of your map with the extent (mbr)<br>of your layer, you can check it using this SQL:<br> select SDO_AGGR_MBR(shape) from RED_FERROCARRIL;<br> Best regards.<br><br>------------------------------------------------------------------------
<br>Fernando Simon<br>Mapserver and Oracle Spatial developer<br>G10 - Laboratorio de Computacao Aplicada - Brazil<br><a href="http://www.univali.br/g10" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://www.univali.br/g10</a> - UNIVALI/CTTMAR<br>------------------------------------------------------------------------
<br><br><br>José Ramón López wrote:<br>><br>> do you know how i could solve it?<br>><br>> Thxs<br>> ---------- Forwarded message ----------<br>> From: *José Ramón López* < <a href="mailto:joseramonlopez@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
joseramonlopez@gmail.com</a><br>> <mailto:<a href="mailto:joseramonlopez@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">joseramonlopez@gmail.com</a>>><br>> Date: 23-nov-2006 13:53
<br>> Subject: Re: Re: [UMN_MAPSERVER-USERS] Blank Image OracleSpatial
<br>> To: "<a href="mailto:umn-ms@hydrotec.de" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">umn-ms@hydrotec.de</a> <mailto:<a href="mailto:umn-ms@hydrotec.de" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
umn-ms@hydrotec.de</a>>" <<br>> <a href="mailto:umn-ms@hydrotec.de" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">umn-ms@hydrotec.de
</a> <mailto:<a href="mailto:umn-ms@hydrotec.de" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">umn-ms@hydrotec.de</a>>><br>> Cc: <a href="mailto:mapserver-users@lists.umn.edu" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
mapserver-users@lists.umn.edu</a> <mailto:<a href="mailto:mapserver-users@lists.umn.edu" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
mapserver-users@lists.umn.edu</a>><br>><br>> I think that I don`t have any value assigned to srid<br>><br>> SQL> select table_name,srid from user_sdo_geom_metadata where<br>> table_name='RED_FERROCARRIL';
<br>><br>> TABLE_NAME SRID<br>> -------------------------------- ----------<br>> RED_FERROCARRIL<br>><br>><br>><br>> 2006/11/23, <a href="mailto:umn-ms@hydrotec.de" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
umn-ms@hydrotec.de
</a> <mailto:<a href="mailto:umn-ms@hydrotec.de" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">umn-ms@hydrotec.de</a>><br>> <<a href="mailto:umn-ms@hydrotec.de" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
umn-ms@hydrotec.de</a> <mailto:<a href="mailto:umn-ms@hydrotec.de" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">umn-ms@hydrotec.de</a>>>:
<br>><br>><br>> What about the SRID? Is it set in Oracle-Metada?<br>> You may query it in SQL+ with<br>><br>> select table_name,srid from user_sdo_geom_metadata where<br>> table_name='RED_FERROCARRIL'
<br>> (or<br>> select "OWNER", table_name, srid from user_sdo_geom_metadata<br>> where table_name='RED_FERROCARRIL')<br>><br>> UMN MapServer Users List <<a href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
MAPSERVER-USERS@LISTS.UMN.EDU</a><br>> <mailto:<a href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">MAPSERVER-USERS@LISTS.UMN.EDU</a>>> schrieb am
23.11.2006<br>> 12:50:34:<br>><br>><br>> > if I execute that, it does not give back anything , and the
<br>> following message;<br>> ><br>> > SQL> SELECT rownum, SHAPE FROM RED_FERROCARRIL WHERE SDO_FILTER(<br>> SHAPE, MDSYS.SDO_GEOMETRY(2003,<br>> > L,NULL,MDSYS.SDO_ELEM_INFO_ARRAY
(1,1003,3),<br>> MDSYS.SDO_ORDINATE_ARRAY(-206.756757,-170,206.756757<br>> > ) ),'querytype=window') = 'TRUE;<br>> ><br>> > ninguna fila seleccionada<br>> > no selected row in english or something similar
<br>> ><br>> > I supposed that it was for that reason, but either like<br>> correcting it;<br>> ><br>> > what can i do?<br>><br>> > 2006/11/23, <a href="mailto:umn-ms@hydrotec.de" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
umn-ms@hydrotec.de</a> <mailto:<a href="mailto:umn-ms@hydrotec.de" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">umn-ms@hydrotec.de</a>> <<br>> <a href="mailto:umn-ms@hydrotec.de" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
umn-ms@hydrotec.de</a> <mailto:<a href="mailto:umn-ms@hydrotec.de" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">umn-ms@hydrotec.de
</a>>>:<br>> ><br>> > Hi<br>> ><br>> > * Does the logged SQL-Statement produce any output if you<br>> > execute it in SQL+?<br>> > * Did you specify an SRID in Spatial-Metadata? Than you have to
<br>> specify it<br>> > in the mapfile to.<br>> ><br>> > Benedikt<br>> ><br>> > UMN MapServer Users List <<a href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
MAPSERVER-USERS@LISTS.UMN.EDU
</a><br>> <mailto:<a href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">MAPSERVER-USERS@LISTS.UMN.EDU</a>>> schrieb am 23.11.2006<br>> 09:08:12:
<br>> ><br>> ><br>> > > Hi People!
<br>> > ><br>> > > I have installed MS4W for Windows, with maplab, chamaleon, php<br>> 4.4.2 ...<br>> > > I am with problems when I make a request on layer lodged in a<br>> oracle data base, because always shows a blank image.
<br>> > > Im using Oracle 9i and Spatial. The dlls are in dlls their<br>> corresponding directories. If I make a request on a layer lodged<br>> in a data file, this is is correctly.<br>> > >
<br>> > > Im using oraclespatial method , not by OCI.<br>> > ><br>> > > In error.log file it appears:<br>> > ><br>> > > [error] [client <a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
172.21.128.99</a> <<a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://172.21.128.99</a>>]<br>> msOracleSpatialLayerOpen called with: SHAPE FROM RED_FERROCARRIL
<br>> USING VERSION 9i\r<br>> > > [error] [client
<a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">172.21.128.99</a> <<a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://172.21.128.99</a>>]<br>> msOracleSpatialLayerOpen. Shared connection not available.<br>> Creating one.\r<br>> > > [error] [client
<a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">172.21.128.99</a> <<a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://172.21.128.99</a>>]<br>> msConnPoolRegister(ferrocarriles,sde/sde@SDE,01912370)\r<br>> > > [error] [client
<a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">172.21.128.99</a> <<a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://172.21.128.99</a>>]<br>> msOracleSpatialLayerFreeItemInfo was called.\r<br>> > > [error] [client <a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
172.21.128.99</a> <<a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://172.21.128.99</a>>]<br>> msOracleSpatialLayerWhichShapes was called.\r<br>> > > [[error] [client
<a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">172.21.128.99
</a> <<a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://172.21.128.99</a>>]<br>> msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the<br>
> data: SELECT rownum, SHAPE FROM RED_FERROCARRIL WHERE SDO_FILTER(
<br>> SHAPE, MDSYS.SDO_GEOMETRY (2003, NULL,<br>> NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-206.756757,-170,206.756757,170)<br>> ),'querytype=window') = 'TRUE'\r<br>> > > [error] [client
<a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">172.21.128.99</a> <<a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://172.21.128.99</a>>]<br>> msOracleSpatialLayerFreeItemInfo was called.\r<br>> > > [error] [client <a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
172.21.128.99</a> <<a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://172.21.128.99</a>>]<br>> msOracleSpatialLayerClose was called. Layer connection:
sde/sde@SDE\r<br>> > > [error] [client <a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
172.21.128.99</a> <<a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://172.21.128.99</a>>]<br>> msOracleSpatialLayerClose. Cleaning layerinfo handlers.\r
<br>> > > [error] [client <a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
172.21.128.99</a> <<a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://172.21.128.99</a>>]<br>> msOracleSpatialLayerClose. Cleaning Oracle handlers.\r
<br>> > > [error] [client <a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">172.21.128.99
</a> <<a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://172.21.128.99</a>>]<br>> msConnPoolRelease(ferrocarriles, sde/sde@SDE,01912370)\r<br>> > > [error] [client
<a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">172.21.128.99
</a> <<a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://172.21.128.99</a>>]<br>> msConnPoolClose(sde/sde@SDE,01912370)\r<br>> > > [error] [client
<a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">172.21.128.99</a> <<a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://172.21.128.99</a>>]<br>> msDrawMap(): Layer 2 (ferrocarriles), 0.218s\r<br>> > > [error] [client <a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
172.21.128.99</a> <<a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://172.21.128.99
</a>>]<br>> msOracleSpatialLayerClose was called. Layer connection: sde/sde@SDE\r<br>> > ><br>> > > Thxs<br>> > > --<br>> > > José Ramón López<br>> >
<br>> ><br>> ><br>> > --<br>> > José Ramón López<br>> > Tfno: 627 88 88 24<br>><br>><br>><br>><br>> --<br>> José Ramón López<br>> Tfno: 627 88 88 24<br>
><br>><br>> --<br>> José Ramón López<br>> Tfno: 627 88 88 24<br></blockquote></span></div></div><br><br clear="all"><br>-- <div><span class="e" id="q_10f15a3bb4fdba21_5"><br>José Ramón López<br>Tfno: 627 88 88 24
</span></div><br clear="all"><br>-- <br>José Ramón López<br>Tfno: 627 88 88 24