java math BigInteger cannot be cast to java lang Long

Question

I ve got List lt Long gt  dynamics  And I want to get max result using Collections  This is my code   List lt Long gt  dynamics spyPathService getDynamics            Long max   Long Collections max dynamics   longValue       This is my getDynamics   public List lt Long gt  getDynamics              Session session   null           session   this sessionFactory getCurrentSession            Query query   session                  createSQLQuery  SELECT COUNT    FROM SpyPath WHERE DATE time  gt  DATE SUB CURDATE   INTERVAL 6 DAY  GROUP BY DATE time  ORDER BY time              List lt Long gt  result   query list            return result           Now I m getting java math BigInteger cannot be cast to java lang Long  What s wrong

User · Answer

You need to add an alias for the count to your query and then use the addScalar   method as the default for list   method in Hibernate seams to be BigInteger for numeric SQL types  Here is an example   List lt Long gt  sqlResult   session createSQLQuery  SELECT column AS num FROM table        addScalar  num   StandardBasicTypes LONG  list

User · Answer

Try to convert the BigInteger to a long like this  Long longNumber  bigIntegerNumber longValue

User · Answer

I m lacking context  but this is working just fine   List lt BigInteger gt  nums   new ArrayList lt BigInteger gt     Long max   Collections max nums  longValue       from BigInteger to Long

User · Answer

Better option is use SQLQuery addScalar than casting to Long or BigDecimal     Here is modified query that returns count column as Long     Query query   session               createSQLQuery  SELECT COUNT    as count                              FROM SpyPath                               WHERE DATE time  gt  DATE SUB CURDATE   INTERVAL 6 DAY                                GROUP BY DATE time                                ORDER BY time                  addScalar  count   LongType INSTANCE     Then   List lt Long gt  result   query list      No ClassCastException here     Related link     Hibernate javadocs Scalar queries Hibernate LONG  remember it has been deprecated since Hibernate version 3 6 X here is the deprecated document  so you have to use LongType INSTANCE My previous answer

User · Answer

It s a very old post  but if it benefits anyone  we can do something like this   Long max   BigInteger  Collections max dynamics   longValue

User · Answer

Your error might be in this line   List lt Long gt  result   query list      where query list   is returning a BigInteger List instead of Long list  Try to change it to    List lt BigInteger gt  result   query list

User · Answer

Are you sure dynamics is a List lt Long gt  and not List lt BigInteger gt     If dynamics is a List lt Long gt  you don t need to do a cast to  Long

User · Answer

Imagine d getId is a Long  then wrap like this   BigInteger l    BigInteger valueOf d getId

[java] java.math.BigInteger cannot be cast to java.lang.Long

Examples related to java

Examples related to hibernate

Examples related to collections

Examples related to long-integer

Examples related to biginteger