[Featureserver] Feature server reading from Oracle Spatial as an OGR datasource

[Sparks, Witt]

Since I didn't find a specific example on the web, I thought I'd share what I did to get this working.


My first problem was that although I had re-compiled OGR to support oracle, I also needed to re-generate the python libraries. I found instructions on that at: http://pypi.python.org/pypi/GDAL/
The next challenge was getting the proper entry in my featureserver.cfg file, which turned out to be:
[us_alt_fuel_stations_e85]
type=OGR
dsn=OCI:user/password at db_instance
layer=WEB_PROD.STATIONS

The trick for me was that although 'user' can see the tables in the web_prod schema in oracle, I had to explicitly specify schema.table.

I believe you'll also need your LD_LIBRARY_PATH set to include wherever your oracle client is installed, and the TNS_ADMIN variable pointing to the location of your tnsnames file so that it can figure out how to connect to db_instance.

______________________________________________________________________
Witt Sparks
National Renewable Energy Laboratory
Center for Transportation Technologies and Systems
witt_sparks at nrel.gov<mailto:witt_sparks at nrel.gov>
303-275-4494
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/featureserver/attachments/20090727/c1465da2/attachment.html