Hibernate version:
3.2.2.ga
Mapping documents:
<list name="education" lazy="true" table="person_education_relation" cascade="all">
<key column="user_id" />
<list-index column="education_idx" />
<many-to-many class="net.model.Education" column="education_id" />
</list>
Name and version of the database you are using:
Oracle 10g
It does not give an Exception, but does not sort the list based on the list-index column. When I do a 'select * from person_education_relation' in SQLDeveloper the results show the zeroth (0) index as the second row returned. It seems Hibernate is actually sorting based on the ROWNUM in Oracle and ignoring the list-index column. We had a data corruption which is why the ROWNUMS are messed up anyway, but I can't seem to find anybody with a similar issue.
Any ideas? Links, etc would be helpful.
Thank you.
|