Multiple Data Sources

[UserStephen]

Hi,

I am wondering if there is any document or sample program that talks about multiple data sources in details.

The data sources are MSSQL databases located at different locations. I am also interested in knowing the implement of the transaction for the distributed databases using JTA or other technologies supported by spring framework.

Thank.

[Rod Johnson]

If you want distributed transactions, I'd recommend you use a JTA implementation. Spring's JtaTransactionManager can seamlessly run over the top of it, preserving Spring's regular programmatic or declarative transaction management.