Multi-Tenant application - How to achieve Shared database separate schema implementation ?
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.
Multi-Tenant application - How to achieve Shared database separate schema implementation ?
===

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.