Hello everybody,

I need a hint, I have the following objects (made up to show the problem)

class Document {
Long id
Set importantKeywords
Set lessImportantKeywords
Set unimportantKeywords
Set funnyKeywords
// other information
}

class Keyword {
Long id
String keyword
// other information ..
}

I was planning to have database tables like this

create table document (
document_id int primary key,
-- other information
);

create table keyword (
keyword_id int primary key,
keywords text,
-- other information
);

create table document_keywords (
document_id int references document,
keyword_id int references keyword,

-- one of 'important', 'unimportant', 'funny' etc.
link_type string
);

I think I can make a where clause in my mapping to get the right keywords in the right collections of the document. I can't figure out though how to tell hibernate to insert the right link_type on storing of my documents.

Any help appreciated ...


Arne

May be a custom update sql.



Farzad-

Hello farzad,

Thanks for taking the time to read through my problem. I think in terms
of workaround solution I could just make one linkage table for every
category of keywords. I would prefer that to custom update sql.

I was hoping to get a solution which works analogous to the Address example in the hibernate reference manual



Its very close, but I'm not sure how to modify it for a many-to-many linkage table.

Arne

I don't think you can do much with that since formula works with primary keys and here the column in question is in a relation table that is not even mapped as an entity. What you could do is that you could define the relation table as an entity and then use formulas.

Farzad-