Skip to content
ActiveRecord extension to retrieve current transaction ID
Find file
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Failed to load latest commit information.
lib v0.0.3 Oct 30, 2012
spec Spec for nested transactions and yield id to transaction block Oct 31, 2012


Adds ability to ActiveRecord to retrieve the current transaction ID. This can be used to as metadata for the purposes of grouping operations performed on many records across many tables. In particular I had its usage with auditing libraries in mind.

Currently supported adapters:

  • PostgreSQL
  • OracleEnhanced (untested, help!)
  • Mysql, Mysql2 (help! user needs PROCESS privileges and requires a query returning/modifying records before you can get an id!!!)

Adapters with no support for retreiving a transaction's ID:

  • Sqlite
  • Sqlite3

Please fork and add functionality for other databases.

NOTE: You can forget about the native transactions and use the sythentic transaction id. See the usage.


Add this line to your application's Gemfile:

gem 'xid'

And then execute:

$ bundle

Or install it yourself as:

$ gem install xid 


Simply call this to get the current ID:


Also, in a transaction block if you provide a block argument

Model.transaction do |transaction_id|
  puts transaction_id

To avoid issues or transaction support of your adapter you can just use a synthetic UUID as the transaction ID. In an initializer:


An UUID will be generated on request from the UUIDTools gem. This id is the same for the whole transaction, including any savepoints.


You must have the ActiveRecord test suite databases set up. The gem uses these to connect to for each adapter's specs.


  1. Fork it
  2. Create your feature branch (git checkout -b my-new-feature)
  3. Commit your changes (git commit -am 'Added some feature')
  4. Push to the branch (git push origin my-new-feature)
  5. Create new Pull Request
Something went wrong with that request. Please try again.