Apologies. I am an idiot. I posted to the wrong user group.
----- Forwarded by Raphael X Mankin/Complementary/PharmRD/GSK on
06-May-2004 16:10 -----
|---------+---------------------------->
| | Raphael Mankin |
| | |
| | Sent by: Raphael |
| | X Mankin |
| | |
| | |
| | 06-May-2004 16:09|
| | |
|---------+---------------------------->
>-------------------------------------------------------------------------------------------------------------------------|
|
|
|
|
|
|
| To: [EMAIL PROTECTED]
|
|
|
| cc:
|
| Subject: Transaction management problem
|
>-------------------------------------------------------------------------------------------------------------------------|
My environment is Oracle 9i, Torque 3.1, Linux/Solaris
I have parent and child tables. I perform the following tests:
test 1.
create parent
create child
result OK
test 2
delete parent
fails with integrity check - as expected
test 3
delete child
delete parent
Fails: SET TRANSACTION must be first statement in transaction
If I run just tests 1 and 3 then all is sweetness and light.
I am not doing any explicit transaction management; I am not managing any
connections. All that is handled implicitly by Torque. The deletions are
done using a Criteria on the primary key.
So what is going on?
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
