• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Liutauras Vilda
  • Campbell Ritchie
  • Tim Cooke
  • Bear Bibeault
  • Devaka Cooray
Sheriffs:
  • Jeanne Boyarsky
  • Knute Snortum
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Ganesh Patekar
  • Stephan van Hulst
  • Pete Letkeman
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Ron McLeod
  • Vijitha Kumara

SQL-Query not returning specified Object  RSS feed

 
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

I am using Hibernate 3.1 with SQL Server 2005,the problem i am facing is this.I have written a SQL-Query within my hbm file for returning a specified Object, that query is a complicated sub-query involving 3 tables.

first of all i am new to Hiberbate so i dont know how to convert the same query into HQL.

My SQL query is as below:-



The hbm files are as given below:-



Account.hbm



can anyone help me out why my query is not returning Mailbox object(s)and how to write the query in HQL format ?

thanks in advance
saikiran
 
ranger
Sheriff
Posts: 17314
11
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Just quickly looking at the sql-query, in the mapping you don't tell Hibernate what kind of object it is supposed to return, so how is Hibernate going to guess? So Hibernate will be returning a list of Object arrays. so List<Object[]>.

Here are some ways to get Hibernate to return an List of your objects rather than a list of Objects arrays

sess.createSQLQuery("SELECT ID, NAME, BIRTHDATE FROM CATS").addEntity(Cat.class);

And in your case to tell Hibernate what types of Objects you want you can do something like this from the Hibernate documentation

 
Saikiran Madhavan
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Mark,

I am sorry for posting the question multiple times.That question has got similar problem like that of mine, thats why i posted it there also.

Thank you for your reply and i will try this piece of code in my program.

Saikiran
 
Saikiran Madhavan
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

i got the desired object by adding the return tag...Thank you for your valuable advice.


thanks all

saikiran
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!