JPA question and i18n problem

[Julien Martin]

Hello,
I have the following two tables:

{code}

CREATE TABLE Sculpture
(
    sculpture_ID integer NOT NULL PRIMARY KEY,
    hauteur integer NOT NULL,
    largeur integer NOT NULL,
    annee year NOT NULL,
    prix double,
    nombreExemplaires integer NOT NULL,
    actif bool DEFAULT false NOT NULL
);

CREATE TABLE Sculpture_i18n
(
    sculpture_id integer NOT NULL ,
    locale char(2) NOT NULL ,
    titre varchar (50) NOT NULL,
    description varchar(255),
    FOREIGN KEY(sculpture_id) REFERENCES Sculpture (sculpture_ID)
);

{code}

I have generated the associated entity classes using netbeans.

in the Sculpture_i18n table, I have as many lines per sculpture as there are
locales in the app. Say I have two locales: French and English. I'll have
the following rows in the Sculpture_i18n:

1  "en"  "woman" "a woman's bust"
1  "fr"  "femme" "buste de femme"
2 "en" "dog" "a black dog"
2 "fr"  "chien" "un chien noir"
etc...

I want to be able to retrieve a sculpture together with  its localized
information using jpa.

As of now my DAO looks like that and does not handle i18n:

{code} public Sculpture findBySculptureID(Integer sculptureId) {
        return (Sculpture)
entityManager.createNamedQuery("Sculpture.findBySculptureID").setParameter("sculptureID",
sculptureId).getSingleResult();
    }
{code}

Does anyone have any sugggestion?

Julien.