Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle error in java web service on Tomcat

Re: Oracle error in java web service on Tomcat

From: <PatrickRThomas_at_hotmail.com>
Date: 22 Jun 2006 17:31:12 -0700
Message-ID: <1151022672.181690.88570@b68g2000cwa.googlegroups.com>


Nevermind, I figured it out. I think it's a bug in 9.2.0.1. It's not reading the TNSNames.ora correctly. I changed my configuration to point to the first database defined in TNSNames.ora and everything worked correctly.

PatrickRThomas_at_hotmail.com wrote:
> I have a web service application installed on Tomcat 4.1. When it
> attempts to connect to the database, I get the "TNS:could not resolve
> service name" error. The service name is fine because I can TNSPing it
> and connect through SQL*Plus. My test environment works too. My test
> environment is running Oracle 9.2.0.5, but my production environment is
> running 9.2.0.1. I was able to recreate the error by copying the
> <ORACLE_HOME>/lib/ folder from my production environment to my test
> environment, so that seems to be where the problem lies. I made sure
> that I was using version 9.2.0.1 of the ojdbc14.jar drivers, but that
> did not fix the problem. The problem is that I cannot upgrade the
> production environment to 9.2.0.5 because it might break the legacy
> application that is running there now. Is there a way that I can
> include the my newer <ORACLE_HOME>/lib/folder in my WAR file or is
> there a way that I can point my Oracle drivers to look for the needed
> support files in another folder? I need to do it in a way that
> hopefully won't break the old application. I hope that makes sense.
>
> Thanks.
Received on Thu Jun 22 2006 - 19:31:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US