Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to get SID of Connection From Java.

 
Bennet Xavier
Ranch Hand
Posts: 162
  • 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: 2584
11
C++ Linux Netbeans IDE
  • 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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic