Hibernate version: 3.2
Name and version of the database you are using: Oracle 10g

As part of the internationalization, I need to replace all the String properties in my classes with multi-language values.

The plan is to replace what used to be a String field in my objects with a reference to the string table.

So if I had an object called Item, that had a "Description" column that contained a string value in English, I want to replace that with a stringID that is basically a pointer to my internationalized strings table, that will hold multiple language entries per string.

Let's say I run a hardware store and my Items table looked something like this:


I want to replace it with something like this



With a one-to-many mapping to my translated strings table, which would look like this



So far so good, this can be accomplished with a simple Set mapping or something of the sort.


THE PROBLEM is that I need the tanslated strings table to be referenced from multiple parent tables.
For example, let's say I also had a Category table, with a "Name" column that needs to be translated.
I would now want my string table to look like this:



And so on and so on for every type I have that has translatable data.
This is basically a one-to-many mapping from multiple parent tables to the same LocalizedString table, where the parent table changes based on the TYPE_ID column.

I want multiple tables to have one-to-many Set mappings to the same table. How can I configure this relationship with Hibernate?

Hi

I don't know exactly what you want.
But try this.
Keep a constant variable for "TYPE_ID" per different class file.

Say In Item class set TYPE_ID="Item"
in category class set TYPE_ID="Category"

Thanks, I've managed to figure this one out. It was pretty simple, actually.
I added the following mapping in my Item class:

/**
* @hibernate.set lazy="false" cascade="all-delete-orphan" where="entity_type='Item.description'"
* @hibernate.one-to-many class="com.blah.blah.MultiLangString"
* @hibernate.key column="entity_id"
*/
public Set<LocalizedString> getDescription() {
return description;
}

and the same thing in my Category class, the only difference being the where clause where="entity_type='Category.description'"

Hibernate automatically added a "entity_id" column to the stringtable (which MultiLangString is mapped to).