Zeos + id session

[xinyiman]

How can I get a unique identifier of the session is connected to a database (firebird) better if the solution is cross-platform.

This ZEOS with members!

[ludob]

Code: [Select]

select current_connection from rdb$database

[xinyiman]

Code: [Select]

select current_connection from rdb$database

Thank you. One question, this is a only solution to firebird?

[BigChimp]

If you mean: is this Firebird-specific, the answer is yes... but it should work on all platforms Firebird runs on (Linux, Windows, OSX...)

[xinyiman]

There is something cross-database?

[ludob]

There is something cross-database?

AFAIK, no.
MySQL has the CONNECTION_ID() which returns the process_id for the current connection. This is unique among existing connections. ID's will be re-used sooner or later.
Firebirds current_connection is a counter starting with when the server is start up and incremented by 1 for every session requesting current_connection (FB 1.5).
Oracle has sys_context('USERENV', 'SESSIONID') or userenv('SESSIONID').

It depends on what you want to do because there are other options:
- use database vars. Since vars are session specific you can set a var to a value of your choice when making the connection. At any time you can request the var back to identify your session. The syntax for database vars is not cross-database neither.
- use temporary tables and enter session specific info as the first record. The syntax is roughly the same on all DB's with the difference that oracle and firebird temporary tables are visible by all sessions (not the data, only the structure) while mssql and mysql temporary tables are visible only for the current session. This complicates creating temporary tables in a cross-db way a little bit.