Hello. I have a table with many values.

I would like to do something like this in Hibernate:

select distinct fabrikatid,modellbetegnelse,modellvariantid,type from motor;

This should retrieve a list of MotorData objects which are distinct.

fabrikatid is from FabrikatData object and modellvariantid is from ModellvariantData object. The rest are properties in MotorData.

Can someone help me please?

By default, calling such query with HQL will return an Object[]. Have a look here: http://www.hibernate.org/hib_docs/v3/re ... ryhql.html.

If you give more infos about relationships between your objects and precise what you'd like to do with it, maybe we'll be able to help you more.