Hi Ranchers, I've got an problem in hibernate with SQL, my code is as below -
It gives me following error -
could you please help me out in this regard.
Thanks in advance
Joined: Mar 08, 2005
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 is of type BigInteger and has a value of 1 Object 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 is of type BigInteger and has a value of 2 Object is of type String and has a value of "Johnston"
Not seeing your tables, I cannot say exactly what you get back. But, this should give you the idea.
David Madouros<br />SCJP 1.4
Joined: May 15, 2006
I too face the same issue as you told, i am using sql-query in my hbm and instead of getting my specified Mailbox Object, i am getting collection of Object.
Can you tell me how to write the same peice of SQL in HQL and to retrieve my specified Object
my hbm file is as below:-
the high-lighted query is the problematic one. The associated Account.hbm is also given below