| I have a class Posting with an @Embedded: {{public class Posting { @Embedded private BankDetails bankDetails; } public class BankDetails { private String bankCode; private String bankName; } }} Now I want to list all Postings with a bankCode of 123 and a bankName of null. {{Query q = entityManager.createQuery("SELECT o from Posting o WHERE bankDetails=?");
q.setParameter(1, new BankDetails("123", null));}} However I don't get any results. Why? Here's the sql query Hibernate executes:
{{
select posting0_.bank_code as bank_cod6_42_, posting0_.bank_name as bank_nam7_42_
from posting posting0_
where (posting0_.bank_code, posting0_.bank_name)=('123', null)}} That obviously does not work because it compares null with =. Original question on SO:
http://stackoverflow.com/questions/38206913/hibernate-where-does-not-work-for-embedded-with-null-member |