Hi Guys,
I have a strange problem, when I execute the code mentioned below the list contains repeated entires of first record only ... I tried using session.find() func to fetch all records which resulted in different records but large number of them still repeat...

query = session.createQuery("from XDataTO where stype = :var order by sleutel");
query.setString("var", "FUNC");
List list = query.list();

I am using RAD6.0 with DataSource accessed via JNDI (hibernate.cfg.xml)

I have exhausted various ways which hibernate provides to fetch data but everyone results in duplex objects..

Can anyone please issolate this issue for me or atleast point me in the right direction ?

Cheers
Andy

I was able to solve the issue it was a DataBase issue being legacy system they had multiple constraints on sevral columns to make them unique.

Therefore by using composite-id tag inside hbm.xml and over ridding equals + hashCode methods (for bean).. I am now able to direct hibernate to recognize a unique combination of columns..

If the "id" inside hbm.xml is not unique hibernate duplicates all records with similar id's and that was what I was getting as result..

Have a nice day guys...

yes - id is something that has to be unique, otherwise it aint an id is it ? ;)