Re: persistent database connections with OCI

From: Date: Sun, 06 Aug 2000 09:57:19 +0000
Subject: Re: persistent database connections with OCI
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-10315@lists.php.net to get a copy of this message
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. >Do I have to free any resources ? You should. >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 --

« previous php.general (#10315) next »