Req #38955 [Com]: PDO DBLIB driver does not support transactions
Edit report at https://bugs.php.net/bug.php?id=38955&edit=1 ID: 38955 Comment by: programmer at finner dot de 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: Why is this bug closed? The error still persists! I use PHP 5.3.10, and would really need to have transactions, and cannot use another database engine. So, PLEASE!!!, fix this! Thanks in advance. Previous Comments: [2011-09-17 14:58:51] vds dot jeroen at gmail dot com Patch should be added to 5.3 branch [2011-05-07 19:11:36] ssuffic...@php.net No developer cares about it, but plenty of users have and do care. I don't use PHP much anymore, but that may change. When it does, I will consider maintaining this in two different places. Until then, the patches are here and the currently working and tested module resides in svn trunk. [2011-04-30 21:19:14] paj...@php.net It is marked as such because nobody cares about it. And before you came in, it should have marked as such in core as well. Anyway, I do it for zip, enchant and planing to do so for more extensions as well. This is a very good way to provide more frequent releases to our users and especially to the distros. [2011-04-30 21:04:23] ssuffic...@php.net I do not see a practical way to PECL this because PDO is already core to PHP and marked depreciated in PECL. [2011-04-30 20:32:05] paj...@php.net I don't see why you could do releases via PECL as well. That will free you from the slower PHP release cycles. The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=38955 -- Edit this bug report at https://bugs.php.net/bug.php?id=38955&edit=1
Req #58600 [Com]: Support for transactions -mssql
Edit report at https://bugs.php.net/bug.php?id=58600&edit=1
ID: 58600
Comment by: programmer at finner dot de
Reported by:sigurdne at online dot no
Summary:Support for transactions -mssql
Status: Closed
Type: Feature/Change Request
Package:*General Issues
Operating System: Ubuntu 8.10
PHP Version:5.2.6
Assigned To:ssufficool
Block user comment: N
Private report: N
New Comment:
This issue is identical to #38955 (from 2006-09-25!!!). Obviously nobody
recognized, that the OP referred to MSSQL via DBLIB/FreeTds, NOT to MySQL. I
did
not find anything about issues #38955 or #58600, or anything about a fix of
lack
of transactions in the changelogs up to 5.4, and with 5.3.10 I got this error
myself today. Therefore, this issue should remain open until it is really
fixed.
Issue #38955 is also closed due to "No developer cares about it", which is
quite
arrogant.
Previous Comments:
[2011-12-01 05:38:26] ssuffic...@php.net
Thank you for your bug report. This issue has already been fixed
in the latest released version of PHP, which you can download at
http://www.php.net/downloads.php
Try 5.4 RC2
[2009-03-30 02:26:16] sigurdne at online dot no
By looking at the pdo_mysql - it looks like something like this could work.
However there seems to be a problem that the transaction state is not reported
correctly - so when it comes to the commit - it claims that it is not in a
transaction.
Anyone that could help out?
diff -aburN --exclude='.svn*' --exclude='CVS*' PDO_DBLIB-1.0.org/dblib_driver.c
PDO_DBLIB-1.0/dblib_driver.c
--- PDO_DBLIB-1.0.org/dblib_driver.c2005-10-16 16:58:50.0 +0200
+++ PDO_DBLIB-1.0/dblib_driver.c2009-03-27 13:10:14.0 +0100
@@ -166,14 +166,30 @@
return 1;
}
+static int dblib_handle_begin(pdo_dbh_t *dbh TSRMLS_DC)
+{
+ return 0 <= dblib_handle_doer(dbh, ZEND_STRL("BEGIN TRAN") TSRMLS_CC);
+}
+
+static int dblib_handle_commit(pdo_dbh_t *dbh TSRMLS_DC)
+{
+ return 0 <= dblib_handle_doer(dbh, ZEND_STRL("COMMIT TRAN") TSRMLS_CC);
+}
+
+static int dblib_handle_rollback(pdo_dbh_t *dbh TSRMLS_DC)
+{
+ return 0 <= dblib_handle_doer(dbh, ZEND_STRL("ROLLBACK TRAN")
TSRMLS_CC);
+}
+
+
static struct pdo_dbh_methods dblib_methods = {
dblib_handle_closer,
dblib_handle_preparer,
dblib_handle_doer,
dblib_handle_quoter,
- NULL,
- NULL,
- NULL,
+ dblib_handle_begin,
+ dblib_handle_commit,
+ dblib_handle_rollback,
NULL,
NULL, /* last insert */
dblib_fetch_error, /* fetch error */
[2009-03-27 04:57:32] sigurdne at online dot no
Description:
Would be nice to support transactions for mssql.
Tried both the precompiled ubuntu packages and custom built from pecl with the
same result:
'This driver doesn't support transactions'
Cutom built:
versions:
* PDO-1.0.3
* PDO_DBLIB-1.0
* FreeTDS 0.82
To allow configure to work:
$ touch /usr/include/tds.h
$ touch /usr/lib/libtds.a
configure:
$ ./configure --with-mssql
Reproduce code:
---
$this->db = new PDO("dblib:host={$this->Host};dbname={$this->Database}",
$this->User, $this->Password, array(PDO::ATTR_PERSISTENT => $persistent));
$this->db->beginTransaction();
Actual result:
--
Error message: 'This driver doesn't support transactions'
--
Edit this bug report at https://bugs.php.net/bug.php?id=58600&edit=1
Bug #55784 [Com]: Missing transaction support in pdo-dblib
Edit report at https://bugs.php.net/bug.php?id=55784&edit=1 ID: 55784 Comment by: programmer at finner dot de Reported by:wrobel at wsb-nlu dot edu dot pl Summary:Missing transaction support in pdo-dblib Status: Closed Type: Bug Package:PDO related PHP Version:5.3.8 Assigned To:ssufficool Block user comment: N Private report: N New Comment: Why isn't this crucial fix mentioned in the changelogs? Previous Comments: [2011-12-01 05:37:37] ssuffic...@php.net Thank you for your bug report. This issue has already been fixed in the latest released version of PHP, which you can download at http://www.php.net/downloads.php Try 5.4 RC2 [2011-09-26 11:15:23] wrobel at wsb-nlu dot edu dot pl Description: Fix to bug #38955 - "add transaction support" was not merged into PHP 5.2 or 5.3 for over a year now! http://svn.php.net/viewvc/?view=revision&revision=300628 -- Edit this bug report at https://bugs.php.net/bug.php?id=55784&edit=1
Req #38955 [Com]: PDO DBLIB driver does not support transactions
Edit report at https://bugs.php.net/bug.php?id=38955&edit=1 ID: 38955 Comment by: programmer at finner dot de 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: After trying PHP 5.4 (which is not yet recommended for production purposes on Debian), I found out, that this bug is obviously fixed, but the fix is not mentioned in the changelogs. Previous Comments: [2012-03-10 09:02:15] programmer at finner dot de Why is this bug closed? The error still persists! I use PHP 5.3.10, and would really need to have transactions, and cannot use another database engine. So, PLEASE!!!, fix this! Thanks in advance. [2011-09-17 14:58:51] vds dot jeroen at gmail dot com Patch should be added to 5.3 branch [2011-05-07 19:11:36] ssuffic...@php.net No developer cares about it, but plenty of users have and do care. I don't use PHP much anymore, but that may change. When it does, I will consider maintaining this in two different places. Until then, the patches are here and the currently working and tested module resides in svn trunk. [2011-04-30 21:19:14] paj...@php.net It is marked as such because nobody cares about it. And before you came in, it should have marked as such in core as well. Anyway, I do it for zip, enchant and planing to do so for more extensions as well. This is a very good way to provide more frequent releases to our users and especially to the distros. [2011-04-30 21:04:23] ssuffic...@php.net I do not see a practical way to PECL this because PDO is already core to PHP and marked depreciated in PECL. The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=38955 -- Edit this bug report at https://bugs.php.net/bug.php?id=38955&edit=1
Bug #46262 [Com]: FreeTDS error.
Edit report at https://bugs.php.net/bug.php?id=46262&edit=1
ID: 46262
Comment by: programmer at finner dot de
Reported by:manohar dot angani at gmail dot com
Summary:FreeTDS error.
Status: No Feedback
Type: Bug
Package:MSSQL related
Operating System: Linux
PHP Version:5.2.6
Block user comment: N
Private report: N
New Comment:
Bug still in 5.4. Assuming, $db is a database object which provides a
connection
via PDO/dblib, try
connect();
$query = $con->prepare("select id from table where param = ?");
while (true) {
$query->bindParam(1, 4711);
$query->execute();
while ($row = $query->fetch(PDO::FETCH_ASSOC) {
(do something with result)
}
}
?>
If you provide different values at $quer->bindParam(), it works OK, also, if
you
prepare the query always new within the while loop. If you reuse the prepared
query with the same parameter as in the loop before, the mentioned error will
occur.
Previous Comments:
[2008-10-21 01:00:00] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[2008-10-14 00:57:04] ka...@php.net
Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves.
A proper reproducing script starts with ,
is max. 10-20 lines long and does not require any external
resources such as databases, etc. If the script requires a
database to demonstrate the issue, please make sure it creates
all necessary tables, stored procedures etc.
Please avoid embedding huge scripts into the report.
[2008-10-09 05:55:29] manohar dot angani at gmail dot com
Description:
We are using freetds .64 and it gives us an error when the same procedure is
invoked twice with the same parameter.
Error: the XML response that was returned from the server is invalid.
Received:
sp_helpconstraint_new mt_cell_pull
passed
Array
(
[0] => 0
[1] => 0
[2] => (null) [0] (severity 0) [(null)]
[3] => 0
[4] => 0
)
1
sp_columns mt_cell_pull
passed
sp_helpconstraint_new mt_dimension_selected
passed
Array
(
[0] => 0
[1] => 0
[2] => (null) [0] (severity 0) [(null)]
[3] => 0
[4] => 0
)
1
sp_columns mt_dimension_selected
passed
sp_helpconstraint_new mt_cell_pull
passed
Array
(
[0] => HY000
[1] => 20019
[2] => Attempt to initiate a new Adaptive Server operation with results
pending [20019] (severity 7) [(null)]
[3] => 0
[4] => 7
[5] => Success
)
1
DBEntidad::DBEntidad - tableInfo without data - Table: mt_cell_pull-Query
Error: Attempt to initiate a new Adaptive Server operation with results pending
[20019] (severity 7) [(null)]
Expected result:
The SQL error is thrown by FreeTDS and it shouldn't throw it.
Actual result:
--
SQL error ..
--
Edit this bug report at https://bugs.php.net/bug.php?id=46262&edit=1
