1 Reply Latest reply on Nov 8, 2001 6:51 AM by Colin Thorburn

    How to create FK relationship correctly

    Colin Thorburn Newbie

      Consider thiss scenario

      DDL:
      table X (id int primary key,
      attrs...
      )

      table Y (id int primary key,
      theX int foreign key references x.id,
      attrs...
      )
      ------------------------------------------------------

      Client:

      SSBA a=SSBAHome.create() <-- txn attr=required

      a.x()

      ----------------------------------------------


      SSBA::x <-- txn attr=required

      EntityX x= XHome.create() <-- txn attr=required

      Entity y=YHome.create(x) <-- txn attr=required establishes foreign key relationship


      ------------------------------------------------------
      Why should this straightforward scenarion cause a txn timeout?

      Can someome please explain this?