Hi, I was wondering if anyone can help me solve this problem:

This is my HQL:

SELECT COUNT(obj.id) FROM MyObject AS obj WHERE obj.otherObject.id like '%example%'

This is what gets generated from hibernate via debug statement:

select count(myobject0_.id) as col_0_0_ from MYOBJECT myobject0_ where myobject0_.id like '%example%'

It looks like hibernate disregarded the otherObject. The otherObject is an object attribute within MyObject class, which contains an id field.

Is this an error or am I mapping it wrong? I'm mapping otherObject with the JoinColumn attribute. Thanks.

Is the property 'otherObject' correctly initialised when you initialise MyObject object?
could you provide your mapping file and both classes please?

cheers
radek

Thanks for replying. I'm using JPA. Here's my mapping:
-----------------------------------------------------------------
@Entity
@Inheritance(strategy=InheritanceType.JOINED)
@DiscriminatorColumn(name="OBJ_TYPE")
public abstract class MyObject {

@Id
private long id;

@JoinColumn(nullable=false)
private OtherObject otherObject;

...
//getters and setters
...
}
---------------------------------------------------------------------
@Entity
public class OtherObject {

@Id
@Column(length=24)
private String id;

...
//getters and setters
...
}

Thanks again.

Don't know why the messages was re-posted for 5 times.

Don't know why the messages was re-posted for 5 times.

Don't know why the messages was re-posted for 5 times.