Left Join with IS NULL condition

[Udhay Kumar]

SELECT 

    p.id, p.name

FROM

    permission p

        LEFT JOIN

    role_permission rp 

    ON rp.permission_id = p.id and rp.role_id=1 where rp.permission_id is null;

What should I put in .where in QueryDSL?

query.from(permission)

                              .leftJoin(permission.roles, role)

                              .on(role.id.eq(roleId))

                              .where(XXX)

                              .list(permission);

[John Tims]

You should be able to use role.id.isNull();

- John

[Udhay Kumar]

role.id denotes ROLE.ID 

as in Role.java I got:

 @ManyToMany

  private Set<Permission> permissions = new HashSet<Permission>();

I need to check for ROLE_PERMISSION.PERMISSION_ID IS NULL

However ROLE_PERMISSION here is a join table and I need not create an entity for this table.