Madhura Apte

Greenhorn
+ Follow
since Aug 27, 2012
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Madhura Apte

Hi Java Gurus,

Hi All,

I have recently migrated from Windows XP to Windows 7. Since then I have been struggling to get my tomcat up and running.
I am unable to connect to any DB through Tomcat. Although I am able to connect to all the DBs through sqlplus (command prompt) and TOAD.

I have the following version installed on my machine :

Tomcat : Version -: 5.0
My Eclipse : Version -: 5.1.1 GA
Eclipse : version -:3.0.1
Oracle : Version -: 10.2.0.1

I have googled this issue and tried a lot of solutions suggested online, but none of them worked for me. Some of them are :

1. Add a TNS_ADMIN environment variable.
2. Different configurations in sqlnet.ora.
3. Turning off firewall security ( just to check if the DB connection is being denied due to this)
4. Granting full permissions to my ‘C:\ORACLE\product\10.2.0.1\NETWORK’ directory.
5. Using Resource Type "javax.sql.DataSource” instead of ‘oracle.jdbc.pool.OracleConnectionCacheImpl’ in the localhost resources.xml.

I do not see any issues while starting tomcat . I have even verified through Tomcat administrator that all the datasources mentioned in my resources.xml are properly getting loaded in tomcat.

The error that I get while connecting to DB is :

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory, cause:
java.sql.SQLException: ORA-12154: TNS:could not resolve the connect identifier specified


Please help me out with a solution. I have been struggling with this error since quite some time now :(
11 years ago