aspose file tools
The moose likes JDBC and Relational Databases and the fly likes How to retrieve Oracle SID from java web application 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 "How to retrieve Oracle SID from java web application" Watch "How to retrieve Oracle SID from java web application" New topic
Author

How to retrieve Oracle SID from java web application

Bahareh Nikfarjam
Greenhorn

Joined: Oct 23, 2009
Posts: 1
Hello everybody,

Does anybody know of a API that I can use to capture the name of the database that I am connected to? Here is the scenario, I login to my application, now on the first page I want to display the name of the database I am connected to. Let say this is the entry from my tns file:
DATABASENAME =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xxx.xx.xxx)(PORT = 1521))
)
(CONNECT_DATA =
(SID = DATABASENAME)
)
)
I want to display DATABASENAME in UI after I log in.

Thanks in advance!
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2531
    
  10

select name from v$database

I have also seen: select instance_name from v$instance;


OCUP UML fundamental and ITIL foundation
youtube channel
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to retrieve Oracle SID from java web application