I have inherited a legacy system which uses Hibernate 2. I have a problem where it's not retrieving all the records which exist in the database table. It should retrieve 8 records but only retrieves 5.

The developers that left obviously did not test the system before rolling it out. :-(

I would like to know how I can investigate why this is happening. I have checked the mapping and changed the query but still does not retrieve all of the records.

Look forward to your advice,

James P.