Persist the next transaction id per connection