Announcement Announcement Module
Collapse
No announcement yet.
Local transactions applicable to several MySQL schemas? Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Local transactions applicable to several MySQL schemas?

    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.

  • #2
    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

    Comment

    Working...
    X