如何解决一般错误:2014当其他无缓冲查询处于活动状态时，无法执行查询.使用PDO连接 [英] how to resolve General error: 2014 Cannot execute queries while other unbuffered queries are active. using PDO connection

问题描述

当我使用相同的连接语句(使用PDO)执行第二个存储过程时，出现以下错误.

While i am executing second Stored procedure with same connection statement(Using PDO), getting the below error.

================================================ ==

=================================================

SQLSTATE [HY000]: 常规错误:2014当其他无缓冲查询处于活动状态时，无法执行查询.考虑使用PDOStatement :: fetchAll(). 另外，如果您的代码只打算针对mysql运行，则可以通过设置 PDO :: MYSQL_ATTR_USE_BUFFERED_QUERY属性.

SQLSTATE[HY000]: General error: 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.

================================================ ========

=======================================================

这是我在drupal中的代码

This is my code in drupal

$conn->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);

$statement = $conn->prepare("CALL Odd_Get_Sport()");
$exec_result = $statement->execute();
while ($row = $statement->fetchObject()) {   
  print_r($row);
}


$statement ->closeCursor();

$statement1 = $conn->prepare("CALL Odd_Get_Sport()");
$exec_result1 = $statement1->execute();
while ($row1 = $statement1->fetchObject()) {   
   print_r($row1);
}

请帮助我.

推荐答案

这是PDO的一个较差的功能，没有得到充分的记录.当语句执行了存储过程时，closeCursor方法不起作用.您需要使用nextRowSet方法.这是我用的

This is a bit of a poor feature of PDO that's not well documented. The closeCursor method doesn't work when the statement has executed a stored procedure. You need to use the nextRowSet method. Here's what I use

            while($sth->nextRowSet())
        {
            $sth->fetchAll();
        }
        $sth->closeCursor();

这篇关于如何解决一般错误:2014当其他无缓冲查询处于活动状态时，无法执行查询.使用PDO连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！