You should not use coalesce(:listParameter) nor :listParameter is null, they are unsupported and used to work only by chance in Hibernate 5. Since I recently replied to a very similar problem, please refer to my comment on this post for further information.
1 Like