java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long

Question

I want to return number of rows using native sql. But console says me java.math.BigInteger cannot be cast to java.lang.Long. What's wrong? This is my method:

public Long getNumRows(Integer id){

        Session session = null;

        session = this.sessionFactory.getCurrentSession();
        Query query = session
                .createSQLQuery("SELECT COUNT(*) FROM controllnews WHERE news_id="
                        + id + ";");
        List firstResult = query.list();

        return (Long) firstResult.get(0);


    }

Rohit Jain · Accepted Answer · 2013-08-13T20:27:23.267

12

Use BigInteger#longValue() method, instead of casting it to Long:

return firstResult.get(0).longValue();

Seems like firstResult.get(0) returns an Object. One option is to typecast to BigInteger:

return ((BigInteger)firstResult.get(0)).longValue();

But don't do this. Instead use the way provided by Nambari in comments. I'm no user of Hibernate, so I can't provide Hibernate specific solution.

edited Aug 13 '13 at 20:27

answered Aug 13 '13 at 20:20

Rohit Jain

209,639
45
409
525

2

(OR) use hibernate scalars http://docs.jboss.org/hibernate/orm/3.6/reference/en-US/html/querysql.html – kosa Aug 13 '13 at 20:21
@Nambari. Oh! I've not used Hibernate though. – Rohit Jain Aug 13 '13 at 20:24
The method longValue() is undefined for the type Object – John Smith Aug 13 '13 at 20:24
1

And your answer will not work because return type of firstResult.get(0) is Object. – kosa Aug 13 '13 at 20:25
@JohnSmith. Well, now one option to solve this is to typecast to `BigInteger` first. But the better way would be the one specified by Nambari. You should use it. – Rohit Jain Aug 13 '13 at 20:25
1

@JohnSmith. Although it works, please look into Hibernate Scalars. That's perhaps the ideal way here. – Rohit Jain Aug 13 '13 at 20:30
nice hack. Seems like EntityManager does NOT have same `scalar` feature as hibernate – oak Mar 04 '14 at 20:44

score 4 · Answer 2 · edited May 23 '17 at 12:10

I faced same problem, I used Hibernate Scalar queries as suggested in the comment of @Rohit Jain's answer. Thanks @nambari for comment.

Coming to the problem we have,

Query query = session
            .createSQLQuery("SELECT COUNT(*) FROM controllnews WHERE news_id="
                    + id + ";");

These will return a List of Object arrays (Object[]) with scalar values for each column in the controllnews table. Hibernate will use ResultSetMetadata to deduce the actual order and types of the returned scalar values.

To avoid the overhead of using ResultSetMetadata, or simply to be more explicit in what is returned, one can use addScalar():

Query query = session
            .createSQLQuery("SELECT COUNT(*) as count FROM controllnews WHERE news_id="
                    + id + ";").addScalar("count", LongType.INSTANCE);

This will return Object arrays, but now it will not use ResultSetMetadata but will instead explicitly get the count column as Long from the underlying resultset.

How the java.sql.Types returned from ResultSetMetaData is mapped to Hibernate types is controlled by the Dialect. If a specific type is not mapped, or does not result in the expected type, it is possible to customize it via calls to registerHibernateType in the Dialect.

You can use Query#setParameter method to avoid any mistakes in query as

Query query = session
           .createSQLQuery("SELECT COUNT(*) as count FROM controllnews WHERE news_id= :id")
           .addScalar("count", LongType.INSTANCE).setParameter("id",id);

One confusion when you refer Scalar queries docs 4.0, addScalar method has second parameter 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

Related link

Hibernate javadocs

score 4 · Answer 3 · answered Aug 14 '19 at 09:43

4

  String query ="select count(*) from tablename";       
  Number count = (Number) sessionFactory.getCurrentSession().createSQLQuery(query).uniqueResult();
  Long value = count.longValue();

I tried this it works well

answered Aug 14 '19 at 09:43

Ajinz

477
4
8

java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long

3 Answers3

Linked