There are two entities: Post and Comment. Post has collection of comments that are selected in subselect query: {{ @OneToMany(mappedBy = "post", fetch = FetchType.EAGER, cascade = CascadeType.MERGE) }} {{ @Fetch(value = FetchMode.SUBSELECT) }} {{ private List<Comment> comments;}} When Post entities are selected by CriteriaQuery with specific 'orderBy' expression that contains params (see fragment below), exception ' SQLException _SQLException : Parameter index out of range (1 > number of parameters, which is 0). _ ' is thrown. {{Order order = builder.desc(builder.coalesce(root.get("name"), "default_name")); }} {{ query.orderBy(order);}} ORMUnitTestCase: [ https://github.com/hibernate/hibernate-test-case-templates/pull/35 |https://github.com/hibernate/hibernate-test-case-templates/pull/35] |
|