Unable to query entities using with ManyToOne relation

sysiz · **Joined:** Mon Jul 06, 2015 2:55 am **Posts:** 2

Hi all

I have been trying to query entities with @ManyToOne relation. I have similar classes as below:

Parent entity:

Code:

@Entity
public class Parent {
    ...
   @OneToMany (mappedBy = "parent",
            cascade = { CascadeType.PERSIST, CascadeType.MERGE },
            fetch = FetchType.EAGER
   )
   private Set<Child> childs = new HashSet<>();
    
   ...
}

and Child entity:

Code:

@Entity
public class Child {
   ...
   @ManyToOne 
   private Parent parent;
   
   ...
}
 

And used query:

Code:

public Child getChildByParentID(String parentid) {
        return entityManager.createQuery( "SELECT c FROM Child c WHERE c.parent.id  = :parentid", Child.class )
                .setParameter("parentid", parentid)                
                .getResultList().get(0);
    }

Query fails to:
java.lang.UnsupportedOperationException: Unrecognized property type: org.hibernate.type.ManyToOneType(package.Parent)

Other types of queries works fine, but querying via ManyToOne relation (c.parent.id) does not.

I'm using Hibernate OGM 4.2.final with Wildfly 9.0CR2.

sysiz · **Joined:** Mon Jul 06, 2015 2:55 am **Posts:** 2

Seems to be similar to:
https://forum.hibernate.org/viewtopic.php?f=31&t=1039494

emmanuel · **Posted:** Tue Jul 07, 2015 11:29 am

Yes that's similar. For that particular query we don't need actual join support so I've put it as a candidate for our next sprint work.