disregard the transaction comment, this method is already being run by a TransactionManager, so no connection will be left with an open transaction.