It's not a secret anymore!*
The moose likes JDBC 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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
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
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3703
    
    5

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.


My Blog: Down Home Country Coding with Scott Selikoff
 
 
subject: Looking up tnsnames without parsing tnsnames.ora
 
Similar Threads
Connection to database Exception
Sql Loader and Runtime.exec()
Jsp databse connectivity problem
Changes in tnsnames and restart application server to refresh the new setting??
Dumb Question Re: tnsnames.ora