0

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.

Chocolord
  • 493
  • 3
  • 12
  • do you already read this? [thread so](https://stackoverflow.com/questions/21478178/org-hibernate-queryexception-could-not-resolve-property-filename) – dwir182 Oct 23 '18 at 09:25
  • I hadn't read this before but i knew for the case sensitivity of hibernate, it doesn't seems to be the problem here i think. – Chocolord Oct 23 '18 at 10:16

0 Answers0