Re: [PHP4BETA] OCINLogon/OCILogoff leaves open sessions

On Wed, Mar 01, 2000 at 06:28:35PM -0800, php@home.uh.nu wrote: > Howdy, > I'm doing some testing with the latest cvs of php4 and have found an icky > problem with sessions being left open in oracle. > The script below is my source I'm using to create the problem. > It seems that it calling OCILogOff doesn't clean up oracle sessions > in the database. So if I run this script 250 times I eventually run out > of available sessions and have to restart oracle. I'm running in apache on > a linux box, and my oracle instance is over the network on a solaris box > running 8.0.5 > > <html> > <? > $connection = OCINLogon("user","passwd","db"); > echo "connection = $connection<br>\n"; > OCILogOff($connection); > ?> > Hello World. > To continue, <A HREF="test.php">click here</A><br> > </html> there's a problem in current PHP4 that is related to releasing sessions created via OCINLogon. this is going to be fixed before 4.0final - ocilogon and ociplogon work - do you really need ocinlogon in your script (it's slow!)? anyhow, i'll try to fix it soon! tc > > > Walt > > -- > PHP 4.0 Beta Mailing List <http://www.php.net/version4/> > To unsubscribe, e-mail: php4beta-unsubscribe@lists.php.net > For additional commands, e-mail: php4beta-help@lists.php.net > To contact the list administrators, e-mail: php4beta-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