Bug #76019 [Opn]: PDO::ATTR_AUTOCOMMIT attribut via the connect
| From: | scriviaoscar at yahoo dot it | Date: | Fri, 02 Mar 2018 14:32:32 +0000 |
| Subject: | Bug #76019 [Opn]: PDO::ATTR_AUTOCOMMIT attribut via the connect | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-214181@lists.php.net to get a copy of this message | ||
Edit report at https://bugs.php.net/bug.php?id=76019&edit=1
ID: 76019
User updated by: scriviaoscar at yahoo dot it
Reported by: scriviaoscar at yahoo dot it
Summary: PDO::ATTR_AUTOCOMMIT attribut via the connect
Status: Open
Type: Bug
Package: PDO ODBC
Operating System: centos 7.4
-PHP Version: 7.2.2
+PHP Version: 7.2.3
Block user comment: N
Private report: N
New Comment:
In PHP 7.2.3 I have seen issues when trying to set the
PDO::ATTR_AUTOCOMMIT attribut via the connect.
This issue was not apparent in 7.2.0 I have reproduced the same issue with the following PDO based
extensions
$db = new PDO("ibm:db", "uname", "***", array(PDO::ATTR_AUTOCOMMIT
=> 0));
if ($db) print "Connection Established";
'PDOException' with message 'The auto-commit mode cannot be changed for this
driver'
Previous Comments:
------------------------------------------------------------------------
[2018-02-27 14:16:36] scriviaoscar at yahoo dot it
Description:
------------
---
From manual page: http://www.php.net/ref.pdo-odbc
---
In PHP 7.2.2 I have seen issues when trying to set the
PDO::ATTR_AUTOCOMMIT attribut via the connect.
This issue was not apparent in 7.2.0 I have reproduced the same issue with the following PDO based
extensions:
- PDO_ODBC
Reproduce code:
---------------
<?php
$db = new PDO("ibm:db", "uname", "***", array(PDO::ATTR_AUTOCOMMIT
=> 0));
if ($db) print "Connection Established";
?>
Expected result:
----------------
Connection Established
Test script:
---------------
$conn = new PDO ( "odbc:" . $this->nameDB, $this->utente, $this->pass, array (
PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'"
) );
if (! $conn) {
Logger::getInstance ()->logMessage ( 'Connessione Sap fallita.', Logger::ERROR );
throw new Exception ( 'Connessione Sap fallita.',
GlobalConstants::EXCEPTION_MESSAGE_FROM_SERVER );
}
$conn->setAttribute ( PDO::ATTR_AUTOCOMMIT, 0 );
Expected result:
----------------
'PDOException' with message 'The auto-commit mode cannot be changed for this
driver'
Actual result:
--------------
'PDOException' with message 'The auto-commit mode cannot be changed for this
driver'
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=76019&edit=1