Schema Isolation through Hibernate connection props ?

kryptontri · **Joined:** Tue Jul 13, 2004 11:51 am **Posts:** 13

Hi,

This is a question thats architecture / database related. What is the best way to use / configure hibernate to allow it to use a schema per user or in other words restrict a schema per user login. Basically I have a DB [tables = accounting, employees and reports], but I have 100 clients, but I don't want 100 separate database instances running, ie I need 1 db schema per client I have.

1) Could I create an MBean to reconfigure hibernate on the fly when the user logs into the system and connect using that users credentials to the database ... at the moment this seems like a bad idea.

2) ?

Any ideas anyone pls ?

Mathew

emmanuel · **Posted:** Mon Oct 04, 2004 4:54 am

You'll need a SF per client, which is a bad idea, I think