Re: persistent database connections with OCI

On Sun, Aug 06, 2000 at 06:57:19AM -0300, Manuel Lemos wrote: > Hello Christian, > > On 06-Aug-00 06:00:54, you wrote: > > >I intend to use persistent database connections with OCI. What happens at > >the end of the script ? > > Nothing. > > > >Is there a implicit commit or even rollback ? Do I have to code a commit for > >this reason ? > > You should never leave a script without ending opened transactions if you use > persistent connections with PHP as Web server module. While the connection > is kept opened data is left uncommitted and the database server keeps > implicit locks, eventually stalling other database accesses. no longer true. NEWS: - Uncommitted outstanding OCI8 transactions are now rolled back before the connection is closed. (Thies) > > > >Do I have to free any resources ? > > You should. but don't have to - wonderful world of automatic resource deallocation! > > > >What does it mean if I code a OCILogoff ? > > Nothing because the connection is never really closed until the Web server > process ends. > > > Regards, > Manuel Lemos > > Web Programming Components using PHP Classes. > Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org > -- > E-mail: mlemos@acm.org > URL: http://www.mlemos.e-na.net/ > PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp > -- > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" Digital Collections Phone +49 40 235350 Fax +49 40 23535180 Hammerbrookstr. 93 20097 Hamburg / Germany