HHH-18371 JDBC connection acquisition failure can lead to query cache corruption

[reda-alaoui]

Fix https://hibernate.atlassian.net/browse/HHH-18371 .

---

By submitting this pull request, I confirm that my contribution is made under the terms of the Apache 2.0 license and can be relicensed under the terms of the LGPL v2.1 license in the future at the maintainers' discretion. For more information on licensing, please check here.

---

[hibernate-github-bot[bot]]

Thanks for your pull request!

This pull request appears to follow the contribution rules.

› This message was automatically generated.

[gavinking]

P.S. Apologies for taking so long to get to this; we have all been on vacation.

[reda-alaoui]

@gavinking , I can confirm the issue is fixed in version 6.6.0. I think the test case should be committed nonetheless to prevent any future regression.

[mbellade]

Thank you @reda-alaoui, I've rebased and cleaned up your test here https://github.com/hibernate/hibernate-orm/pull/9409

[reda-alaoui]

Thanks @mbladel :+1: