This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to get SID of Connection From Java.

 
Bennet Xavier
Ranch Hand
Posts: 162
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I need to get the SID of each connection which is created using java Program.

I saw Connection SID in toad, which is unique for each connection.(I am not talking with the SID value that specified in tnsentry).

I need to get that information from java program itself, is it possible. if yes, please help.

Problem:

I need to find which connection from the POOL is being used by the program to execute different SQL statement.

Thanks

Bennet Xavier X.
 
Jan Cumps
Bartender
Posts: 2577
11
C++ Linux Netbeans IDE
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Do these help (toad suggests you use Oracle)?
select instance_name from v$instance
select name from v$database
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic