|
Foreign key integrity constraints and Transactions: msg#00124jakarta.turbine.torque.user
I've got table A & table B, where B.childID is a foreign key to A.ID. This is running on the oracle backend. The scenario is: I create a new A entity, torque correctly starts the transaction and acquires a new A.ID for the primary key. Then torque goes on to create a new row for B, putting in the correct value for B.childID. However - when save() is called for B, I get an integrity constraint error saying the parent key does not exist. And so as you would expect, the whole transaction is rolled back. If it's within the same transaction call - shouldn't this work? The only way I could make it work is to disable the foreign key constraint - I'm not comfortable with this solution. Is this working as designed? -John |
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | AW: Antwort: SQL->Criteria howto: 00124, Sperlich, Tino |
|---|---|
| Next by Date: | Re: AW: Antwort: SQL->Criteria howto: 00124, Richard Bayet |
| Previous by Thread: | RE: Foreign key integrity constraints and Transactionsi: 00124, Thomas Fischer |
| Next by Thread: | torque:om-generate says successful, but no java generated?: 00124, Phillip Rhodes |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
| News | FAQ | advertise |