how to fetch selected columns as value object using HQL.

amitjain1979 · **Joined:** Thu Sep 01, 2005 10:35 am **Posts:** 8

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using: SQL Server

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Hi All,
When i want to fetch selected columns from an entity through HQL
and write query in HBM file , then i get the object array as result.
But i want to get value object as result through HQL (not native query) and write the query in hbm file .

so plz help me.

Amit Jain

max · **Posted:** Thu Sep 01, 2005 1:46 pm

what is the problem ?

if you select multiple values then you of course get an array...

pksiv · **Posted:** Thu Sep 01, 2005 2:33 pm

You can also create a constructor that takes the attributes you are selecting and specify your HQL as follows :

Code:

select new MyObject(moo.id,moo.someField, moo.someOtherField) from MyOtherObject as moo;