php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #76019 PDO::ATTR_AUTOCOMMIT attribut via the connect
Submitted: 2018-02-27 14:16 UTC Modified: 2018-03-02 14:32 UTC
From: scriviaoscar at yahoo dot it Assigned:
Status: Open Package: PDO ODBC
PHP Version: 7.2.3 OS: centos 7.4
Private report: No CVE-ID: None
Have you experienced this issue?
Rate the importance of this bug to you:

 [2018-02-27 14:16 UTC] 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'

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2018-02-27 14:18 UTC] cmb@php.net
-Type: Documentation Problem +Type: Bug
 [2018-03-02 14:32 UTC] scriviaoscar at yahoo dot it
-PHP Version: 7.2.2 +PHP Version: 7.2.3
 [2018-03-02 14:32 UTC] scriviaoscar at yahoo dot it
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'
 
PHP Copyright © 2001-2018 The PHP Group
All rights reserved.
Last updated: Sun Nov 19 01:31:42 2017 UTC