Session factories to handle multiple DB connections

Question

I have a task to create multiple session factories for different Data Sources. One data source will be used for read requests and another for read-write requests.

Each API of our Database Service(a wrapper over DAO) is executed as a transaction. Single API may call multiple DAO functions having different Read/Write property.

What is the best possible way to perform this task?

I think this topic will give some help to you. stackoverflow.com/questions/2017949/… — donnior
– donnior, Commented Jan 4, 2012 at 7:07

Aravind A · Accepted Answer · 2012-01-04 06:53:07Z

1

I am assuming that the different datasources are different DBs . Else you could use the readOnly attribute with the @Transactional annotation to manage the read only transactions.

You could inject two separate session factories in the DAO layer to manage these transactions . Alternatively , you could use AbstractRoutingDataSource . See a write up on this here

answered Jan 4, 2012 at 6:53

Aravind A

9,7375 gold badges40 silver badges46 bronze badges

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

6 Comments

instanceOfObject Over a year ago

Yes, different datasources are different DBs.

Aravind A Over a year ago

Then you could inject different sessionfactories . If you have different transaction managers, then you could use @Transactional("TxManagerName") . You could wire this all up with AbstractRoutingDataSource . But is you you plan to work across different transactional datasource within the same method - i.e , if one DB rollback should affect the other , consider using XA datasource .

instanceOfObject Over a year ago

This is really helpful. Could you please tell me the pros and cons of connecting to multiple DBs from a single API? Apart from this, might be naive but what is the way to use global transaction (XA datasource) in Spring?

Aravind A Over a year ago

@tyro - Please upvote(click on the up arrow)/check the tick mark if you are happy with the answer

instanceOfObject Over a year ago

Vote Up requires 15 reputation :( Could you please answer the previous question?

|

Collectives™ on Stack Overflow

Session factories to handle multiple DB connections

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related