Selecting a couple of columns

wsoumer · **Posted:** Thu Mar 17, 2005 7:56 am

Hibernate version: 2.1.7

Hi all!!
I'm new to hibernate, and i would know if it is possible to select a couple of columns and retrieve the resuts in a list of beans.
Thanks.
Walid.

Jacob · **Joined:** Wed Mar 09, 2005 5:03 am **Posts:** 7

Selecting a couple of columns, just use HSQL:

Code:

Select object.column1, object.column2 from MyClass object

Returns an array of objects.

mappings:

Code:

<class name="MyClass" .. >
....
<property name="column1"..../>
<property name="column2"..../>
....
</class>

wsoumer · **Posted:** Thu Mar 17, 2005 8:57 am

Hi Jacob,
thank you for your answer, but i would like the list returned to be composed of elements of type MyClass.
Walid.

max · **Posted:** Thu Mar 17, 2005 9:15 am

select new MyClass(object.column1, object.column2) from MyClass object

will return MyClass objects as long as it has a constructor matching the specified properties.

note that these MyClass objects are not entities, but mere half-full value objects.

/max

wsoumer · **Posted:** Thu Mar 17, 2005 11:46 am

Works Fine !!!
Great, thanks.