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 - 15:09:52 CDT
