Req #63105 [Com]: Default transanction isolation level in PHP for Firebird in php.ini

From:	slavb18 at gmail dot com	Date:	Wed, 25 Sep 2013 04:59:36 +0000
Subject:	Req #63105 [Com]: Default transanction isolation level in PHP for Firebird in php.ini
References:	1	Groups:	php.bugs
Request:	Send a blank email to php-bugs+get-181766@lists.php.net to get a copy of this message

Edit report at https://bugs.php.net/bug.php?id=63105&edit=1

 ID:                 63105
 Comment by:         slavb18 at gmail dot com
 Reported by:        mariuz@php.net
 Summary:            Default transanction isolation level in PHP for
                     Firebird in php.ini
 Status:             Assigned
 Type:               Feature/Change Request
 Package:            InterBase related
 Operating System:   All
 PHP Version:        Irrelevant
 Assigned To:        mariuz
 Block user comment: N
 Private report:     N

 New Comment:

examples: 
$pdo->setAttribute(PDO::ATTR_READONLY, FALSE); // read-write transaction (Default)
$pdo->setAttribute(PDO::ATTR_READONLY, TRUE); // readonly transaction


$pdo->setAttribute(PDO::ATTR_TIMEOUT, 0); // no_wait
$pdo->setAttribute(PDO::ATTR_TIMEOUT, -1); // wait 
$pdo->setAttribute(PDO::ATTR_TIMEOUT, 4); // wait timeout 4 seconds

$pdo->setAttribute(PDO::FB_TRANS_ISOLATION_LEVEL, PDO::FB_TRANS_COMMITTED); //read committed
(default)

... etc FB_TRANS_COMMITTED_NO_REC_VERSION, FB_TRANS_CONCURRENCY, FB_TRANS_CONCURRENCY


Previous Comments:
------------------------------------------------------------------------
[2012-09-18 07:52:40] mariuz@php.net

Discussion on firebird php list 


http://tech.groups.yahoo.com/group/firebird-php/message/3758

------------------------------------------------------------------------
[2012-09-18 07:18:47] mariuz@php.net

Description:
------------
 If you start a new transaction (or if one is started internally, where you 
cannot change the isolation level) where you don’t explicitly specify isolation 
level the IBASE_DEFAULT is used. But this is 
IBASE_WRITE|IBASE_CONCURRENCY|IBASE_WAIT. This is read-write wait transaction in 
concurrency mode. This mode is most restrictive, nothing close to read committed. 
And to make it worse, there’s no way to change this default value in runtime. You 
can only do it recompiling sources, nothing to be viable in most cases.

http://blog.cincura.net/233007-default-transanction-isolation-level-in-php-for-
firebird/



------------------------------------------------------------------------



-- 
Edit this bug report at https://bugs.php.net/bug.php?id=63105&edit=1


   

Thread (6 messages)

• mariuz@php.netTue, 18 Sep 2012 07:18:47 +0000
  • mariuz@php.netTue, 18 Sep 2012 07:52:40 +0000Req #63105 [Com]: Default transanction isolation level in PHP for Firebird in php.ini
  • slavb18 at gmail dot comWed, 25 Sep 2013 04:59:36 +0000Req #63105 [Com]: Default transanction isolation level in PHP for Firebird in php.ini
  • ssufficool@php.netThu, 26 Sep 2013 05:16:52 +0000Req #63105 [Com]: Default transanction isolation level in PHP for Firebird in php.ini
  • kalle@php.netTue, 24 Oct 2017 06:45:52 +0000Req #63105 [Asn->Opn]: Default transanction isolation level in PHP for Firebird in php.ini
  • cmb@php.netWed, 31 Mar 2021 11:36:57 +0000Req #63105 [Opn->Sus]: Default transanction isolation level in PHP for Firebird in php.ini