Hibernate Criteria API Select some fields..

[Leonardo Carreira]

Hi Friends...

Currently, iam learning for using Hibernate Criteria API for retrieving data from Database...
how to select some field with Criteria API?..
example i have a table which has 5 columns..
how to get of the some field of the table?..

i created the Criteria API like this :

  
               Session session= hibernateTemplate.getSessionFactory().openSession();
		Criteria criteria = session.createCriteria(MyTable.class);
		criteria.add(Restrictions.eq("columnA", code));
  

but the query which resulted is

Select columnA, columnB, columnC, columnD, columnE
From MyTable
Where columnA=?

How to get some field by using CriteriaAPI?..
example.. i want to retrieve query by using select like this..

Select columnA, columnB
From MyTable
Where columnA=?

Thanks in advance..

[Cameron Wallace McKenzie]

So, what you're going to get back from the criteria query is your object, rather than an individual column. With the object, just call the getter.

Simple Tutorial on How To Use The Hibernate Criteria API

-Cameron McKenzie

[Mark Spritzler]

To add to Cameron's response. It is easiest and quickest to do it with getting back the objects.

Only in the case of a "report" do you want to do selection of certain fields, and to do those you use the Projections Criterion objects.

Mark

[Leonardo Carreira]

@Cameron and @Mark

Okay.. Thanks all..

it could ran well now.. yap i have to learning extra hard..

Thanks in advance ..