Hibernate version:
Hibernate 2.1.4
Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:
Oracle 8.1.7
The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

If i write a following query

select c1.name, c2
from c1 in class c1class, c2 in class c2class
where c1.key = c2.key

List list = session.find(qry)

How do i get the two selected items in two different persistant classes? Is something like this possible? If i select only c1.name or c2 alone the query works.

I get the following error "java.lang.Object" when the next() executes from the list.

Any suggestions?

Thanks

-Naren

you get a Object[] per list element
so
object[0] is c1.name --> cast it to (String)
object[1] is c2 --> cast it to.... you know ;)