I have a DB schema like this:
CREATE TABLE livraison ( /* delivery */
id INTEGER PRIMARY KEY NOT NULL DEFAULT nextval("livraison_id_livraison_seq"
/* others propertes */
)
CREATE TABLE article ( /* product */
id INTEGER PRIMARY KEY NOT NULL DEFAULT nextval("article_id_article_seq")
/* others properties */
)
CREATE TABLE article_livre ( /* association table */
id_article INTEGER NOT NULL REFERENCES article(id),
id_livraison INTEGER NOT NULL REFERENCES livraison(id),
rang INTEGER,
PRIMARY KEY (id_article, id_livraison)
)
The entities classes are like this:
@Entity
@Table(name="livraion")
class Livraison { /* ... */ }
@Entity
@Table(name="article")
class Article { /* ... */ }
@Entity
@Table(name="article_livre")
@AssociaitonOverride({
@AssociationOverride(name="id.article", joinColumns=@JoinColumn(name="id_article"),
@AssociationOverride(name="id.livraison", joinColumns=@JoinColumn(name="id_livraison")
})
class ArticleLivre {
/* ... */
@EmbeddedId
public ArticleLivrePK getId() { /* ... */ }
/* ... */
}
@Embeddable
class ArticleLivrePK {
/* ... */
@ManyToOne
public Article getArticle() { /* ... */ }
@ManyToOne
public Livraison getLivraison() { /* ... */ }
/* ... */
}
The same product can be delivered multiple times (it's rented) so it can be in multiple deliveries.
I'm trying to execute a query like this example (HQL) with the Hibernate query builder:
SELECT *
FROM Livraison
WHERE /* restrictions on the Livraison entity */
AND EXISTS (
SELECT id
FROM ArticleLivre
JOIN Article ON ArticleLivre.id.article = article.id
WHERE ArticleLivre.id.livraison = Livraison.id
/* AND restrictions on the Article entity */
)
I'm using Hibernate 4.3.10
with Java 10
and PostgreSQL 9.1.9
So far my code looks like this:
Criteria search = session.createCriteria(Livraison.class);
DetachedCriteria articlesLivres = DetachedCriteria.forClass(ArticleLivre.class);
livraisonRestrictions.forEach(search::add);
articlesLivres.add(Restrictions.eqProperty("ArticleLivre.id.livraison", "Livraison.id"));
DetachedCriteria articles = articlesLivres.createCriteria("id.article");
articlesRestrictions.forEach(articles::add);
search.add(Subqueries.exists(articlesLivres.setProjection(Projections.property("ArtileLivre.rang"))));
List livraison = search.list();
When I run this code I have this error: org.hibernate.QueryException: could not resolve property: ArtileLivre.rang of: core.ArticleLivre
.
I don't understand how to correct this error.