lecosson / assql

Automatically exported from code.google.com/p/assql
0 stars 0 forks source link

Concurrency Error by call Stored Procedures #84

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
  1. Create a Stored Procedure that returns some data:

DELIMITER $$
CREATE PROCEDURE `TestDude` ()
BEGIN
  SELECT "SomeData";
END $$
DELIMITER ;

  2. CALL 'TestDude' Stored Procedure one after the other (or TestDude
followed by any SELECT statement)

...  
    var xState1:Statement = xMyConn.createStatement();
    var xToke1:MySqlToken = xState1.executeQuery("call TestDude()");

    var xState2:Statement = xMyConn.createStatement();
    var xToke2:MySqlToken = xState2.executeQuery("call TestDude()");
...

What is the expected output? What do you see instead?
  Expecting data instead an exception is thrown

What version of the product are you using? On what operating system?
  Revision 178 on Vista, AIR 1.5

Please provide any additional information below.
  Turning the Logger to "ALL", it seems like everything is being processed
correctly.  It seems like the Connection.dataHandler is not being cleaned
up in 'unregisterDataHandler()'...?

Original issue reported on code.google.com by rondrebe...@gmail.com on 18 Jun 2009 at 4:54

GoogleCodeExporter commented 9 years ago

Original comment by macl...@gmail.com on 1 Mar 2010 at 2:48