[Mapserver-users] spatial database support/configuration

[Matthew Hatcher]

Pedro,

The message "OracleSpatial is not supported" appears when you attempt you
access an Oracle layer but the application has not been built with Oracle
enabled. You should check the messages you received when running 'configure'
and when building to check for errors (I presume you're on linux?).

You should either have an ORACLE_HOME env var set, or specify the path to
the oracle libraries on the --with statement, otherwise it won't find them.

Hope this helps,
Matt

-----Original Message-----
From: Pedro Salazar [mailto:pedro-b-salazar at ptinovacao.pt]
Sent: 27 February 2003 19:04
To: mapserver-users at lists.gis.umn.edu
Subject: [Mapserver-users] spatial database support/configuration


Greetings,

I'm interested in supply a layer information from a database (spatial?).
I have an oracle spatial data cartridge or/and an postgresql with
postgis.

I compiled mapserver with "--with-postgis" and "--with-oraclespatial".
But I try to test it with oracle, 

LAYER
NAME poi
TYPE POINT
   CONNECTIONTYPE oraclespatial
   CONNECTION "user/password at sid"
   STATUS DEFAULT
   DATA "SHAPE FROM (SELECT p.geom.sdo_point.x FROM p poi)"
END

but mapserver thrown an error:
"msOracleSpatialLayerOpen(): OracleSpatial error. OracleSpatial is not
supported"

I'm not saying even my layer configuration is right  - I doubt beginning
in the query data.., but I supposed it should support oracle, doesn't
it?

by the way, in mapserver host I only have a oracle client, but I really
have a spatial oracle database indeed! It's also ok if I use postgis and
postgresql, and I would be grateful if you spare me a example of
configuration in map (or through a perl script)!! :)

thanks,
Pedro Salazar

-- 
<id name="pedro salazar"> 
<email>pedro-b-salazar at ptinovacao.pt</email>
<pgp-key-id>0E129E31D803BC61</pgp-key-id>
</id>


**********************************************************************
The information contained in this email and any subsequent
 correspondence is private and is intended solely for the 
intended recipient(s). For those other than the intended
 recipient(s) any disclosure, copying, distribution, or any 
action taken or omitted to be taken in reliance on such 
information is prohibited and may be unlawful.
**********************************************************************