Why Hibernate Criteria projection Return a Null Object?

Question

What i want is to send Mobile number to the database and fetch Customer object. i debug following code and saw null customer object returned. Any help?

 public Customer unSuccessfulLoginAttempts(String mobileNumber) { log.info("<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<| Unsuccessful Logging Attempts Repository Starting|>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> {}" ,mobileNumber ); Session session = entityManager.unwrap(Session.class); Criteria criteria = session.createCriteria(Customer.class,"c"); Criterion mobile = Restrictions.eq("c.phone1",mobileNumber); criteria.add(Restrictions.eq("u.phone1", mobileNumber)); return (Customer) criteria.list(); }

Alexander Petrov · Accepted Answer · 2019-02-15 18:16:26Z

1

From what I can see your alias is "c" but you are using "u". You need to have:

List customer = session.createCriteria(Customer.class) .add(Restrictions.eq("phone1", mobileNumber)) .list();

Also your variable mobile remains unused.

edited Feb 15, 2019 at 18:16

answered Feb 15, 2019 at 17:41

Alexander Petrov

9,5422 gold badges36 silver badges76 bronze badges

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

11 Comments

L.Anush Over a year ago

Omg .. this was a problem . please give me some minutes to correct and check

L.Anush Over a year ago

Mobile variable i added only to check when um in the debug mode

L.Anush Over a year ago

Sir here return value is a object or a list?

L.Anush Over a year ago

Still the return value is null

L.Anush Over a year ago

Any more suggetions pls?

|

Collectives™ on Stack Overflow

Why Hibernate Criteria projection Return a Null Object?

1 Answer 1

11 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Related