Hello,

I am new to hibernate and I would like to use it in the following scenario:

My system currently has tables which have some fix columns.
E.g. the table t10 has columns t10surname, t10forename, ...

For some user groups, the tables also have extension fields
(t10text00, t10text01, ....)

The columns are accessed via "field ids". The problem is that extension
fields can have different mappings per user group.
E.g. field id 10005 can be mapped to t10text00 for user group A and
to t10text01 for user group B.


Can hybernate be used in such a scenario?


Thank You and kind regards,

Hans

P.S.:
I know, this kind of mapping is - erm... - suboptimal. But unfortunately I cannot
change the design.

I believe the schema allows for multiple session factory definitions that can be named in the configuration xml. You could include different mappings in different named session factories by user group.

I've never tried it, but it seems like it might work.