Hello,

I want to use the <list> collection mapping instead of the <set> (to preserve ordering). Thefore I specify:



The POSITION field in DaySchedule is created but not filled... Do I have to specify more than just the index column?

regards,

Roland Beuker

I can't (quickly) locate the FAQ/Article/Wiki, but I found somewhere on the site where in Hibernate 2.x list indexes are not assigned automatically and you have to do something clever in your getter like this:



When Hibernate goes to persist the list, it will determine the indexes dynamically.

- Jesse

Hello Jesse,

Is this still true for hibernate-3.0

Thanks,

Roland

I think (and I am by no means certain) that I saw a post somewhere by one of the authors/admins indicating that there was a solution for this in Hibernate3, but I don't know what it is.

- Jesse

Read the documentation, there are several examples of list mappings in Hibernate 3.0.

Hello Christian,

I studied both the “Bible of Hibernate” ;-) and the reference documentation… But I cannot find how to generate the list indexes. The POSITION fields are created but not filled…

I have the following configuration:


Is the solution from Jesse also true for hibernate-3.0 of is there a more clear approach?

Regards,

Roland Beuker

Look at one of the unit tests if you want to copy paste code from a working example.

Just like the Customer/Order classes from the unit test I suplied a getter/setter for the index in DaySchedule (in the unit test example is this getOrderNumber/setOrderNumber in the Order class) but still the position field in my case is not filled %$*^%^(&$*&

@christian could you point an online hibernate3 test mapping list with list-index that shows up reordering?

i was not able to find something that match my requirements which are

Hibernate 3.2 mapping one-to-many with list using list-index and show how to reorder the list

Hi,

I'm having a similar problem. Please see my post:

http://forum.hibernate.org/viewtopic.php?t=968743

Sorry, no solution so far :-(

I have a solution. For a list with index you need a key for this index:

<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"./etc/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="com.eye.hibernate">

<class name="DaySchedule" table="DAY_SCHEDULE">

<cache usage="read-write"/>

<composite-id>
<key-many-to-one name="weekSchedule" column="WEEK_SCHEDULE_ID" class="WeekSchedule"/>
<key-property name="DayOfWeek" column="DAY_OF_WEEK"/>
</composite-id>

<version name="version" column="VERSION" unsaved-value="undefined"/>

<property name="DayScheduleName" column="DAY_SCHEDULE_NAME"/>

<list name="Periods" inverse="true" cascade="all-delete-orphan">
<key>
<column name="WEEK_SCHEDULE_ID"/>
<column name="DAY_OF_WEEK"/>
</key>
<index column="PERIOD_ID"/>
<one-to-many class="Period"/>
</list>

<property name="Active" column="ACTIVE"/>

</class>

</hibernate-mapping>

****************************************************

<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"./etc/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="com.eye.hibernate">

<class name="WeekSchedule" table="WEEK_SCHEDULE">

<cache usage="read-write"/>

<id name="Id" type="int" column="ID">
<generator class="native"/>
</id>

<list name="DaySchedules" inverse="true" cascade="all-delete-orphan" lazy="true">
<cache usage="read-write"/>
<key column="WEEK_SCHEDULE_ID"/>
<index column="DAY_OF_WEEK"/>
<one-to-many class="DaySchedule"/>
</list>

<property name="WeekScheduleID" column="WEEK_SCHEDULE_ID"/>
<property name="WeekScheduleName" column="WEEK_SCHEDULE_NAME"/>

<property name="Active" column="ACTIVE"/>

<set name="WeekScheduleInFpus" inverse="true" cascade="all-delete-orphan" lazy="true">
<cache usage="read-write"/>
<key column="WEEK_SCHEDULE_ID"/>
<one-to-many class="WeekScheduleInFpu"/>
</set>

</class>

</hibernate-mapping>

i finally solve my issue which look similar to your's

check http://forum.hibernate.org/viewtopic.php?t=968296