Hi Sion, Thank you. The document uses TransactionTypeHolder to modify transaction type in Java. Is it possible to set it in proxy yaml file?
Regards, Eric Poon On Mon, Sep 9, 2019 at 8:45 AM Sion Yang <[email protected]> wrote: > Hi, > > > There are three kinds of distributed transaction in ShardingSphere, local, > two phase commit and BASE. > Default is local transaction. > > > For local transaction, if the SQL execute failed before commit, all > sharding data node will be rollback. > If failed in commit, the other sharding data node will not be rollback. > > > Detail information can see the document > https://shardingsphere.apache.org/document/current/en/features/transaction/ > > > -- > > Yi Yang(Sion) > Apache ShardingSphere > > > > At 2019-09-09 06:31:23, "Eric" <[email protected]> wrote: > >Hi, > > > >If a shard fail on a transaction, would the transactions on the other > >shards rolled back together? > > > >Let say I have 100 payments being updated in one sql statement (e.g. > update > >payment set remark = 'xxx' where customer = 'yyy'), the records are > >distributed on several shards. A shard failed to update the records. Would > >other shards roll back the updates? > > > >Best Regards, > >Eric Poon >
