hibernate where clause with projection

Question

There's a table name STUDENTS with column studentName and studentID

I want to run a query like

SELECT studentName 
FROM STUDENTS 
WHERE studentId ='1';

in hibernate criteria and want to save this result in some String variable

mdonovan2010 · Accepted Answer · 2011-05-25 03:56:09Z

5

Something like:

String result = (String)sess.createCriteria(Students.class)
    .add(Restrictions.eq("studentId",1))
    .setProjection(Property.forName('studentName'))
    .uniqueResult();

answered May 25, 2011 at 3:56

mdonovan2010

4231 gold badge4 silver badges8 bronze badges

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

3 Comments

junaidp Over a year ago

Thanks :) ,it works ,now this result is actually some date ,next i want to compare this date with some other date ,just check which date is greater like 2011-05-25 00:35:07 or 2011-07-25 00:35:08 in my previous SQL i was using (UNIX_TIMESTAMP(r.lastupdatedate) - UNIX_TIMESTAMP (e.lastlogindate))>=1 " , you have any idea what will i use nowi.e in hibernate criteria to compare two dates. thanks

mdonovan2010 Over a year ago

You can compare this date using the Restrictions api. Something like: Restrictions.gt(yourDate, resultFromAboveDate). If you want to use the query above as a sub query in a larger query that compares dates then I recommend reading the hibernate documentation on detached queries with the Criteria api: docs.jboss.org/hibernate/core/3.3/reference/en/html/…

Hola Soy Edu Feliz Navidad Over a year ago

createCriteria is deprecated.

Collectives™ on Stack Overflow

hibernate where clause with projection

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related