MySQL 8 exposes a new error code for lock acquisition failures in case of NOWAIT: namely, 3572 which we can translate to CannotAcquireLockException. On a specific note, this happens to be inconsistent with MariaDB which exposes the already supported code 1205 in such a scenario, so from that perspective we're closing a gap in our support between the two database variants.

For some context:
https://falseisnotnull.wordpress.com/2018/04/23/mysql-vs-mariadb-wait-nowait-skip-locked/
https://hibernate.atlassian.net/browse/HHH-13698