Include root cause when MySQLMaxValueIncrementer fails to commit #37389

Overview

When useNewConnection is true, MySQLMaxValueIncrementer commits the sequence update on a separate connection. If that commit (or the subsequent restoration of auto-commit) fails, a DataAccessResourceFailureException is thrown, but the original SQLException is discarded.

This makes it unnecessarily difficult to diagnose the actual cause of the failure.

We should therefore include the original SQLException as the cause of the DataAccessResourceFailureException.

Related Issues

• Fix connection leak in MySQLMaxValueIncrementer #37321
• Fix cached ID reuse after commit failure in MySQLMaxValueIncrementer #37322