Ndtyjky

I have a Person entity within that entity I have a nested Set of entities for PersonNames. There is a OneToMany relationship between Person and PersonNames in that a person can have a multiple names.

    @XmlElementWrapper(name = "names")

    @XmlElement(name = "name")

    @OneToMany(mappedBy = "person", orphanRemoval = false, fetch = FetchType.EAGER)

    private Set<PersonNames> name;

You can see how the PersonNames set is defined above.

I need to create a JPA Criteria query for finding all Person entities that have a PersonNames object matching on firstName, middleName, or lastName.

public List<Person> getPerson(String lastName, String middleName, String firstName) {

    CriteriaBuilder builder = em.getCriteriaBuilder();

    CriteriaQuery<Person> criteria = builder.createQuery(Person.class);



    Root<Person> root = criteria.from(Person.class);

    criteria.select(root);



    if(!lastName.isEmpty() && lastName != null) {

        Predicate lastNameCondition = builder.equal( root.get(Person_.personId).get(PersonNames_.lastName), lastName);

        criteria.where(lastNameCondition);

    }



    TypedQuery<Person> query = em.createQuery(criteria);

    return query.getResultList();

}

Above is my attempt to accomplish said query, however I get the following error on the ".get(Person_.personId)" part of the Predicate line:

The method get(SingularAttribute) in the type Path is not applicable for the arguments (SingularAttribute)

The predicate line might be completely wrong, but I can't wrap my head on how to accomplish this, and nothing I google seems to turn up any results. Do I need to do an explicit join for this?

Edit: Removed Hibernate tag as I realized it's what our Wildfly server wants to use, but we are not using Hibernate in our code.

Re: "not using Hibernate API in our code" -- it is being deprecated.

CriteriaApi has a few detractors, but regardless, once you get the hang of things it can be approached pretty easily.

@Entity

public class Person {

    @Id @GeneratedValue(strategy=GenerationType.IDENTITY)

    private Long id;



    @OneToMany(mappedBy="person")

    private Set<PersonName> names;

and to populate it:

tx.begin();

Person p = new Person();

PersonName c1 = new PersonName(p, "F1", "M1", "L1"); 

PersonName c2 = new PersonName(p, "F2", "M2", "L2"); 

em.persist(p);

em.persist(c1);

em.persist(c2);

tx.commit();

and to query it

em.clear();

CriteriaBuilder cb = em.getCriteriaBuilder();

CriteriaQuery<Person> query = cb.createQuery(Person.class);

Root<Person> person = query.from(Person.class);

Join<Person, PersonName> names = person.join("names");

Predicate findNames = new Predicate[3]; 

findNames[0] = cb.equal(names.get("firstName"), "F1");

findNames[1] = cb.equal(names.get("middleName"), "M1");

findNames[2] = cb.equal(names.get("lastName"), "L1");

query.where(findNames);

List<Person> persons = em.createQuery(query).getResultList();

System.out.println(persons);

Will this work?

Criteria c = s.createCriteria(Person.class);

c.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);

c.createAlias("name", "name");

c.add(Restrictions.eq("name.lastName", lastName));

return c.list();