According to the doc an @Repository annotation is required to activate Exception Translation:
§2.1.1 "Beyond that it activates persistence exception translation for all beans annotated with...