 | Mailing List | | Home | | Forum Home | | JBoss - Java Application Server | | Tomcat - JSP/Servlet container | | Struts - A MVC web framework | | iText - An open source PDF Java Library | | JDOM - JDOM XML Parser | | JSP - A mailing list about Java Server Pages specification and reference | | J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition | | J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog | | Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology | |
Struts & Hibernate
|
|
|
| | | Tomcat Service and OCI | Tomcat Service and OCI 2007-12-01 - By Rumpa Giri
Back
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@(protected)> 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 (See http://cat-5.ora-code.com).5.25
> SET CATALINA_BASE=C:\tools\apache-tomcat-5 (See http://cat-5.ora-code.com).5.25
>
> @(protected) 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@(protected)
To unsubscribe, e-mail: users-unsubscribe@(protected)
For additional commands, e-mail: users-help@(protected)
-- ---- ---- ---- ---- ---- -----
Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how.
|
|
|
