I have three tables A,B,C.
A has one to many relationship with C
B has one to many relationship with C
Now I have six objects as follows
ObjA1 ---> of type A
ObjA2 ---> of typeA
ObjB1---> of type B
ObjB2-> of type B
ObjC1--> Of type C & Having link to ObjA1 and ObjB1
ObjC2-> Of type C & Having link to ObjA2and ObjB2
First I save all these objects one by one
Next I update ObjA2
Then I delete ObJC1,ObjC2,ObjB1,ObjB2 in that order.
But when i try to delete ObjA1 it gives the following exception
SQL insert, update or delete failed (expected affected row count: 1, actual affected row count: 0). Possible causes: the row was modified or deleted by another user, or a trigger is reporting misleading row count.
I have no triggers in database
What could be the problem ?How to solve it?
Thanks,
Sandipan
|