[Mapserver-users] Oracle Spatial using OGR

Wed Sep 17 09:51:45 EDT 2003

This is a multi-part message in MIME format.
--------------000308000103080608050006
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Dear List,

Once again I'm facing some wired issues regaring oracle spatial layers 
using ogr. I need to read the layers through ogr cause the application 
needs support for queries.
I got everything up and running on my test box. Now I try so set things 
up on the production box. Everything compiles just fine.First of all I'm 
loading the layers to oracle using ogr2ogr. Works. Next step is to 
connect to the database with ogrinfo. Works. But as soon as I use 
mapserver to display a layer I get

msDrawMap(): Image handling error. Failed to draw layer named 'ORALAYER'.
msOGRFileOpen(): OGR error. ExecuteSQL(SELECT SHAPE,ITEM FROM LAYER) failed.

 >From the command line  (using the same user and environment that 
ogrinfo is running fine  with) it's

user at machine>mapserv 
"QUERY_STRING=map=/opt/oracle/product/9.2.0.1.0/Apache/Apache/htdocs/testapp/test.map&mode=map&layer=shapelayer&layer=ORALAYER" 
 > /var/local/tmp/test.jpg
OGR: 
OGROpen(/opt/oracle/product/9.2.0.1.0/Apache/Apache/htdocs/baseviewer/data/test.shp) 
suc
ceeded (e6598).
OGR: ~OGRDDataSource(e6598)
OGR: ~OGRDDataSource(e6598)
OGR: ~OGRDDataSource(71b4f8)
OGR: ~OGRDDataSource(e6598)
OGR: ~OGRDDataSource(71b4f8)
OGR: ~OGRDDataSource(68a5d0)
OGR: ~OGRDDataSource(68a5d0)
OGR: ~OGRDDataSource(e6598)
OGR: ~OGRDDataSource(71b4f8)
OGR: ~OGRDDataSource(71b4f8)
OGR: ~OGRDDataSource(6309b0)
OCI: Userid=user, Password=pass, Database=db9i
OCI: Prepare(SELECT TABLE_NAME, COLUMN_NAME, SRID, OWNER FROM 
ALL_SDO_GEOM_METADATA)
OCI: Prepare(SELECT WKTEXT FROM MDSYS.CS_SRS WHERE SRID = 82027)
OGR: OGROpen(OCI:user/pass at db9i) succeeded (71b4f8).
OGR: ~OGRDDataSource(71b4f8)

Unfortunately I'm not able to obtain any useful information out of this 
output.  Maybe somebdy else could shed any light on this.

best regards
Oliver

--------------000308000103080608050006
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
 <meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
 <title></title>
</head>
<body>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
Dear List, 
 
Once again I'm facing some wired issues regaring oracle spatial layers
using ogr. I need to read the layers through ogr cause the application
needs support for queries. 
I got everything up and running on my test box. Now I try so set
things up on the production box. Everything compiles just fine.First of
all I'm loading the layers to oracle using ogr2ogr. Works. Next
step is to connect to the database with ogrinfo. Works. But as soon as
I use mapserver to display a layer I get 
 
msDrawMap(): Image handling error. Failed to draw layer named
'ORALAYER'.
 
msOGRFileOpen(): OGR error. ExecuteSQL(SELECT SHAPE,ITEM FROM LAYER)
failed. 
 
&gt;From the command line&nbsp; (using the same user and environment that
ogrinfo is running fine&nbsp; with) it's 
 
user at machine&gt;mapserv
"QUERY_STRING=map=/opt/oracle/product/9.2.0.1.0/Apache/Apache/htdocs/testapp/test.map&amp;mode=map&amp;layer=shapelayer&amp;layer=ORALAYER"
&gt; /var/local/tmp/test.jpg
 
OGR:
OGROpen(/opt/oracle/product/9.2.0.1.0/Apache/Apache/htdocs/baseviewer/data/test.shp)
suc
 
ceeded (e6598).
 
OGR: ~OGRDDataSource(e6598)
 
OGR: ~OGRDDataSource(e6598)
 
OGR: ~OGRDDataSource(71b4f8)
 
OGR: ~OGRDDataSource(e6598)
 
OGR: ~OGRDDataSource(71b4f8)
 
OGR: ~OGRDDataSource(68a5d0)
 
OGR: ~OGRDDataSource(68a5d0)
 
OGR: ~OGRDDataSource(e6598)
 
OGR: ~OGRDDataSource(71b4f8)
 
OGR: ~OGRDDataSource(71b4f8)
 
OGR: ~OGRDDataSource(6309b0)
 
OCI: Userid=user, Password=pass, Database=db9i 
OCI: Prepare(SELECT TABLE_NAME, COLUMN_NAME, SRID, OWNER FROM
ALL_SDO_GEOM_METADATA)
 
OCI: Prepare(SELECT WKTEXT FROM MDSYS.CS_SRS WHERE SRID = 82027)
 
OGR: OGROpen(OCI:user/pass at db9i) succeeded (71b4f8).
 
OGR: ~OGRDDataSource(71b4f8)
 
 
 
Unfortunately I'm not able to obtain any useful information out of this
output.&nbsp; Maybe somebdy else could shed any light on this. 
 
best regards 
Oliver 
 
 
 
</body>
</html>

--------------000308000103080608050006--