Hi all,

I have this weird issue that I am having.
I am using transaction on this function call functA(). And functA() has been 
called many times, the transaction worked perfect.

BUT...for a reason that I still don't know, the transaction sometimes will not 
work.
And it seems that this phenomenon only happens on the release build because I 
couldn't reproduce it at all when I am debugging it.

How do I find out that the issue was the transaction on release build?
I log the before I call transaction begin, and its result and fault handler. I 
notice that the begin got called but it never got to neither result nor fault 
handler, which just baffled me.
And I did make sure my transaction listener are NOT using weak references.

Here's a snip of the code if you are curious:

public class AsyncTransactionClass extends EventDispatcher
{
   public function functA():void
   {
     sqlStatement = new SQLStatement;
     sqlStatement.text = "some query";
     sqlStatement.sqlConnection = <a sql connection>;
                        
sqlStatement.sqlConnection.addEventListener(SQLEvent.BEGIN,transactionSetupResultHandler);
                      
sqlStatement.sqlConnection.addEventListener(SQLErrorEvent.ERROR,transactionSetupFaultHandler);
                  
                                
     sqlStatement.sqlConnection.begin();
   }

   private function transactionSetupResultHandler(pEvent:SQLEvent):void
   {
     trace("I AM AT RESULT");
   }

   private function transactionSetupFaultHandler(pEvent:SQLErrorEvent):void
   {
     trace("I AM AT FAULT");
   }
}

Does anyone else have this problem?
I am really out of ideas now on how to solve this.

Thank you.




Reply via email to