How to implement multi tenancy with separate database in struts and hibernate?

Question

We have an application wherein we want to keep separate database for each client. We want to achieve this using multi tenancy approach. A working example will be highly appreciated.

Comments

Oracle 12c should fit your needs. Unless you want to recreate this feature by your self.

Answer 1

If you want to recreate this feature yourself with different databases youre going to have to map your entrypoint (initial URL) to your specific client and from there to the specific database datasource. Once you have the data source, associate it with the SessionFactory and everything will work correctly from there.