Hi,

Does hibernate support for multiple database access and provide a global transaction service? And how?

Any suggestion is appreciated.

Thanks in advance.

Regards,
Gefei

Hi,

We have discussed this topic in several threads. Please find an answer for your question in the below thread.

http://forum.hibernate.org/viewtopic.ph ... highlight=

Thanks ramnath for the quick response. It helps in somehow. Those discussion does not tell how to realize a global transaction, ie, to encapsulate the accesses to two different DB in one transaction.

Could anyone give me some advice?

Thanks in advance.

Regards,
Gefei

Hibernate delegates to the configured Transaction manager. So if you have multiple databases, thus multiple session factories configured to XA aware JTA resources then XA transaction manager can operate over the configure databases/sessions.