Hi all,

I am using Hibernate to access data in a legacy database.
I have a class (Order) that has many line items. My Hibernate mapping of the line items in the Order class is as follows...
<list name="lineItems" lazy="true" cascade="all">
<key column="customer_order_id"/>
<index column="line_number" />
<one-to-many class="com.rpc.core.customer.model.CustomerOrderLineItem"/>
</list>

However, the line_number column used above is one-based, that is, int he database line items are numbered from 1 to n. However, the Order.getLineItems() method needs to return a zero-based list of line items. That is, the oth item in the List returned from Order.getLineItems() should be the line item with a line number of 1.

I tried to modify the above mapping by adding a type to the index that would transform the 1-based DB indexes to 0-based object indexes as follows...

<list name="lineItems" lazy="true" cascade="all">
<key column="customer_order_id"/>
<index column="line_number" type="net.sf.hibernate.eclipse.datatype.OneBasedIndexUserType" />
<one-to-many class="com.rpc.core.customer.model.CustomerOrderLineItem"/>
</list>


However, Hibernate seems to ignore the type if the index. To test this I set breakponts in the OneBasedIndexUserType class and they were never hit.

So, does anybody know how I can successfully map these line items with Hibernate?

TIA,
ted stockwell

I'm sure that the OP has found some workaround by now. If you manage to stumble across this thread with the same problem, however, I tried the following, and it worked much as I expected.




For my application, this works, since the elements that go in the bag are largely static. For the OP's application, keeping order-items in a bag is not the most efficient storage solution.