Spring multiple @Transactional datasources

Question

<bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
    <property name="entityManagerFactory" ref="data.emf" />
</bean>

<tx:annotation-driven transaction-manager="transactionManager" />


<bean id="transactionManager2" class="org.springframework.orm.jpa.JpaTransactionManager">
    <property name="entityManagerFactory" ref="data.emf" />
</bean>

<tx:annotation-driven transaction-manager="transactionManager2" />

In my service layer, can I use @Transactional(name="transactionManager2"); to identify which transaction manager I use if I have multiple transaction managers?

Why do you think you need two transaction managers?

duffymo
– duffymo

2009-12-25 15:55:38 +00:00
Commented Dec 25, 2009 at 15:55 — duffymo
– duffymo, Commented Dec 25, 2009 at 15:55

skaffman · Accepted Answer · 2009-12-25 20:09:55Z

26

You can specify which tx manager to use with @Transactional using the value attribute:

A qualifier value for the specified transaction.

May be used to determine the target transaction manager, matching the qualifier value (or the bean name) of a specific PlatformTransactionManager bean definition.

For example:

@Transactional("txManager1");

Alternatively, you can use the more explicit TransactionProxyFactoryBean, which gives you finer-grained control over what objects gets proxied by what tx managers. This still uses the annotations, but it doesn't auto-detect beans, it's configured explicitly on a bean-by-bean basis.

This normally isn't an issue, but it's not wise to have multiple transaction managers unless you have a very good reason to do so. If you find yourself needing two tx managers, it's usually better to see if you can make do with one. For example, if you have two data sources configured in your app server, you can incorporate both in a single JtaTransactionManager, rather than two seperate JpaTransactionManager or DataSourceTransactionmanagers.

edited Dec 25, 2009 at 20:09

answered Dec 25, 2009 at 16:44

skaffman

405k96 gold badges825 silver badges775 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

cometta Over a year ago

please comment on my post at stackoverflow.com/questions/1962509/…

tsunade21 Over a year ago

@skaffman, how can I associate two data sources to the same transactionmanager if I am using DataSourceTransactionManager?

tsunade21 Over a year ago

@skaffman, I am working with jdbc templates and org.apache.commons.dbcp.BasicDataSource, what should I do to have transactionManager for two datasources? Thanks again

skaffman Over a year ago

@tsunade21: You open up a new question.

anasanjaria Over a year ago

Spring JTA multiple resource transactions in Tomcat with Atomikos example

|

Zoran Regvart · Accepted Answer · 2009-12-25 18:52:43Z

2

More on the need for more than one transaction manager. You might be trying to do nested or separate transactions in sequence -- then you can use different propagation settings. You can achieve that with configuration using single transaction manager see Transaction propagation.

answered Dec 25, 2009 at 18:52

Zoran Regvart

4,70825 silver badges37 bronze badges

Collectives™ on Stack Overflow

Spring multiple @Transactional datasources

2 Answers 2

8 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related