aspose file tools*
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
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Hibernate with native SQL issue" Watch "Hibernate with native SQL issue" New topic
Author

Hibernate with native SQL issue

Ankur Si
Greenhorn

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
Greenhorn

Joined: Mar 08, 2005
Posts: 18
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.


David Madouros<br />SCJP 1.4
Saikiran Madhavan
Greenhorn

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
saikiran
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17260
    
    6

Saikiran,

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

http://www.coderanch.com/t/217667/ORM/java/SQL-Query-not-returning-specified

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

Good Luck

Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Hibernate with native SQL issue