Local transactions applicable to several MySQL schemas?

[balteo]

Hello,

I am developping a Spring application and I am considering having several MySQL schemas used by the same Spring application.

Can I use local transactions considering the above requirement or does using several MySQL schemas entails global/distributed transactions?

If local transactions and multiple MySQL schemas is possible, can anyone please provide advice as to how to configure Spring to achieve this?

Thanks in advance for your replies,

Regards,

Julien.

[dr_pompeii]

Hello

I am developping a Spring application and I am considering having several MySQL schemas used by the same Spring application.

With the bold part I understand many Data Bases created within MySQL

Can I use local transactions considering the above requirement or does using several MySQL schemas entails global/distributed transactions?

If each schema should be within the same transaction you should use JtaTransactionManager