Can anyone tell me if multiple transactions can be active at the same time?  I.e.:

CSpTransaction tr1 = new CSpTransaction();
CSpTransaction tr2 = new CSpTransaction();
boolean commitFlag = true;

tr1.begin("dsSource");
// in Full Manual mode, build sql and tr1.executeInsert(DoName)
if (!DoName.succeeded() || command != PROCEED)
   commitFlag = false;
if (commitFlag) {
    tr2.begin("dsSource");
    // in Full Manual mode, build sql and tr2.executeInsert(DoName)
    if (!DoName.succeeded() || command != PROCEED)
       commitFlag = false
  }

if (commitFlag && tr1.isActive() && tr2.isActive()) {
   tr1.commit();
   tr2.commit();
}
else {
   tr1.rollback();
   tr2.rollback();
}

Does the beginning of transaction tr2, in effect, cancel tr1 (because a commit
or rollback was not done for tr1 prior to beginning tr2)?
_________________________________________________________________________

For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html

For dire need help, email: [EMAIL PROTECTED]

Reply via email to