permaculture playing cards
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 REST with Spring (video course) this week in the Spring 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!