Hi All,
I would like to ask you using Geoserver under UN*X with Oracle Spatial
database to send me the list and location of used Oracle libraries in
Geoserver directory tree and the related part of Geoserver config
file. OCI is preferred, but any other solution is interesting for me.
Thank you in advance.
Best regards: Balázs Bámer
Balázs Bámer ha scritto:
Hi All,
I would like to ask you using Geoserver under UN*X with Oracle Spatial
database to send me the list and location of used Oracle libraries in
Geoserver directory tree and the related part of Geoserver config
file. OCI is preferred, but any other solution is interesting for me.
The oracle datastore is not part of GeoServer, it's part of GeoTools.
There is no "config file" that I'm aware of, at least nothing specific
to Oracle.
To just use it, you get the Oracle extensions from the downloads,
follow the instructions, and add a new datastore to the geoserver
configuration. I know it works with the thin driver, which is the
preferred solution as it's pure java and in most cases faster
as well:
http://www.onjava.com/pub/a/onjava/excerpt/oraclejdbc_19/index.html?page=3
Cheers
Andrea
--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.
Hi All,
I respond to myself. Solution is
/usr/local/geoserver-1.7.2/webapps/geoserver/WEB-INF/lib# ln
/usr/local/instantclient_11_1/ojdbc6.jar .
/usr/local/geoserver-1.7.2/webapps/geoserver/WEB-INF/lib# ln
/usr/local/geoserver-1.7.2-oracle-plugin/gt-oracle-spatial-2.5.3.jar .
Problem was symlinks do not work under java. Linking these two
libraries provides both "Oracle" and "Oracle (OCI)" datasource, of
which Oracle is usable. Other one probably has wrong tnsnames.ora
settings, I will fix it later.
Best regards: Balázs