Hi,

I have the following situation: I'm using a table to store text values localized in various languages. This table is then referenced whenever a localized text value is needed in another table. For example, I have a "Category" object that needs a localized title and description:

public class Category
{
...
Map title;
Map description;
};

Each Map should contain the language code as a key and the localized text as value. I want Hibernate to generate and use the following table definitions:

CREATE TABLE localizedtext (
id BIGINT,
language VARCHAR(5),
text VARCHAR(255),
PRIMARY KEY (id, language)
)

CREATE TABLE categories (
...
title BIGINT, // tied to “id” in “localizedtext”
description BIGINT // tied to “id” in “localizedtext”
…
)

How do I set up my Hibernate mappings for “title” and “description”?

Many thanks,
Jen

The <dynamic-component> element allows a Map to be mapped as a component, where the property names refer to keys of the map.



Read chapter 5.1.12. : component, dynamic-component http://www.hibernate.org/hib_docs/refer ... -component

and chapter 7.5: Dynamic components http://www.hibernate.org/hib_docs/refer ... ts-dynamic

Let me know it this helps you solve your problem.
Vincent Giguère