[3.15] Backport Hibernate ORM fixes/workarounds around DB version checks to branch 3.15

[yrodiere]

Creating this to backport #43762, as requested by @gsmet because there were conflicts.

This is a backport of:

1. 43240

   This one is mostly being backported because otherwise, backporting the next one would result in conflicts. But I think it makes sense to backport this one too, considering it's only about providing better documentation, testing and error messages for a pre-existing feature.

2. 43762

   This is a workaround for #43703 and #42255, whose complete fixing would require Hibernate ORM 7.

[quarkus-bot[bot]]

Thanks for your pull request!

Your pull request does not follow our editorial rules. Could you have a look?

• title should not contain an issue number (use Fix #1234 in the description instead)

_{This message is automatically generated by a bot.}

[quarkus-bot[bot]]

/cc @gsmet (hibernate-orm)

[github-actions[bot]]

🙈 The PR is closed and the preview is expired.

[quarkus-bot[bot]]

Status for workflow Quarkus Documentation CI

This is the status report for running Quarkus Documentation CI on commit 8f9cd106fc2580f8f673bd7d10d825e9b6ebe2f0.

:white_check_mark: The latest workflow run for the pull request has completed successfully.

It should be safe to merge provided you have a look at the other checks in the summary.

[!WARNING] There are other workflow runs running, you probably need to wait for their status before merging.

[quarkus-bot[bot]]

Status for workflow Quarkus CI

This is the status report for running Quarkus CI on commit 8f9cd106fc2580f8f673bd7d10d825e9b6ebe2f0.

:white_check_mark: The latest workflow run for the pull request has completed successfully.

It should be safe to merge provided you have a look at the other checks in the summary.

You can consult the Develocity build scans.

---

Flaky tests - Develocity

:gear: JVM Tests - JDK 17 Windows

:package: extensions/smallrye-reactive-messaging/deployment

✖ io.quarkus.smallrye.reactivemessaging.hotreload.ConnectorChangeTest.testUpdatingConnector - History

• Expecting actual: ["-4","-5","-6","-7","-8","-9","-10","-11"] to start with: ["-3", "-4", "-5", "-6"] - java.lang.AssertionError

``` java.lang.AssertionError: Expecting actual: ["-4","-5","-6","-7","-8","-9","-10","-11"] to start with: ["-3", "-4", "-5", "-6"] at io.quarkus.smallrye.reactivemessaging.hotreload.ConnectorChangeTest.testUpdatingConnector(ConnectorChangeTest.java:36) ```