Implement the use_transactions option for IDO2DB

fixes #8007