Error getting count of unique results in hibernate

Question

For defining criteria, I am using the below code piece

Conjunction c1 = Restrictions.conjunction();
c1.add(Restrictions.eq("owner", 123));
c1.add(Restrictions.eq("shared", 'N'));
c1.add(Restrictions.eq("cId", 20));

Conjunction c2 = Restrictions.conjunction();
c2.add(Restrictions.eq("shared", 'Y'));
c2.add(Restrictions.eq("cId", 20));

criteria.add(Restrictions.or(c1, c2));

Then, I want to fetch the unique results for this criteria.

CriteriaImpl criteriaImpl = (CriteriaImpl) criteria;
Projection originalProjection = criteriaImpl.getProjection();
ResultTransformer originalResultTransformer = criteriaImpl.getResultTransformer();
Object rowCount = criteria.setProjection(Projections.rowCount()).uniqueResult();

int rc = (Integer) rowCount;

However, the code fails at criteria.setProjection(Projections.rowCount()).uniqueResult() with an error printed on server logs like this below:

Info: forcing batcher resource cleanup on transaction completion; forgot to close ScrollableResults/Iterator?

And the exception that comes along is:

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

Any idea where I am going wrong?

Added to the question, please check. ClassCastException it is. — swateek
– swateek, Commented Mar 2, 2015 at 10:02

Predrag Maric · Accepted Answer · 2015-03-02 10:05:11Z

3

It's probably this

c1.add(Restrictions.eq("shared", 'N'));

Try with this, in both places where you use it (" instead of ')

c1.add(Restrictions.eq("shared", "N"));

answered Mar 2, 2015 at 10:05

Predrag Maric

24.5k5 gold badges57 silver badges72 bronze badges

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

2 Comments

Jan Over a year ago

To improve your answer you should mention why this change should be made and maybe in addition that the same counts for example ints and longs.

swateek Over a year ago

@Jan It was a character that I was passing to the restriction instead of a string. That was it! Thanks for asking clarification.

Collectives™ on Stack Overflow

Error getting count of unique results in hibernate

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related