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:-
can anyone help me out why my query is not returning Mailbox object(s)and how to write the query in HQL format ?
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