Does createAlias chaining require that all domain objects down the chain have same id types

I have this in the code



org.hibernate.TypeMismatchException exception is thrown with the message Provided id of the wrong type. Expected: class java.lang.Long, got class java.lang.Integer when crit.list(); method is called.

When I commented out:



no exception is thrown.

When I have it thus



It worked, however with this:



The id types of the domains

Remittance - Long
Claim - Long
Episode - Integer
Referral - Integer
Patient - Integer
Person - Integer.

And on the database side, does the PK match the types of the FK?

Anyway, even if this is a bug, the legacy Criteria is deprecated so no further development will be done in this area. You need to switch to JPA Criteria API and see if the problem still replicates.

Thank you very much, I suppose the Pks match the FKs, I will confirm if it doesn't.