Re: [Geoserver-users] OCI and Tomcat (Linux)

[Hans-Ulrich O. <han...@te...>]

Hi,

we had a similar problem and we solved it by setting the environment for 
Tomcat appropriate:

export ORACLE_HOME=/opt/oracle/product/10.1.0/Db_1
export 
CLASSPATH=$ORACLE_HOME/jdbc/lib/ojdbc14.jar:$ORACLE_HOME/jdbc/lib/orai18n.jar:$ORACLE_HOME/jdbc/lib
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

The last setting depends on system, we have a SuSe Linux. Sometimes it 
is LD_PATH or SH_LIB_PATH etc.

Cheers,

Uli.

Bart van den Eijnden wrote:

> Hi list,
>
> today I had to install Geoserver with OCI support on Tomcat 5 (Red Hat 
> Enterprise).
>
> I ran into one issue which I did solve but not very graciously. I am 
> hoping somebody here knows a better way to do it.
>
> When adding an OCI datastore, I would get a message that 
> libocijdbc10.so could not be found in the java.library.path (and 
> another one). The directory which contains that "so" does exist in the 
> LD_LIBRARY_PATH (does Tomcat pick that up?).
>
> I solved it by creating a symlink to the "so" in usr/lib (which was 
> already in java.library.path or the other one).
>
> Does anybody know how to solve this more graciously?
>
> Thanks in advance.
>
> Best regards,
> Bart
>