如何解决一般错误:2014 无法执行查询，而其他未缓冲的查询处于活动状态.使用 PDO 连接

2021-12-26 00:00:00 mysql pdo

当我使用相同的连接语句(使用 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();

相关文章