tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rumpa Giri <gir...@yahoo.com>
Subject Re: Tomcat Service and OCI
Date Sun, 02 Dec 2007 03:27:08 GMT
Thanks a lot, speaking of OCI, is there any evidence that OCI will perform better than the
THIN driver? 
   
  We are being encouraged to use OCI on production environment since everybody says so, but
our development team isn't convinced of the same. We are using oracle 10g and based on their
documentation there isn't much difference between OCI and THIN, the 10g THIN driver now supports
what OCI used to have advantage over.
   
  Thanks again,
  Rumpa

Tim Funk <funkman@joedog.org> wrote:
  When run as a service - the PATH used by SYSTEM is not the same as when 
you are logged in. (So you need to add the dll's somewhere in your path 
as SYSTEM user - I can't recall how this is done but this is a very 
common problem google can help you with)

The type 4 jdbc driver from oracle has been very stable for the last 
(lot of) years. There really isn't much reason top use the OCI driver.

-Tim

Rumpa Giri wrote:
> Hello,
> 
> I am trying to run the tomcat as NT Service, but does not seem to work with OCI, if I
run the same tomcat instance not as a service but via startup.bat, the OCI JDBC driver works
fine.
> 
> Can anybody help me locate how to fix the service installation script to avoid the exception.
> 
> Local setup followed -
> 
> 1) I have installed tomcat 5.5.25.
> 2) Installed oracle client installation to use JDBC OCI Driver.
> a) Installed the oracle client installation at location - C:\oracle\product\10.2.0\client_1
> b) PATH is updated to reflect the above location for the dlls.
> c) copied the ojdbc14.ar to the %CATALINA_HOME%/commo/lib/ folder.
> 3) the context.xml has the OCI URL properly -
> > type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver"
> url="jdbc:oracle:oci:@//:1521/orcl"
> username="UN" password="PWD" maxActive="20" maxIdle="10"
> maxWait="-1"
> removeAbandoned="true"
> removeAbandonedTimeout="60"
> logAbandoned="true"
> />
> 
> If i run the %CATALINA_HOME%/bin/startup.bat - the application works fine and the JDBC
code excutes properly.
> 
> To install the tomcat as a service I ran the following script - 
> NOTE - We did specify the -Djava.library.path in the script.
> _____________________________________________________________________________
> SET CATALINA_HOME=C:\tools\apache-tomcat-5.5.25
> SET CATALINA_BASE=C:\tools\apache-tomcat-5.5.25
> 
> @echo off
> 
> echo CATALINA_HOME: %CATALINA_HOME%
> echo CATALINA_BASE: %CATALINA_BASE%
> echo JAVA_HOME: %JAVA_HOME%
> pause
> set BASEDIR=%CATALINA_HOME%
> call "%CATALINA_HOME%\bin\setclasspath.bat"
> 
> set args=%args% --Description=TOMCAT1
> set args=%args% --DisplayName=TOMCAT1
> 
> set args=%args% --Startup=auto
> 
> set args=%args% --LogPath=%CATALINA_BASE%\logs
> set args=%args% --LogLevel=DEBUG
> set args=%args% --StdError=%CATALINA_BASE%\logs\tomcat1_err.log
> set args=%args% --StdOutput=%CATALINA_BASE%\logs\tomcat1_out.log
> 
> set args=%args% --Classpath="%CLASSPATH%;%CATALINA_HOME%\bin\bootstrap.jar"
> 
> set args=%args% --JavaHome=%JAVA_HOME%
> set args=%args% --Jvm=%JAVA_HOME%\jre\bin\server\jvm.dll
> set args=%args% --JvmOptions="-Xms128m;-Xmx512m;-Djava.library.path=C:\oracle\product\10.2.0\client_1;-Dcatalina.base=%CATALINA_BASE%;-Dcatalina.home=%CATALINA_HOME%;-Djava.endorsed.dirs=%CATALINA_HOME%\common\endorsed"

> 
> set args=%args% --StartMode=jvm
> set args=%args% --StartClass=org.apache.catalina.startup.Bootstrap
> set args=%args% --StartParams=start
> rem set args=%args% --StartImage=%CATALINA_HOME%\bin\tomcat5.exe
> rem set args=%args% --StartPath=%CATALINA_HOME%\bin;
> 
> set args=%args% --StopMode=jvm
> set args=%args% --StopClass=org.apache.catalina.startup.Bootstrap
> set args=%args% --StopParams=stop
> rem set args=%args% --StopImage=%CATALINA_HOME%\bin\tomcat5.exe
> rem set args=%args% --StopPath=%CATALINA_HOME%\bin
> 
> %CATALINA_HOME%\bin\tomcat5.exe //IS//TomcatTest %args%
> set args=
> set BASEDIR=
> _____________________________________________________________________________
> 
> Now when we run the service and start the application - we get the following exception
-
> java.lang.UnsatisfiedLinkError: C:\oracle\product\10.2.0\client_1\ocijdbc10.dll: Can't
find dependent libraries



---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org



       
---------------------------------
Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how.
Mime
  • Unnamed multipart/alternative (inline, 8-Bit, 0 bytes)
View raw message