db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Raphael.Mankin%GSK...@gsk.com
Subject Transaction management problem
Date Thu, 06 May 2004 15:11:35 GMT

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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

View raw message