#9496 [Com]: Mixing non persistant and persistant connection makes all connexions persistant

ID: 9496 Comment by: kamil at okac dot org Reported By: jean-francois dot gosset at telintrans dot fr Status: No Feedback Bug Type: OCI8 related Operating System: linux red hat 6.2 PHP Version: 4.0.4pl1 New Comment: The bug seems to be a duplicate of #22674. http://bugs.php.net/bug.php?id=22674 Previous Comments: ------------------------------------------------------------------------ [2003-12-28 22:00:51] eru@php.net No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Open". Thank you. ------------------------------------------------------------------------ [2003-12-19 02:29:13] tony2001@php.net Could you, please, try it with latest CVS snapshots of PHP5 & PHP4? This behaviour was changed in PHP5 recently. ------------------------------------------------------------------------ [2003-12-18 17:14:41] kamil at okac dot org The behaviour is correct for the case when you call OCILogon('u1','p1') and OCIPLogon('u1','p1') (with the same user), but incorrect when you call OCILogon('u1','p1') and OCIPlogon('u2','p2'). The latter case creates two sessions (that's correct - can't be shared, because two different users are logging in), but both sessions are made persistent. This happens even if OCIPlogon and OCILogon are not called within one script but handled by the same process. Maybe the problem is in the reusing of persistent server connections (where usernames are not involved). ------------------------------------------------------------------------ [2002-04-13 08:18:07] thies@php.net i still cannot see any problem. you approach would consume _more_ resourcs on the oracle server. anyhow this is not a bug. ------------------------------------------------------------------------ [2001-06-15 03:53:55] jean-francois dot gosset at telintrans dot fr I think this behaviour is confusing. One can have the needs to mix persistant and non persistant connexion on the same database. In my case, I want to validate an account with a personal username and after use a generic account. The first one must not be persistant because we would have too much connexions open. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/9496 -- Edit this bug report at http://bugs.php.net/?id=9496&edit=1