Session Id

Session Id

Postby Alladin » Tue 16 Dec 2008 15:42

Hello there,

Is there any chance one can determine SessionId of established OracleConnection without querying database?

Reflection way is also welcome.


Thank you in advance
Alladin
 
Posts: 149
Joined: Mon 27 Nov 2006 16:18

Postby AndreyR » Wed 17 Dec 2008 10:07

Sorry, there is no way to obtain Session ID without querying the server.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby Alladin » Wed 17 Dec 2008 10:49

Any other Oracle physical connection identifier?

When one executes DML statement, you guys know, how to indicate to what session this statement belongs. So there is somewhere deep some handle or session id.

I'd like to extract that one.

Why? The ptoblem is really simple.

In a web service I get some read data request, I create oracleConnection (taken from pool), if it's a fresh created connection, I need to alter session to set Nls_sort to binary (because I'd like to sort my Guids columns properly, not as strings). If this connection is coming from pool, i dont need to alter seession.
Alladin
 
Posts: 149
Joined: Mon 27 Nov 2006 16:18

Postby AndreyR » Fri 19 Dec 2008 11:11

Sorry, but we do not plan to implement such an identifier in near future. Also, no other ADO.NET Provider for Oracle offers such functionality.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for Oracle