Edit report at http://bugs.php.net/bug.php?id=38955&edit=1
ID: 38955 Comment by: urkle at outoforder dot cc Reported by: remery at seminolesheriff dot org Summary: PDO DBLIB driver does not support transactions Status: Closed Type: Feature/Change Request Package: *General Issues Operating System: Linux PHP Version: 5.1.6 Assigned To: ssufficool Block user comment: N Private report: N New Comment: What is the timeline for this getting into an official 5.3 release? I have manually patched my version and can confirm it works on Mac OS X 10.6.6 running PHP 5.3.3. (though compiled PDO_DBLIB with this patch from the 5.3.5 release) Previous Comments: ------------------------------------------------------------------------ [2010-06-21 09:32:49] [email protected] Fixed in trunk. revision 300628. ------------------------------------------------------------------------ [2010-06-21 09:31:49] [email protected] This bug has been fixed in SVN. Snapshots of the sources are packaged every three hours; this change will be in the next snapshot. You can grab the snapshot at http://snaps.php.net/. Thank you for the report, and for helping us make PHP better. Fixed in revision 300628. ------------------------------------------------------------------------ [2010-06-21 09:30:50] [email protected] Automatic comment from SVN on behalf of ssufficool Revision: http://svn.php.net/viewvc/?view=revision&revision=300628 Log: Fix bug #38955 - add transaction support ------------------------------------------------------------------------ [2006-09-26 08:46:57] [email protected] No bug here, reclassified as feature request. ------------------------------------------------------------------------ [2006-09-25 18:43:10] remery at seminolesheriff dot org Description: ------------ I'm connecting from a Linux/Apache/PHP server to a Microsoft SQL Server 2000 database using PDO with the DBLIB driver. Attempting to use transactions produces the exception 'This driver doesn't support transactions'. Reproduce code: --------------- $dsn = 'dblib:host=' . $server . ';dbname=' . $dbName; $user = 'tempUser'; $pwd = 'tmpPwd'; $table = 'sqlTable'; $column = 'colName'; $value = 'value'; $sql = 'Insert Into ' . $dbName; $sql .= ' (' . $column . ')'; $sql .= ' Values ' . $value; $conn = new PDO($dsn, $user, $pwd); $conn->beginTransaction(); $conn->exec($sql); $conn->commit(); Expected result: ---------------- The value should be inserted into the table. Actual result: -------------- Fatal error: Uncaught exception 'PDOException' with message 'This driver doesn't support transactions' in /var/www/html/business/entity.php:37 Stack trace: #0 /var/www/html/business/entity.php(37): PDO->beginTransaction() #1 {main} thrown in /var/www/html/business/entity.php on line 37 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/bug.php?id=38955&edit=1
