java.lang.Integer cannot be cast to java.math.BigInteger

Question

I am new in hibernate and Mssql. I am working on MySQL to Mssql integration.

I am facing this exception:

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

My code is:

long salesAlertsCount = ((BigInteger)HibernateUtil.getHibernateSession()
        .createSQLQuery("SELECT COUNT(a.id) FROM Activity as a,Lead as l WHERE a.what_id=l.id and l.deleted=0 and "
        + (currentUser.isAdmin() ? "a.tenant_id="+currentUser.getTenant_id():" (a.owner_id="+currentUser.getId()
        + " or a.createdBy_id="+currentUser.getId()+")")
        + " and "
        + (currentUser.isAdmin()?"l.tenant_id="+currentUser.getTenant_id():" (l.owner_id="+currentUser.getId()+")")
        + " and a.deleted=0 and a.action="
        + Constants.ACTIVITY_ACTION_SEND_SALES_ALERT
        + ""
        + " and a.viewed=0 AND a.created>='"
        + beginingOfMonth
        + "' ").uniqueResult()).longValue();

This is my code I am stuck here previously this code working in MySQL but now when I integrate in Mssql it shows that exception.

Thank you in advance

get rid of the cast.

Ray Tayek
– Ray Tayek

2018-12-06 06:08:43 +00:00
Commented Dec 6, 2018 at 6:08 — Ray Tayek
– Ray Tayek, Commented Dec 6, 2018 at 6:08
i already tried to cast long but it's not working

learner
– learner

2018-12-06 06:15:55 +00:00
Commented Dec 6, 2018 at 6:15 — learner
– learner, Commented Dec 6, 2018 at 6:15

Alain Cruz · Accepted Answer · 2018-12-06 07:01:48Z

Please, try using BigInteger.valueOf(), instead of (BigInteger).

long salesAlertsCount = BigInteger.valueOf(HibernateUtil.getHibernateSession().createSQLQuery("SELECT COUNT(a.id) FROM Activity as a,Lead as l WHERE a.what_id=l.id and l.deleted=0 and "+(currentUser.isAdmin()?"a.tenant_id="+currentUser.getTenant_id() +" (a.owner_id="+currentUser.getId() +" or a.createdBy_id="+currentUser.getId()+")")+" and "+(currentUser.isAdmin()?"l.tenant_id="+currentUser.getTenant_id():" (l.owner_id="+currentUser.getId()+")")+" and a.deleted=0 and a.action="+Constants.ACTIVITY_ACTION_SEND_SALES_ALERT+"" + " and a.viewed=0 AND a.created>='"+beginingOfMonth+"' ").uniqueResult()).longValue();

Also, you should change they way you are setting parameters in your HQL. This could represent a severe security risk, allowing users to inject malicious sql queries. Instead, you should use hql parameters like the one below.

Query query = HibernateUtil.getHibernateSession().createQuery("SELECT count(a.id) FROM Activity a, Lead l where a.what_id = l.id and a.owner_id = :owner_id"); \\ Add the rest of the code
query.setParameter("owner_id", currentUser.getId());

You can read more in the following link.

vivek g · Accepted Answer · 2018-12-06 06:14:38Z

-2

this is because the query is returning an integer and you are casting to BigInteger. the BigInteger cannot be cast to Integer because the main class for BigInteger is of type Number. if you could cast the output to Number and from Number you can cast to BigInteger.

answered Dec 6, 2018 at 6:14

vivek g

606 bronze badges

1 Comment

Henry Over a year ago

No, this would not work. A type cast of an object does not change its dynamic type. The Integer is still an Integer after the cast to Number and cannot be cast to a BigInteger.

Collectives™ on Stack Overflow

java.lang.Integer cannot be cast to java.math.BigInteger

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related