Il 14/12/2012 11:39, Jonathan Moules ha scritto:
Hi Christian,
Thanks for the detailed information. I'm more inclined to picking
between the OCI and the NG one's myself. I have the NG one set up and
working but the OCI one doesn't work.
I get this error in the console when I hit "save" for a new OCI Oracle
store:
109562 [btpool0-2] ERROR org.mortbay.log - Nested in
org.springframework.web.util.NestedServletException: Handler
processing failed; nested exception is java.lang.UnsatisfiedLinkError:
no ocijdbc10 in
java.library.path:
java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path
Hi,
it would seem you are missing ojdbc from oracle in your java library
path, or the binaries like libocijdbc11.so. I had the same issue with
other spring apps relying on oracle. It could be that ojdbc5/6 is
missing, or it can't find the oci layer because the libraries are not in
the directories the linker is parsing.
I would first check if the ojdb6.jar is in the tomcat/lib directory, if
not get it from oracle
http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html .
For oci to work you will need the oci libraries too, you can get the
instant client here if you haven't got it already:
http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
This provides the jars too, so you can skip the ojdbc donwload.
Now all the pieces should be there, to make them work together you have
to set ORACLE_HOME to the client path, like this:
ORACLE_HOME=/usr/lib/oracle/11.2/client64 in my case, set TNS_ADMIN if
you plan to use TNS configuration, and add the $ORACLE_HOME/lib dir to
the linker search path, either by LD_LIBRARY_PATH which works but is not
recommended, or via /etc/ld.so.conf.d/ method, then call ldconfig again.
If you are on windows setting ORACLE_HOME and adding the executables and
the libs to the PATH var should be enough.
In summary what you need are the jars and the oci (libocci,
libocijdbc1X.so) libs, when you have them it's just about having them
talk together.
Hope it helps, getting Oracle to work like you want it to is always
troublesome :)
Regards,
Paolo
On 13 December 2012 23:03, cmaul <christian.m...@dse.vic.gov.au
<mailto:christian.m...@dse.vic.gov.au>> wrote:
Jonathan,
OCI is the Oracle Call Interface is a native C interface to
interact with
Oracle databases. Haven't used it.
The other two are the JDBC connection pool implementations, which
can reside
on the application level (geoserver), which is the Oracle NG
connection pool
or on the container level (Tomcat), which is the JNDI connection pool.
I was going to write there is not much difference as geoserver
comes with
commons-dbcp-xx.jar and tomcat with tomcat-dbcp.jar and both are from
Apache, but this is not true as I discovered just now. They have a
completely different class structure. Using NG on my production
server and
JNDI on the test server I found very little difference in
performance or
stability.
One warning: It is either or. If you use JNDI your Oracle odbc.jar
must sit
in the Tomcat_home/lib, if you use NG it would be in the
geoserver/lib. The
jar in both lib directories causes confusion and connection errors.
NG is documented:
http://docs.geoserver.org/latest/en/user/data/database/oracle.html
where it says: The database schema to access tables from. Setting
this value
greatly increases the speed... yes, but then you can only publish
from this
schema.
JNDI and the necessary modifications in
TOMCAT_HOME/conf/context.xml are
here:
http://docs.geoserver.org/latest/en/user/tutorials/tomcat-jndi/tomcat-jndi.html#tomcat-jndi
Obviously when refreshing the pools in one case the app restart is
enough,
while you need to restart the container in the other case. And the
JNDI pool
can be used for other apps as well if they are running in the same
container.
Cheers
Christian
-----
____________________________
Dr Christian Maul
Project Manager
Information Services Branch
Department of Sustainability and Environment
Level13, Marland House, 570 Bourke Street
Melbourne 3000
PO Box 500, East Melbourne Vic 3002
Telephone: +61-3-8636 2325
Telefax: +61-3-8636 2813
--
View this message in context:
http://osgeo-org.1560.n6.nabble.com/Oracle-connections-tp5022806p5022874.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add
services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_____ _________________________ _________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
<mailto:Geoserver-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
This transmission is intended for the named addressee(s) only and may
contain sensitive or protectively marked material up to RESTRICTED and
should be handled accordingly. Unless you are the named addressee (or
authorised to receive it for the addressee) you may not copy or use
it, or disclose it to anyone else. If you have received this
transmission in error please notify the sender immediately. All email
traffic sent to or from us, including without limitation all GCSX
traffic, may be subject to recording and/or monitoring in accordance
with relevant legislation.
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Paolo Crosato
Software engineer/Custom Solutions
e-mail: paolo.cros...@targaubiest.com
Office phone: +3904221722825
UBIEST S.p.A.
........................................................................................
www.ubiest.com
Via E. Reginato, 85/H - 31100 Treviso- ITALY Tel [+39] 0422 210 194 - Fax [+39]
0422 210 270
........................................................................................
This message is for the designated recipient only and may contain privileged,
proprietary, or otherwise private information. If you have received it in
error, please notify the sender immediately and delete the original. Any other
use of the email by you is prohibited.
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users