I have a one-many relationship that when i access via the POJO Set, it is missing data. If i directly query for the Set then all the data is retrieved propertly.
The StudentCourses Set in the StudentUser POJO is always missing the same rows, so its not randomly choosing rows to remove. Most, but not all of the StudentUser's experience this behavior.
As mentioned, a direct query works as shows here vs the incorrect data method
So there is something with the relationship in the mapping file because the data is there and is correctly displayed when i query the StudentCourses table directly. This is a huge database yet this is the only table/relationship that is experiencing this type of issue, so I really have no clue what the problem is as all the data looks correct.
I am using Hibernate 3.5.3. Sorry if i have not provided enough info, but since I'm so lost on this issue I don't know where to start or whats important to talk about. Please ask for whatever information you may need to assist me.
If it helps, here is the mapping for the StudentCourses table