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.