ansaurus

Question

get max value record from table in hibernate

Answer 1

+2 A:

You could use a projection:

Criteria criteria = session
    .createCriteria(Person.class)
    .setProjection(Projections.max("age"));
Integer maxAge = (Integer)criteria.uniqueResult();

Darin Dimitrov 2010-09-18 22:02:20

Criteria criteria = getSession() .createCriteria(Borrower.class) .setProjection(Projections.max("brwrid")); Long maxBrwrid = (Long)criteria.uniqueResult();

Ganesamoorthy 2010-09-18 22:55:27

its working fine. but null value returns, if null returns set value is 1 else max+1, how to do it.

Ganesamoorthy 2010-09-18 22:56:42

`if (maxBrwrid == null) { maxBrwrid = 1; } else { maxBrwrid = maxBrwrid + 1; }`

Darin Dimitrov 2010-09-19 08:11:57

Answer 2

+3 A:

Use the max(...) aggregate function:

select max(cat.weight) from Cat cat

Reference

Hibernate Core Reference Guide
- 14.7. Aggregate functions

Pascal Thivent 2010-09-18 22:05:06

ansaurus

tags:

views:

answers:

get max value record from table in hibernate

Reference

related questions