Ankur,
When you use 'select' in either an HQL or native SQL query, Hibernate does not return the object in your 'from' clause. Just as when using non-Hibernate SQL, 'select event.* ...' returns all the columns from the event table. The List you get back from your query is a list of Object[] (object arrays). Each element in the list is an array of Objects and each element in the array represents one column in the event table.
For example, if I have a table defined as:
that contains the following data:
and I use a Hibernate SQL query as follows:
I get a List of Object[]. The first element in the List represents the first row in my result set:
Object[0] is of type BigInteger and has a value of 1
Object[1] is of type
String and has a value of "Madouros"
The second element in the List represents the second row in my result set:
Object[0] is of type BigInteger and has a value of 2
Object[1] is of type String and has a value of "Johnston"
etc.
Not seeing your tables, I cannot say exactly what you get back. But, this should give you the idea.