File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes Hibernate with native SQL issue Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Hibernate with native SQL issue" Watch "Hibernate with native SQL issue" New topic

Hibernate with native SQL issue

Ankur Si

Joined: Dec 02, 2005
Posts: 23
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
David Madouros

Joined: Mar 08, 2005
Posts: 18

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"


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
Saikiran Madhavan

Joined: May 15, 2006
Posts: 28
hi David,

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

thanks in advance
Mark Spritzler

Joined: Feb 05, 2001
Posts: 17276


Please don't duplicate post. You have already created a thread on this topic. Which is right here

And answers both questions here, so I don't want to have to duplicate my answers to two different threads.

Good Luck


Perfect World Programming, LLC - iOS Apps
How to Ask Questions the Smart Way FAQ
I agree. Here's the link:
subject: Hibernate with native SQL issue
It's not a secret anymore!