Hibernate version:2.1.7

Name and version of the database you are using:
IBM DB2

I am developing an application for a legacy system where a schema exists for each customer. As new customers are added, new schemas are created to hold their data. I would like to have one class and one mapping file for each unique table, not one for each table in each schema. So, if there is a person table, for instance, in each customer schema then I would like to have one person.hbm.xml mapping, and one Person class. Then, at runtime, I would like to dynamically associate classes with schemas.

It seems that once you've created a SessionFactory, a given class is bound to a given table (within a given schema.) So, I'm guessing that I would have to create a SessionFactory for each customer, and somehow on the configuration object I would need to associate the appropriate schema just prior to building the SessionFactory. But, I'm having a lot of trouble doing this. I tried calling createMappings, then updating the schema on the returned Mappings object, then building the SessionFactory, but no luck. Perhaps I was to do something else with that Mappings object?

If anybody can give me some advice on this I would be very grateful. Also, I saw in another similar post that Hibernate3 might have some functionality for this, but it did not mention what functionality, classes, configurations or whatnot were used, so if anybody could point me in the direction of a specific feature in Hibernate3 that mkes this easier, please do, although my preference for now would be to stick with Hibernate2.x until Hibernate3 is released.

Interesting, I don't think thats easily doable. We should have something like Configuration.setSchemaName(), please open a feature request in JIRA if nobody has an answer in the next days.

Oh, you can set Properties on a Configuration. That would work fine if you use a global hibernate.cfg.xml for the list of mappings.

That works, and I also found that I can loop through the classMappings collection, setting the schema on each, just prior to building the SessionFactory. Thanks!

I have a similar, but slightly more complicated issue with multiple schemas. Like sblaes, I too have a separate schema for each customer; for example, CUSTOMER_1, CUSTOMER_2...CUSTOMER_N. However, I also have a common schema which holds data common to all customers, such as lookup data.

From reading the above messages, it sounds like I can build a SessionFactory with a different schema for each customer schema. That's great. However, in some sessions I will need to access a customer schema and the commom schema at the same time. Furthermore, due to inheritance, the customer schemas and the common schema will have some of the same tables. For example, I have the following class hierarchy (this is greatly simplified for this discussion):

abstract class Person
class User extends Person
class CustomerContact extends Person

Person is mapped to COMMON_SCHEMA.PERSON and also CUSTOMER_X.PERSON (i.e. one PERSON table for each customer schema). User is mapped to COMMON_sCHEMA.USER using "joined-subclass" to Person (COMMON_SCHEMA.PERSON). CustomerContact is mapped to CUSTOMER_X.CUSTOMER_CONTACT using "joined-subclass" to Person (CUSTOMER_X.PERSON).

The problem is, User has a one-to-many association with Person. How can I load a CustomerContact instance that includes the associated User? Person would have to be SIMULTANEOUSLY mapped to two different tables in different schemas in the same session.

Suggestions?

Perhaps I should add that I am using Hibernate2.

I know this post is pretty old, have you found a solution?