Subject | Re: [firebird-php] PHP and transactions |
---|---|
Author | Cesar L. Meloni |
Post date | 2005-08-06T21:43:21Z |
Hi all:
I have developed my own library of access to data bases.
Its very simple, powerfull, fast and very ligth.
Support Firebird, Interbase, Oracle, DB2, MSSql, Postgresql, ODBC and
MySQL...
Can handle transactions, exec direct and prepare statement in order to
make simple bind of parameters. And have methods to insert and get blobs
common at all databases.
Download from http://www.interwan.com.ar/dblib_1.0_20050805.tar.gz
So far I recommend that it is used only with FB/IB, Oracle, DB2 and
MySQL since I have been able them to test in production.
I hope that he is to them util.
Cesar L. Meloni
Alan McDonald escribió:
I have developed my own library of access to data bases.
Its very simple, powerfull, fast and very ligth.
Support Firebird, Interbase, Oracle, DB2, MSSql, Postgresql, ODBC and
MySQL...
Can handle transactions, exec direct and prepare statement in order to
make simple bind of parameters. And have methods to insert and get blobs
common at all databases.
Download from http://www.interwan.com.ar/dblib_1.0_20050805.tar.gz
So far I recommend that it is used only with FB/IB, Oracle, DB2 and
MySQL since I have been able them to test in production.
I hope that he is to them util.
Cesar L. Meloni
Alan McDonald escribió:
>>Alan McDonald wrote:
>>
>>
>>
>>>>ADOdb!
>>>>Someone had simply disabled transactions altogether to get things
>>>>to work ;)
>>>>This has a StartTrans() and CompleteTrans() which work very nicely in
>>>>wrapping the transaction (and 'emulating' transactions where the
>>>>database does not support them), and switching the query to use the
>>>>transactionID. In fact everything works nicely - except that the
>>>>original default Transaction does not see any changes made in the inner
>>>>transactions.
>>>>I have a fix for the immediate problem, which is just to read the new
>>>>data before completing the transaction, but it seems that there IS
>>>>something missing by way of a 'Refresh', which I can emulate by closing
>>>>and re-opening the connection :(
>>>>
>>>>--
>>>>Lester Caine
>>>>
>>>>
>>>hmmm, ezSQL doesn't have this problem :-)
>>>
>>>
>>So how does it get round it?
>>The 'problem' is with the ibase_ transactions ;)
>>
>>--
>>Lester Caine
>>-----------------------------
>>L.S.Caine Electronic Services
>>
>>
>
>it doesn't start transactions of it's own - only the default one. You can
>start a none default one yourself and you can commit the default one where
>you like.
>Sounds like ADOdb is not using the default trans at all.
>Alan
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>