Multi-Tenant application - How to achieve Shared database separate schema implementation ?

Question

I have to make a web application multi-tenant enabled using Shared database separate schema approach. Application is built using Java/J2EE and Oracle10g.

I need to have one single appserver using a shared database with multiple schema, each schema per client.

What is the best implementation approach to achieve this? - What needs to be done at the middle tier(app-server) level? - Do I need to have multiple host headers each per client? - How can I connect to the correct schema dynamically based on the client who is accessing the application?

Any links or pointers would be helpful.

Answer 1

Hi,

Look at http://sourceforge.net/projects/jspirit/, it should be useful for you.

Regards