Page 1 of 1
Session Id
Posted: Tue 16 Dec 2008 15:42
by Alladin
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
Posted: Wed 17 Dec 2008 10:07
by AndreyR
Sorry, there is no way to obtain Session ID without querying the server.
Posted: Wed 17 Dec 2008 10:49
by Alladin
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.
Posted: Fri 19 Dec 2008 11:11
by AndreyR
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.