I have to create objects and mapping to a parent/child structure for a legacy database.

In short, I have a parent object "Invoice" with a child "InvoiceRow". Both have composite id's.

INVOICE(year, number, customer)

INVOICEROW(year, number, row, item)

(underlined fields are business key members).

Hibernate version: 3.2.4.sp1

I've tried with the following mappings, but with no success in insert and delete of childs.

Mapping documents:





InvoiceId is the class of the Invoice identifier and is defined in a quite obvious way.

row field is assigned manually.

One of the problems is that equals and hashCode of child are defined to be a function of the index field of the child (row).
I know this is an error, but there is no other set of fields to correctly define these methods.

Any suggestion?

At the last I'm able to load Invoice, fetch InvoiceRow(s), insert new InvoiceRow.
But the problem is that I cannot delete InvoiceRows.

The problem is that values in row field must range from 1 to <number_of_InvoiceRows> with no holes in the sequence.

So, if I have these records of InvoiceRows (year, number row item):

2007, 100, 1, aaa
2007, 100, 2, bbb
2007, 100, 3, ccc
2007, 100, 4, ddd
2007, 100, 5, eee

and I want to delete the third record, I can obtain, with Hibernate:

2007, 100, 1, aaa
2007, 100, 2, bbb
2007, 100, 4, ddd (but should be 3)
2007, 100, 5, eee (but should be 4)

Hibernate don't allow me to persist changes to 'row' value. For VALID and OBVIOUS reasons.

Please don't tell me that this is bad: I already know that.

I need a workaround.

Thank you very much