add generalized localTx method in DB and DBConnection

we want to rollback when the execution returns a Failure of Try in `localTx`
`NonFatal` seems to be unused.