Hello,

i have the following question concerning Hibernate. We would like to use Hibernate within our company-wide Enterprise Application.

We use DB2 on OS390 as our databasesystem. As I am not sure if everybody knows DB2 on OS390, I add a short info:

We have more than 200 clients (finance institutes) which all should use this application. The tables are equal for all our clients, but they have different DB-qualifiers. These DB-qualifiers look like the following:

Client001.personaldata
Client002.personaldata
...
...
Client200.personaldata

ClientXXX is the qualifier and personaldata the table. For each client there are 150 tables, so 30000 tables in total.

Now my question: Do I have to describe all tables with the corresponding qualifier in the XML-file? Or is it enough to only describe the tables and to add the qualifier during runtime (access)?

In my opinion it is not practible to describe 30000 tables because it would produce a lot of overhead.

I hope someone has an elegant solution to me.

Thanks very much
Martin

map you personaldata is you want and then set hibernate.default_schema to e.g. Client001 when needed.

And you will need a sessionfactory per Client