Hi All

this is the sql syntax:

select * from tbl_Money where col_Amount1+col_Amount2 = 100

how to achieve this in Hibernate on Persistence Object Level?
Please show me some sample code.

Thanks for you help in advance.

can you tell me what have you coded and where exactly you get a problem??

hi Priti,

I am now doing a search in a name list, first name, middle name and last name are stored in 3 separate columns of the same table, but the keywords user entered for search is the combination of those 3, for example, if use enter "harry potter" as keywords, what i want to do is to merge first name, middle name and last name together, in A+" "+B+" "+C manner, then I check wether this combination "like" %keywords%. This is easy to do if I use HQL, but to make the program structure consistent, I want to do the checking on persistence object level, use Hibernate Creteria/Restrictions.

my user persistent class is:

public class UserInfo{
private String userID;
private String firstName;
private String middleName;
Private String lastName;

public UserInfo(){
}

//getters and setters
}

I guess there will be a way to do it on the object level, but I just dun know what method I shall use.Do you have any idea? any example?
thanks

Assuming your class is called Money, you can retrieve all the objects that pass your condition doing:

List moneyObjects = session.createQuery("from Money as money where money.amount1 + money.amount2 = 100").list();

thanks dprotas,

if I use HQL this is the right way, but can I just get the result list by narrow down the criteria? I mean something like:

Criteria criteria=session.createCriteria(UserInfo.class);
criteria.add(Restrictions.ilike(......));

this is to maintain the code consitency.

As far as I know, the Criteria API doesn't support algebraic expressions like money.amount1 + money.amount2.

One thing you could do is create a column that is defined by the formula amount1 + amount2 and use that column with the Criteria API.

See the docs about defining columns using formula.