Hi..

i am new to hibernate and have been reading the documentation for the Criteria query for quite some time now.. just wan to clear my doubts here..

is it possible for hibernate Criteria class to be able to span over multiple class objects? For eg, an sql statement such as this :

select a.sailorName, b.boatName
from sailor a, reserves b
where a.sid = b.rid

can it be converted to implement the criteria Class of hibernate? thanks.

ck

Use Query.

Query query = session.createQuery(<your hql>);
List list = query.list();

Elements are in list are of type Object[].

You should be able to do that with Projections shouldn't you? (as long as there is an association between your 2 tables)