Re: [PDO] PDO transaction isolation level and firebird

Ok, I submitted patch to bug #63105 https://bugs.php.net/bug.php?id=63105 2013/9/20 Stanley Sufficool <ssufficool@gmail.com> > Well, you see, someone actually sat down and thought for awhile before > implementing the Java database classes. You are free to browse the PDO code > and familiarize yourself with the design. Unfortunately, there is much > undocumented and few standards for how drivers and statements should > behave. > > This list however is mostly dead and you may not find much help here. > > Come up with a proposal on what you would like to implement and the > patches to do it. Have it reviewed by the community and it may be committed. > > Good luck :) > > > On Tue, Sep 17, 2013 at 11:25 AM, Vjacheslav V. Borisov <slavb18@gmail.com > > wrote: > >> Hi! >> >> Does any body interested in development of pdo_firebird extension? >> A long time ago in a galaxy far, far away Ard Biesheuvel committed to pdo >> >> http://marc.info/?l=pecl-cvs&**m=108730900103295<http://marc.info/?l=pecl-cvs&m=108730900103295> >> code to manage transaction params >> This block is disabled by #if abies_0, there is also no constants defined >> it uses. >> I want to realise this functional and have some questions, how should i >> do it. >> >> 1) There is hard, but may be usable in future by other drivers way >> PDO class should have functions like in Java (http://docs.oracle.com/** >> javase/7/docs/api/java/sql/**Connection.html<-Dßú~è
.K >> Kb?SÏhttp://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html> >> ): >> setReadonly/getReadonly (set/get read-only mode as a hint to the driver >> to enable database optimizations.) >> >> setTransactionIsolation/**getTransactionIsolation (set/get transaction >> isolation level TRANSACTION_READ_UNCOMMITTED/** >> TRANSACTION_READ_COMMITTED/**TRANSACTION_REPEATABLE_READ/** >> TRANSACTION_SERIALIZABLE >> >> setConflictResolution/**getConflictResolution (PDO_TRANS_RETRY/PDO_TRANS_ >> **ABORT) - there is no java equivalent, don't know how to name it >> >> 2) Or, istead of writing new functions, should I use >> setAttribute/getAttribute ? >> In this case where should I define constants in pdo or in pdo_firebird >> extension? >> >> 3) Or, istead of cross-driver constants should I define constans like >> interbase etension does: >> /* transaction access mode */ >> PHP_IBASE_WRITE = 1, >> PHP_IBASE_READ = 2, >> /* transaction isolation level */ >> PHP_IBASE_CONCURRENCY = 4, >> PHP_IBASE_COMMITTED = 8, >> PHP_IBASE_REC_NO_VERSION = 32, >> PHP_IBASE_REC_VERSION = 64, >> PHP_IBASE_CONSISTENCY = 16, >> /* transaction lock resolution */ >> PHP_IBASE_WAIT = 128, >> PHP_IBASE_NOWAIT = 256 >> >> >> >> -- >> PDO Working Group Mailing List (http://pdo.php.net) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> >