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
Session Id
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.
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.