Provide auto-configuration of persistence exception translation

Closes gh-1435