tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tim Funk <funk...@joedog.org>
Subject Re: Tomcat Service and OCI
Date Sun, 02 Dec 2007 00:54:03 GMT
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 -
>    <Resource name="jdbc/provider" auth="Container"
>   type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver"
>   url="jdbc:oracle:oci:@//<IP>: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


Mime
View raw message