Hello,

I am using hibernate 3

I have a table which contains

id Integer
product_name Varchar(50)
category_id Integer
stock Integer
rate decimal

I need to get the product which has max(rate). I know I can use the
hibernatetemplate.find( query ) to get it. But I don't know how to design
a Java class for this purpose? I mean the getter and setter methods
for the max column.

Somebody help me please.

Thank you.

Sudheer Palaparambil

Hi

You don't want to add getter/setters for max column. only for

id Integer
product_name Varchar(50)
category_id Integer
stock Integer
rate decimal


you can get it several wats.

List list=session.createSQLQuery("select * from TableName where rate=(select max(rate) from TableName)").addEntity(ClassName.class).list();


Amila

(Don't forget to rate if helps)

from product where rate = (select max(rate) from product)

Hope this helps

anand raman