i have multiple webapps connecting to oracle within the same tomcat
instance.

removing ojdbc14.jar from all the webapps WEB-INF/lib and keeping only
one copy of ojdbc14.jar in common/lib works for me on tomcat 5.

if you are connecting via oci drivers, make sure that your
LD_LIBRARY_PATH points to your oracle home. i've added the following in
my catalina.sh startup file:

export ORACLE_BASE=/usr/local/oracle
export ORACLE_HOME=$ORACLE_BASE/product/9.2.0
export ORACLE_TERM=xterm
export NLS_LANG=AMERICAN;
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:$ORACLE_HOME/jdbc/lib
:/
lib:/usr/lib:/usr/local/lib

if you're using thin drivers, this should not be required.

apu

On Wed, 18 Feb 2004 12:59:41 -0500
blais <blais@(protected):

> Hey All.
>
> I've been trying to write a servlet that uses a jdbc driver to connect
>
> to a remote Oracle server. I've manage to compile my own standalone
> app to connect to the DB. I included the ojdbc14.jar in my classpath
> and everything seemed to work fine. I can't seem to get the same code
> to work in a servlet with tomcat 5, and I'm pretty sure it's because
> tomcat does not know where ojdbc14.jar is. I've put it in server/lib
> and /bin and common/lib, but to no avail. Using the web tool, I've
> added the ojdbc14.jar file with multiple paths and i've still got
> nothing. Any help would be appreciates.
>
> I'm running this on Linux with tomcat 5, Oracle 9i and apache 1.3.29.
>
> Regards,
> Jeremie
>
> --
> You live and learn. At any rate, you live.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
> For additional commands, e-mail: tomcat-user-help@(protected)
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)