If you can run tomcat as a normal user, but not as a service, I can 99%
guarantee the problem is with permissions for the local SYSTEM account on
the server. The permission level for the local SYSTEM account isn't
allowing tomcat to read or access the files it needs to read or access.
Search the list archives, this subject came up about a month ago, the poster
had the exact same problem and resolved it.
John Turner
[EMAIL PROTECTED]
-Original Message-
From: Rao Manekar [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 11, 2002 12:24 PM
To: [EMAIL PROTECTED]
Subject: RE: JDBC OCI driver + Tomcat 4.04 ... problem solved
Good news. Good news. Problem solved.
For some reason when I run tomcat as a NT service, I am getting TNS:
protocol adaptor error. Just today I started tomcat as a stand alone
application, manually bingo! it worked. I went back and started tomcat
service as an administrator but still gave the same error. I stopped the
service and run the application as stand alone. This time I see no error. I
could query the database through my JSPs and JavaBeans.
I modified wrapper.properties file to contain correct entries. But still
gave me same problem.
I do have Oracle client on the workstation. I could able to log on through
SQL*Plus client. I was able to run a simple Java application from the
command prompt and get connected to the database but some how I was bailing
out when I execute the same code through JSP.
So, for right now I will run Tomcat as stand alone application and NOT as a
NT service.
Thank you for all your help.
Rao
Larry Meadors [EMAIL PROTECTED] 07/11/02 11:31AM
Yep, you need to have the client installed on the tomcat server. It
works the same on linux and Windows, and is a free download, so it is
not a BIG deal, just an extra step.
If you are running tomcat as a service, you also have to tell it where
to find the dll (on windows). Not sure about linux setup.
The thin driver is sure easier, but you just cannot argue with the
performance, I was SHOCKED.
Larry
[EMAIL PROTECTED] 07/11/02 09:10 AM
Do you have to install the oracle tnsclient software or something like
that to use OCI?
--
To unsubscribe, e-mail:
mailto:[EMAIL PROTECTED]
For additional commands, e-mail:
mailto:[EMAIL PROTECTED]
--
To unsubscribe, e-mail:
mailto:[EMAIL PROTECTED]
For additional commands, e-mail:
mailto:[EMAIL PROTECTED]
--
To unsubscribe, e-mail: mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]
