Changeset 20492 for lang/php/misc/Hermit/src/Hermit/command/HermitProcedureCommand.php

Timestamp:

10/02/08 18:12:10 (3 months ago)

Author:

nowelium

Message:

mysql の procedure サポートは終わり。
General error: 2014 Cannot execute queries while other unbuffered queries are active. とかは、PDOのPDO::MYSQL_ATTR_USE_BUFFERED_QUERY をいくら設定してもダメなので、少し逃げ。一端切断すればなんとかなるけど、Datasource設定とかは管理外なので、やらない。
multi rows は 2次元配列で。

Files:

• lang/php/misc/Hermit/src/Hermit/command/HermitProcedureCommand.php (modified) (1 diff)

lang/php/misc/Hermit/src/Hermit/command/HermitProcedureCommand.php

@@ -21 +21 @@
         $this->annote = $annote;
     }
-
     public function execute(PDO $pdo, array $parameters){
+        if($this->sqlCreator instanceof HermiSetupSqlCreator){
+            if($this->sqlCreator->hasSetupSql()){
+                $setupBuilder = new HermitSetupStatementBuilder($this->method, $this->annote, $this->sqlCreator);
+                $setupStatement = $setupBuilder->build($pdo);
+                $setupStatement->execute($parameters);
+            }
+        }
+        
         $builder = new HermitProcedureStatementBuilder($this->method, $this->annote, $this->sqlCreator);
         $stmt = $builder->build($pdo);
         $stmt->execute($parameters);
         $rs = HermitProcedureResultSetFactory::create($pdo, $stmt->getSqlParameter());
+//
+//        to pdo_mysql cause: Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active.
+//        if($rs instanceof HermitParameterBind){
+//            $rs->bindParameter($pdo, $parameters);
+//        }
+//        return $rs->execute($stmt, $this->type);
+//
+        $returnValue = $rs->execute($stmt, $this->type);
         if($rs instanceof HermitParameterBind){
             $rs->bindParameter($pdo, $parameters);
         }
-        return $rs->execute($stmt, $this->type);
+        return $returnValue;
     }
 }