Hi

I've got a class A which contains a collection of objects B. I add a load of B objects to the collection, then save A.

Looking at the debug, it seems to be doing an INSERT for each instance of B, which is great.

But then, it goes and does an UPDATE for each one too. And the values it uses are wrong.

Could anyone tell me a) why the updates are being done in the first place and b) where it's getting the values for the column CHECKLIST_ITEM_ID. These are supposed to be foreign keys to another table. In the INSERT, the correct values are being used, but on the update, a FK Violation takes place, and I get a stacktrace.

The incorrect values that it uses are incremented by 1 each time, so I'm guessing it's the position of the record in the list. But that's just a guess.

The B records are getting stored in the DB, so I'd be happy if I could simply disable the UPDATES.

Here's my mapping:



Here's the (correct) INSERT that's being executed

DEBUG hibernate.SQL - insert into CHECKLIST_ITEM_RECORD (NOTE_ID, CHECKED, CHECKLIST_ITEM_ID, CHECKLIST_ID) values (?, ?, ?, ?)
DEBUG type.IntegerType - binding '0' to parameter: 1
DEBUG type.BooleanType - binding 'false' to parameter: 2
DEBUG type.IntegerType - binding '139' to parameter: 3
DEBUG type.IntegerType - binding '37' to parameter: 4

Here's the (incorrect) UPDATE

DEBUG hibernate.SQL - update CHECKLIST_ITEM_RECORD set CHECKLIST_ID=?, CHECKLIST_ITEM_ID=? where CHECKLIST_ITEM_ID=? and CHECKLIST_ID=?
DEBUG type.IntegerType - binding '37' to parameter: 1
DEBUG type.IntegerType - binding '0' to parameter: 2
DEBUG type.IntegerType - binding '120' to parameter: 3
DEBUG type.IntegerType - binding '37' to parameter: 4

Thanks

Hi,
You have mapped same table(CHECKLIST_ITEM_RECORD) two times.

what is the use of this,

Instead of doing these, you can use set in class A and do one-to-many mapping.

Otherwise, could you explain, what you want exaclty, and post your java source, which you use for insert

Hi

Thanks for replying. I'm new to Hibernate, so if you see any obvious looking mistakes in my mappings (like mapping a table twice) please tell me, because the chances are I will not be aware of them (so thanks for that pointer).

All I want is a LIST of ChecklistItemRecordValue objects hanging off my parent ChecklistValue object. It should look like this:

[A]>---[B]----[C]

Where A is ChecklistValue, B is ChecklistItemRecordValue. The value of CHECKLIST_ITEM_ID is a foreign key to another table (C). B also contains other fields (such as 'checked')

This is the code I'm using to save the object



Thanks

NB the saveChecklist method is calling the line



because I previously saved the top level object

I also changed the line below so the portion in red is not there any more (I think this fixes the 'table mapped twice' problem), but I still see the same behaviour.

<list name="checklistItemRecords" table="CHECKLIST_ITEM_RECORD" lazy="false" fetch="select" outer-join="false" cascade="all">

-Richard

I'm sorry, it's been a long day.

The relationship should be:

[A]---<[B]----[C]

not:

[A]>---[B]----[C]

Hi,

You can do like these,

<class name="A" table="CHECKLIST">
...
<set name="checklistItemRecords" lazy="false" cascade="all">
<key column="CHECKLIST_ID" />
<key column="CHECKLIST_ITEM_ID"/>
<one-to-many class="com.lsb.uk.mqs.value.ChecklistItemRecordValue"/>
</set>

</class>

<class name="ChecklistItemRecordValue" table="CHECKLIST_ITEM_RECORD">
<composite-id unsaved-value="any">
<key-property name="checklistItemId" column="CHECKLIST_ITEM_ID"/>
<key-property name="checklistId" column="CHECKLIST_ID"/>
</composite-id>
<property name="noteId" column="NOTE_ID"/>
<property name="checked" column="CHECKED"/>
</class>

For this insert will happen for two times, one is for A class and ChecklistItemRecordValue class.

During insertion and updation be sure, in class A's checklistItemRecords are not null