Hi all,

I have a Customer which has a CustomerType (e.g. 1 - Platinum, 2 - Gold, 3 - Silver). I have a table which is stores the i18n texts per language for each CustomerType called CustomerTypeText. The Customer to CustomerType relation is many-to-one and the CustomerType to CustomerTypeText is of course one-to-many (many languages!)

The user logins in with his native language, e.g. german. On an instance of Customer I want to be able to read access the customerTypeText in the user language, with a sort of "general" session-wide filter on the user language.

I have roughly 120 type tables such as CustomerType with each having an attached text table.

Is there a way to elegantly solve this problem with hibernate? Please push me in the right direction.

Cheers
Carsten