PDO::MYSQL_ATTR_USE_BUFFERED_QUERY error occuring while calling stored procedure in zf2

Question

when calling a stored procedure in zend framework 2 , it throwing an error message, how can i solve this issue ,

$dbAdapter = $e->getApplication()->getServiceManager()->get('Zend\Db\Adapter\Adapter');
    $results = $dbAdapter->query("CALL PROCEDURE_NAME('PARAM1')");
    $DataSource = $results->execute();
    $Statement = $DataSource->getResource();
    $Result = $Statement->fetchAll(\PDO::FETCH_OBJ);

the above code is using to get stored procedure information

getting below error

Statement could not be executed (HY000 - 2014 - Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.)

Have a look at php.net/manual/en/ref.pdo-mysql.php and it will give you the information about your error. — Ukuser32
Solved my problem , i just put closeCursor after fetching result — Rathilesh C

Rathilesh C Rathilesh C · Accepted Answer · 2016-03-04T08:17:11

Solved my problem , i just put closeCursor after fetching result

$dbAdapter = $e->getApplication()->getServiceManager()->get('Zend\Db\Adapter\Adapter');
$results = $dbAdapter->query("CALL PROCEDURE_NAME('PARAM1')");
$DataSource = $results->execute();
$Statement = $DataSource->getResource();
$Result = $Statement->fetch(\PDO::FETCH_OBJ);
$Statement->closeCursor();

Thank you Ukuser32 for supporting me to find solution

PDO::MYSQL_ATTR_USE_BUFFERED_QUERY error occuring while calling stored procedure in zf2

1 Answers