Hello everybody!

I am working on a big project. The database is designed in the beginning without considering Hibernate concerns. Now we are using Hibernate for automated persistence. I am facing this problem with CMR. I am using cascade=all with one-to-many relation in Source entity mapping. When I am saving source entity Hibernate is generating
i) INSERT query for SOURCE entity
ii) generating INSERT query for TARGET entities (without SOURCE-ID value)
iii)then generating UPDATE query for updating the SOURCE-ID value

But the table defn for TARGET entity is having 'NOT NULL' constraint on SOURCE-ID column. Due to this the second query is failed in execution. Like this we have many tables defined in our system.

Is there any alternate to set the SOURCE-ID value in the INSERT query for the target without having separate UPDATE query for that.

Thank you!

This is definitely a FAQ. Section 9.2 of the manual - bi-directional relationships - should help you. This exect topic is covered