The configuration option native_exception_handling_51_compliance seem to have been retired:
hibernate/hibernate-orm#3791
Yet the option still exists and is recommended in latests docs:
https://docs.jboss.org/hibernate/orm/current/userguide/html_single/Hibernate_User_Guide.html#:~:text=native_exception_handling_51_compliance
If your SessionFactory is built via Hibernate’s native bootstrapping, and you don’t want the Hibernate exceptions to be wrapped in the Jakarta Persistence PersistenceException, you need to set the hibernate.native_exception_handling_51_compliance configuration property to true. See the hibernate.native_exception_handling_51_compliance configuration property for more details.
Also the link in quoted information doesn't work any more.