java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Long (Hibernate)

Asked May 08 '18 at 11:23

Active May 08 '18 at 11:34

Viewed 1,102 times

I am trying to run a subquery in hibernate like this:-

DetachedCriteria cartProductIds = DetachedCriteria.forClass(UserCart.class,"usercart")
                                        .add(Restrictions.eq("is_deleted", false))
                                        .add(Property.forName("usercart.user_id").eq(Property.forName("search.userId")))
                                        .add(Property.forName("usercart.product_id").eq(Property.forName("search.productId")))
                                        .setProjection(Projections.property("product_id"));

List<SearchHistory> history=session.createCriteria(SearchHistory.class,"search")
                                .add(Restrictions.between("creationTime", startTime, Timings.getCurrentTime()))
                                .add(Restrictions.eq("notification_send", false))
                                .add(Subqueries.notIn("productId", cartProductIds))
                                .list();

But there is a error on notIn subquery line which shows as :-

java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Long.

Need help to solve this issue.Thanks!

edited May 08 '18 at 11:34

Vikrant Kashyap

6,398
3
32
52

asked May 08 '18 at 11:23

Ayush Srivastava

what is in `cartProductIds` ? – May 08 '18 at 11:28
please add complete error stacktrace to identify the problem... Thanks :) – Vikrant Kashyap May 08 '18 at 11:35
I think your cartProductIds returning List but your productId column variable is Long type. So convert your List to List. – Ajay Garg May 08 '18 at 11:55
1

You can try `.add(Subqueries.propertyNotIn("productId", cartProductIds)` – Harshit May 08 '18 at 12:56
Thanks got it working now. – Ayush Srivastava May 10 '18 at 11:09

java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Long (Hibernate)

0 Answers0