Hi

I am working on a serverbased web-application where tables are created dynamically, sort of on a project-basis. When a new project is created in the application, a new table is created dynamically. Later on when the projects is finished, the table is dropped from the database.

I have started to use hibernate for this project but I dont know how to handle the mapping for these dynamic tables. Each dynamic table is more or less a copy of template table, and they map to the same Class.

Does anybody have any idea on how to map one class to a dynamic number of tables, all with a slightly different table name ?

Any idea would be welcome.

Regards
Erik

It is difficult and complex but it can be done. You need to get to the Configuration class and bind the Meta Data etc. You will need to create a new session factory to use the new mapping.

I have a very similar situation.

I don't mind digging for the proper configuration and recreating
a session factory, but I do not understand how a single class
can be mapped to several tables - possibly with different structure
in my case.

Can someone elaborate on David's response?

Thanks!

Martin

Manual building of the mapping DOM tree and passing it to the configure() method would be the way which will work most likely. That way you can generate your mappings completely dynamical.

Mapping one concrete class to different tables is not (yet) allowed. This is expected in the 2.2 version.

What you can do however (I think mschulz rather meant that) is to map one class differently for different SessionFactories. One class may however not be spread out over mutliple tables at the same time. (may be possible in 2.2. as emmanuel said)

What I am looking for is the equivalent thing to a
<dynamic-component>, but on the class-level.

The <dynamic-class> mapping is already implement in the v22branch.

Thanks Gavin,

I'll check that out.