Hi

I am trying to develop a webapp with multilanguage support, but I am having problems figuring out how I should map the following database tables structure to java-objects because there is data in the relation table (CategoryTranslation).

DataModel

Category
=======
id (PK)
parent_id (FK) (self reference)
type
sequence


Language
=======
id (PK)
language_code
language


CategoryTranslation
==================
category_id (FK)
language_id (FK)
categoryname_translation

Mapping this relation would be pretty straigt forward if it wasn't for the categoryname_translation column. Any ideas, tips or suggestions would be highly appriciated.


Hibernate version: 3
Name and version of the database you are using: MySql 5

...if you want composite PK...

@Entity
@IdClass(CategoryTranslationId.class)
public class CategoryTranslation

@Id
@Column(insertable=false, updatable=false)
private Long category_id;
@Id
@Column(insertable=false, updatable=false)
private Long translation_id;

@ManyToOne
@JoinColumn(name="category_id", insertable=false, updatable=false)
private Category category;

@ManyToOne
@JoinColumn(name="translation_id", insertable=false, updatable=false)
private Translation translation;

//...


you will need to implement idclass, but that's trivial

maybe it's smarter tho to add semantics-free PK

Thank you very much, it is pretty obvious now that I was stuck in the old JDBC way of thinking.... I do of course need a CategoryTranslation class. And adding a semantics free PK is no problem. Thank you for setting my thoughts straight ;)