[Mapserver-users] Oracle Spatial using OGR
Oliver Wesp
wesp@gdv.com
Wed, 17 Sep 2003 15:51:45 +0200
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@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@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,<br>
<br>
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.<br>
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<br>
<br>
msDrawMap(): Image handling error. Failed to draw layer named
'ORALAYER'.
<br>
msOGRFileOpen(): OGR error. ExecuteSQL(SELECT SHAPE,ITEM FROM LAYER)
failed.<br>
<br>
>From the command line (using the same user and environment that
ogrinfo is running fine with) it's<br>
<br>
user@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
<br>
OGR:
OGROpen(/opt/oracle/product/9.2.0.1.0/Apache/Apache/htdocs/baseviewer/data/test.shp)
suc
<br>
ceeded (e6598).
<br>
OGR: ~OGRDDataSource(e6598)
<br>
OGR: ~OGRDDataSource(e6598)
<br>
OGR: ~OGRDDataSource(71b4f8)
<br>
OGR: ~OGRDDataSource(e6598)
<br>
OGR: ~OGRDDataSource(71b4f8)
<br>
OGR: ~OGRDDataSource(68a5d0)
<br>
OGR: ~OGRDDataSource(68a5d0)
<br>
OGR: ~OGRDDataSource(e6598)
<br>
OGR: ~OGRDDataSource(71b4f8)
<br>
OGR: ~OGRDDataSource(71b4f8)
<br>
OGR: ~OGRDDataSource(6309b0)
<br>
OCI: Userid=user, Password=pass, Database=db9i<br>
OCI: Prepare(SELECT TABLE_NAME, COLUMN_NAME, SRID, OWNER FROM
ALL_SDO_GEOM_METADATA)
<br>
OCI: Prepare(SELECT WKTEXT FROM MDSYS.CS_SRS WHERE SRID = 82027)
<br>
OGR: OGROpen(OCI:user/pass@db9i) succeeded (71b4f8).
<br>
OGR: ~OGRDDataSource(71b4f8)
<br>
<br>
<br>
Unfortunately I'm not able to obtain any useful information out of this
output. Maybe somebdy else could shed any light on this. <br>
<br>
best regards<br>
Oliver<br>
<br>
<br>
<br>
</body>
</html>
--------------000308000103080608050006--
_______________________________________________
Mapserver-users mailing list
Mapserver-users@lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users