I am attempting to debug an 'open transaction' issue. I've been using
'gstat -h' to track the gap between the oldest and next transactions.
Sure enough, the oldest transaction is stuck.

I would like to correlate the SQL statements that are being executed
with the transaction identifier output by 'gstat -h'. Is there a way
to retrieve the current/most recent transaction identifier? I would
then have the program log both the SQL statement and its transaction
identifier.

Firebird 1.5.3.4870 is being used. Complicating the matter, hibernate
and jaybird are also being used. But, answers in the abstract or very
concrete (such as direct SQL) would be appreciated. Thank you.