Switching between databases Spring MongoDb

Question

I have a case, where I need to switch between the mongo databases using Spring mongodata (Version: 1.6.2). Currently, I have default database configured in db-config.xml with mongo template, and have annotated repositories; Need is to switch from one db/template to another at runtime; do necessary actions and switch back to default one. I referred to couple of links, Spring-data-mongodb connect to multiple databases in one Mongo instance and Making spring-data-mongodb multi-tenant I need to use same set of repositories at runtime. Is it possible to handle my case at configuration level? or do we need to extend Dbfactory to achieve this? with Dbfactory, can I use same set of annotated repositories?

Appreciate any help.

Amit Dalal · Accepted Answer · 2015-04-06 22:45:14Z

2

You can extend:

   1.  `SimpleMongoDbFactory`: returning custom DB in DB `getDb(String dbName)`.

    2. `MongoTemplate`: Supplying above factory.

Use appropriate MongoTemplate with the help of @Qualifier.

answered Apr 6, 2015 at 22:45

Amit Dalal

6528 silver badges20 bronze badges

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

2 Comments

devanathan Over a year ago

Amdalal, Can you please give us more information how to use the different mongo template for the same repository.

Amit Dalal Over a year ago

check this gist.github.com/amdalal/bc5e573762cc45a6da14a3fbc723d8c0

Zarathustra · Accepted Answer · 2015-04-07 06:10:15Z

1

I once had a very similar problem. I published the code on github, check it out multi-tenant-spring-mongodb

You basically have to extend SimpleMongoDbFactory and handle other hosts too. I just did handle multiple databases on the same server. That shouldn't be a problem.

edited Apr 7, 2015 at 6:10

answered Apr 6, 2015 at 19:44

Zarathustra

2,9634 gold badges36 silver badges63 bronze badges

3 Comments

Nani_M Over a year ago

Thanks for the reply. As per your code, I understand, we can set mongo template only once. I tried connecting to different dbs on same server, this is working fine. But, In my case, databases are in different server boxes. Is it possible to connect to a db on different server, dynamically?

devanathan Over a year ago

is this resolved? I was unable to update the database during runtime. context.getBean(SimpleMongoDbFactory.class).getDb("Test"); But it was not working, Thanks in advance.

Zarathustra Over a year ago

@devanathan could you open a github issue instead? stackoverlflow isn't a bug tracker ;)

Collectives™ on Stack Overflow

Switching between databases Spring MongoDb

2 Answers 2

2 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related