I have the following table design:

table manufacturer (
id BIGINT,
sales DECIMAL(14,9),
deleted TINYINT
)
key: id

table manufacturer_locale (
id BIGINT,
manufacturer_id BIGINT,
language VARCHAR(5),
identifier VARCHAR(100),
description TEXT
)
keys: manufacturer_id, language

Should I create two separate objects for the main objects and its localized extension or is there some easy way to have one object containing both
(which means in fact the object has two keys: manufacturer_id, language).

Can someone provide a sample of how this mapping could be done most effectively?

Thx alot
Joe The Quick.

Hi, the same problem as described above for me.

Is there any "best practise" hibernate solution for this model?
Thanks!

Best regards
Frank

Edit to the last post:

there are several posts regarding this issue:

Multilanguage DB, with another SQL Concept
http://forum.hibernate.org/viewtopic.ph ... tilanguage

same question as me (last post)
http://forum.hibernate.org/viewtopic.ph ... tilanguage

But currently I cannot find a given Answer in this forum, a "hibernate best practise" for this case.

Best regards
Frank