This week's book giveaway is in the OCAJP forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide 1Z0-808 and have Jeanne Boyarsky & Scott Selikoff on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Looking up tnsnames without parsing tnsnames.ora Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA Java SE 8 Programmer I Study Guide 1Z0-808 this week in the OCAJP forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Looking up tnsnames without parsing tnsnames.ora" Watch "Looking up tnsnames without parsing tnsnames.ora" New topic
Author

Looking up tnsnames without parsing tnsnames.ora

Andy Iyer
Greenhorn

Joined: May 27, 2009
Posts: 3
Is there a way where i can get a list of all my tnsnames looking up from the tnsnames.ora without actually parsing the file?
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3731
    
  10

In JDBC? No, since it's database specific. There may be some specific methods in the Oracle JDBC Driver available by casting the objects to Oracle-specific classes instead of the standard JDBC interface, but I doubt it.


[OCA 8 Book] [Blog]
 
Consider Paul's rocket mass heater.
 
subject: Looking up tnsnames without parsing tnsnames.ora