Explicit Gradle try/catch rollback versus migration-tool recovery for schema changes
When a Gradle build runs a database schema migration via the sql plugin or an integrated tool, a failed statement may leave the database in an inconsistent state if the transaction does not fully roll back. The sql plugin's transactional=true flag attempts to wrap each statement in a JDBC transaction, but its reliability depends on the driver's behavior and