Analytics Software

Hi all,

I have some concern about odi + groovy + loop + commit. If I put commit in the loop I don't see COMMIT but if I put COMMIT external for i see COMMIT.

In this example at end of script object are delete (commit done). Ad the end of script data is deleted-

txnDef = new DefaultTransactionDefinition();

tm = odiInstance.getTransactionManager();

txnStatus = tm.getTransaction(txnDef);

mgr = odiInstance.getTransactionalEntityManager();

for (int i = 0; i < allScenario.size(); i++)

{

  .....

  .....

    odiInstance.getTransactionalEntityManager().removeAll(allStepReport);   

    odiInstance.getTransactionalEntityManager().removeAll(allScenarioReport);   

}

odiInstance.getTransactionalEntityManager().persist(myProject);

tm.commit(txnStatus);

In this example at end of script objects aren't delete (commit not done). Ad the end of script data isn't deleted-

for (int i = 0; i < allScenario.size(); i++)

{

     txnDef = new DefaultTransactionDefinition();

     tm = odiInstance.getTransactionManager();

     txnStatus = tm.getTransaction(txnDef);

     mgr = odiInstance.getTransactionalEntityManager();

  .....

  .....

    odiInstance.getTransactionalEntityManager().removeAll(allStepReport);   

    odiInstance.getTransactionalEntityManager().removeAll(allScenarioReport);   

     odiInstance.getTransactionalEntityManager().persist(myProject);

     tm.commit(txnStatus);

}

Please can help me?