Hi!

Platform: DB2/400, Websphere Application Server

Scenario: Library for application schema, library for master schema, multiple libraries for detail schema
Libraries for detail have the same schema but data is different.

Configuration option: Single datasource connecting to all libraries; Objects retrieved with qualifier

One datasource connecting to one detail library. Objects retrieved without qualifier, but scalability issues based on how many Detail schemas are added.

Which is a better option? How do we qualify a Hibernate object with a qualifier at runtime? As the schema depends on the user option.

Thanks in anticipation
Mandira