When following error message is shown, then it will get converted to the
correct Exception classs of NotNullConstraintViolationException:

  PDOException: SQLSTATE[HY000]: General error: 1364 Field '...' doesn't have a
  default value

it is best practice to implement retry logic for transactions that are aborted because of deadlocks or timeouts. this makes such method available inside the DBAL and also add detection for errors where retrying makes sense in the different database drivers