ClassCastException: org.hibernate.hql.internal.ast.tree.SqlNode cannot be cast to org.hibernate.hql.internal.ast.tree.PathNode

Question

I have service which connects to maria db in order to fetch data. I have the following method in my repository to fetch order data:

@Query("select new Order(o.orderNumber, coalesce(o.orderId, ''), coalesce(o.env, ''), coalesce(o.poNumber, ''), coalesce(o.qty, ''), coalesce(o.sku, ''), "
            + " coalesce(o.customerNumber, ''), coalesce(o.portfolio, ''), coalesce(o.custEmail, '')) "
            + "from Order o where o.portfolio=?1 order by o.orderNumber desc")
    public List<Order> findAllOrder(String portfolio);

When I try to start the service, it throws me following error:

ClassCastException: org.hibernate.hql.internal.ast.tree.SqlNode cannot be cast to org.hibernate.hql.internal.ast.tree.PathNode

Any ideas on how to fix this? Appreciate the help.

Entity:

@Entity
@Table(name = "orders")
public class Order {

    private Long orderNumber;
private String orderId;
private String env;
private String poNumber;
private String qty;
private String orderItem;
private String sku;
private String status;
private String portfolio;
private Long customerNumber;
private int requestId;
private int recordId;
private String custEmail;
 public Order(Long orderNumber, String orderId, String env, String poNumber, String qty, String sku,
            Long customerNumber, String portfolio, String custEmail) {
        this.orderNumber = orderNumber;
        this.orderId = orderId;
        this.env = env;
        this.poNumber = poNumber;
        this.qty = qty;
        this.sku = sku;
        this.customerNumber = customerNumber;
        this.portfolio = portfolio;
        this.custEmail = custEmail;
    }
}

Could you please show your Order entity.

SternK
– SternK

2020-04-06 08:13:20 +00:00
Commented Apr 6, 2020 at 8:13 — SternK
– SternK, Commented Apr 6, 2020 at 8:13
And what hibernate dialect do you use?

SternK
– SternK

2020-04-06 08:14:22 +00:00
Commented Apr 6, 2020 at 8:14 — SternK
– SternK, Commented Apr 6, 2020 at 8:14
added the entity

sk17261205
– sk17261205

2020-04-06 08:21:31 +00:00
Commented Apr 6, 2020 at 8:21 — sk17261205
– sk17261205, Commented Apr 6, 2020 at 8:21
org.hibernate.dialect.MySQL5InnoDBDialect

sk17261205
– sk17261205

2020-04-06 08:23:32 +00:00
Commented Apr 6, 2020 at 8:23 — sk17261205
– sk17261205, Commented Apr 6, 2020 at 8:23
One more question, what MySQL version do you use?

SternK
– SternK

2020-04-06 08:25:34 +00:00
Commented Apr 6, 2020 at 8:25 — SternK
– SternK, Commented Apr 6, 2020 at 8:25

Eklavya · Accepted Answer · 2020-10-11 07:41:15Z

2

Use full reference(with the package name) of your class in @Query.

Suppose your Order class is in your com.earth.project package then query will be

@Query("select new com.earth.project.Order(o.orderNumber, coalesce(o.orderId, ''), coalesce(o.env, ''), coalesce(o.poNumber, ''), coalesce(o.qty, ''), coalesce(o.sku, ''), "
            + " coalesce(o.customerNumber, ''), coalesce(o.portfolio, ''), coalesce(o.custEmail, '')) "
            + "from Order o where o.portfolio=?1 order by o.orderNumber desc")
    public List<Order> findAllOrder(String portfolio);

edited Oct 11, 2020 at 7:41

answered Apr 6, 2020 at 8:36

Eklavya

18.6k4 gold badges33 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ClassCastException: org.hibernate.hql.internal.ast.tree.SqlNode cannot be cast to org.hibernate.hql.internal.ast.tree.PathNode

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related