Is There any way to get ...as..

suppose we have a table students in that name,id,courseid, pic are the columns..

We have to get the records from the database only name , id & courseid thatsall, we dont need pic because of blob.

yes, i know its easy to do with create sql query,projections and native sql,but by using those we get an object array in that we have the values..,

But i want an student Object which have only name,id & courseid, if we tried to get the pic from that object it has to return null.

I tried with by using cliterias, and add Entities,Restrictions ..etc but i cant..

Pls Get A way.....

sorry , it's not clear what problem do you have
when you use sql query it returns a list of object that you want and if you try to us some property that are null maybe make some terrible for you .
form example :
Query query = session.createQuery("from Student s where s.id=" + student.getId());
and before use pic , you can check if it's not null do some action on it

ok ok iknow that we give sql query means we get object array that mean object[] fro that one we have to print by using for loop...,

but we want the students object that mean..

for(i=0;i<=list.size;i++)
{
Students s=(Students)list.get(i);
sys.out.print(s.getId());
sys.out.print(s.getName());
sys.out.print(s.getCourseId());
sys.out.print(s.getPic());

}

if we give like that then it has to print all the values except pic, pic has to be null., that mean we have to restrict that pic property by using projections or sql query& entities etc.. i tried but its not working..

It can be done w/ lazy property fetching. See

http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#performance-fetching-lazyproperties

says