I have 2 Tables with the following fields:

1) LR_Registry
- Parcel_No (unique)
- Date
- Status

2) LR_Properties
- Parcel_No
- Entry_No
- Description

There is a one-to-many relationship between Registery to Properties. The Parcel_No field is the key. The Database is AS400 and no primary key has been set on the LR_Properties table. The legacy apps just select * from LR_Properties where Parcel_No = the value of the LR_Registry.Parcel_No.

I have no idea how to set this up in Hibernate. Or, if it is even possible without making some changes to the Database. The AS400 is a very old system and it's unlikely I could request any modifications.

OK, I have made some progress. I am able to get the parent table information (LR_Register). However, the relationship only returns the 1st record from the child table (LR_Properties). I know there are 4 children, in my test case. Furthermore, if I do a findAllByIdLike() to retrieve all the children from Groovy/Grails, I only get one child. Is Hibernate seeing only 1 child record or is it just ignoring the rest?