File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 Barcodes with iOS this week in the iOS forum
or Core Java for the Impatient in the Java 8 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: 3739
    
  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]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Looking up tnsnames without parsing tnsnames.ora