You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by blais <bl...@enel.ucalgary.ca> on 2004/02/18 18:59:41 UTC
no ojdbc14 in java.library.path, Help I'm stuck trying to write this
servlet!
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@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: no ojdbc14 in java.library.path, Help I'm stuck trying to write
this servlet!
Posted by Apu Shah <ap...@esaya.com>.
i did not have to add any database connections under the tomcat web
admin tool.
catalina.properties remains the same.
is there a stack trace with an exception in any logs? (ClassNotFound or
any other such exceptions)
could you also describe what symptoms you are seeing? does the app hang
or does it return an error or are you not seeing database updates....
apu
On Wed, 18 Feb 2004 13:46:21 -0500
blais <bl...@enel.ucalgary.ca> wrote:
> Thanks Apu,
>
> I am using the thin client and it's still not working. I've put
> ojdbc14 in common/lib and still nothing. Did you have to add a
> database connection under the tomcat web administration tool ? And if
> you did, did you include a path to your ojdbc.jar file?
>
> I'm also wondering if maybe the catalina.properties file should be
> changed or if it should stay the same.
>
> Kind Regards,
> Jeremie
>
> Apu Shah wrote:
>
> >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 <bl...@enel.ucalgary.ca> wrote:
> >
> >
> >
> >>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@jakarta.apache.org
> >>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> >>
> >>
> >>
> >>
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> >For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> >
> >
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: no ojdbc14 in java.library.path, Help I'm stuck trying to write
this servlet!
Posted by blais <bl...@enel.ucalgary.ca>.
Thanks Apu,
I am using the thin client and it's still not working. I've put ojdbc14
in common/lib and still nothing. Did you have to add a database
connection under the tomcat web administration tool ? And if you did,
did you include a path to your ojdbc.jar file?
I'm also wondering if maybe the catalina.properties file should be
changed or if it should stay the same.
Kind Regards,
Jeremie
Apu Shah wrote:
>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 <bl...@enel.ucalgary.ca> wrote:
>
>
>
>>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@jakarta.apache.org
>>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>>
>>
>>
>>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: no ojdbc14 in java.library.path, Help I'm stuck trying to write
this servlet!
Posted by Apu Shah <ap...@esaya.com>.
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 <bl...@enel.ucalgary.ca> wrote:
> 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@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: no ojdbc14 in java.library.path, Help I'm stuck trying to
write this servlet!
Posted by Harry Mantheakis <ha...@mantheakis.freeserve.co.uk>.
I had this problem, and got it work by having the ojdbc14.jar in the
'$CATALINA_HOME/common/lib' directory ONLY.
If I kept a copy of ojdbc14.jar in my application's 'WEB-INF/lib' directory,
the thing just did not work.
Strange. I cannot explain it!
Harry Mantheakis
London, UK
> 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
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org