Select if the collection contains a particular object with Hibernate Criteria

Question

Select if the collection contains a particular object with Hibernate Criteria

Asked 9 years, 4 months ago

Viewed 437 times

2

I’m trying to make a query that would be something like the method contains of interface Collection java.

I have a class GrupoProdutos and want to select the groups if your Collection, calling for produtoCollection, contains a particular product from another product list passed as a parameter.

I tried it like this and it didn’t work:

session.createCriteria(Grupo.class)
    .createAlias("produtoCollection", "produto")
    .add(Restrictions.in("produto", listaProdutos)).list();

The product is a Collection item or an item attribute?

– Dener

2015/07/01 at 12:57
From what I understand, you want to know if product Ollection (is a Collection right?) contains any item from a list passed as parameter?

– Dener

2015/07/01 at 13:08
Hello Dener, that’s right, I want to know if productCollection contains any product from the listProducts that was passed as parameter.

– Resende

2015/07/01 at 13:16

2 answers

Browser other questions tagged java hibernate

You are not signed in. Login or sign up in order to post.

by Dener • **813** points · Answer 1 · 2015-07-01T13:21:32+00:00

2

@Resende try overwriting the "product" equals. Or you can use the primary key inside Restricions.in like this:

session.createCriteria(Grupo.class)
          .createAlias("produtoCollection", "produtos")
          .add(Restrictions.in("produtos.id", "lista"));

At @Brunocésar edited my question, probably a moderator. I tried to use your tip but it didn’t work gave the following error: Caused by: org.postgresql.util.Psqlexception

– Resende

2015/07/01 at 13:29
Mal, my fault. Tidying up here. What does the error say exactly? It could show the classes involved in the search?

– Dener

2015/07/01 at 13:30
I got a solution using a foreach, posted in a separate reply, I do not know if it is the best way, but at the moment met the need. Thank you for your willingness to help.

– Resende

2015/07/01 at 13:39

by Resende • **505** points · Answer 2 · 2015-07-01T13:37:51+00:00

I got a solution using a loop, I do not know if it is the best solution, but at the moment met the need:

     List<Produto> resultList = new arrayList<Produto>();

     Criteria criteria = session.createCriteria(Produto.class)
                    .createAlias("produtoCollection", "produto");
     Disjunction ou = Restrictions.disjunction();
     for(Produto p : listaProdutos){
      ou.add(Restrictions.eq("produto.id", p.getId()));
     }

     resultList = criteria.add(ou).list();

I hope you can help others with similar doubts.