Ahojte,
mam takyto maly problemik s hibernate.
ma jednu tabulku clankov (article), ktora ma id. druhu tabulku
kategorii clankov (article_category), ma tiez id. a mam v triede
Article nasledovny zapis, teda pouzivam vazobnu-join tabulku
(category_article):
join tabulka category_article ma 2 stlpce - id do article a id do
article_category. jeden clanok moze byt vo viacerych kategoriach.
.....
@ManyToMany(cascade = CascadeType.ALL, fetch = FetchType.EAGER)
@JoinTable(name = "CATEGORY_article", joinColumns =
@JoinColumn(name = "ARTICLE")
, inverseJoinColumns = @JoinColumn(name = "CATEGORY")
)
@ForeignKey(name = "FK_CATEGORY_article_ARTICLE", inverseName =
"FK_CATEGORY_article_CATEGORY")
@NotNull
private Set<ArticleCategory> categories = new HashSet<ArticleCategory>();
potrebujem napisat cez HQL dotaz, ktory mi vrati vsetky clanky v
nejakej kategori.
dakujem
Ivan