Local Transaction

Code Ape Tech Column

Jun 17, 2022 · Databases

Understanding Local Transactions in Sharding-JDBC and Their Limits for Distributed Transactions

This article explains why the @Transactional annotation in Sharding-JDBC can roll back across multiple databases in some scenarios, clarifies the cases it truly supports, details the internal rollback implementation, and outlines the situations where local transactions cannot guarantee distributed consistency.