#11234 [Bgs]: OCILogoff() doesn't disconnect from server
| From: | tony2001@php.net | Date: | Wed, 21 Jul 2004 08:12:53 +0000 |
| Subject: | #11234 [Bgs]: OCILogoff() doesn't disconnect from server | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-63216@lists.php.net to get a copy of this message | ||
ID: 11234
Updated by: tony2001@php.net
Reported By: worawisu at loxinfo dot co dot th
Status: Bogus
Bug Type: OCI8 related
Operating System: Linux Redhat 6.2 (kernel 2.2.14)
PHP Version: 4.0.5
New Comment:
OCILogoff() does nothing at the moment, leaving this responsibility to
the Oracle server, which should close connections automagically after
the expiration of a timeout.
So you just need to set an appropriate settings and Oracle will do it
for you.
Previous Comments:
------------------------------------------------------------------------
[2004-07-21 10:04:30] katiakreol at yahoo dot fr
Hi
I have got the same problem!! Ocilogoff does not disconnect!
I absolutely have to use ociplogon and it is very annoying to be unable
to disconnect! There has to be a solution please help!!
------------------------------------------------------------------------
[2001-06-03 22:02:37] worawisu at loxinfo dot co dot th
But the problem still when using OCILogon() too with the very simple
code.(I just try every Logon function of OCI. When try each one and
Monitor the session status (from v$session view using Oracle Sql+).
<?php
include("db_config.php");
$conn=OCILogon($User,$Password,$Database);
print "Connection1 = $conn <br>\n";
OCILogoff($conn);
print "Connection2= $conn <br>\n";
?>
Reqard.
------------------------------------------------------------------------
[2001-06-01 11:05:58] sniper@php.net
Well, OCIplogon() opens a PERSISTANT connection.
Use ocilogon() instead.
------------------------------------------------------------------------
[2001-06-01 06:43:01] worawisu at loxinfo dot co dot th
I use OCIPLogon() function to log on to oracle dbms. And when i 'd like
to quit i use OCILogoff(). But the db session also still (don't log off)
.
this is my script:
<?php
$conn=OCIPLogon($usr,$passwd,$host) or die("Cannot Logon to Database
Server");
$sql="select * from my_table ";
$stmt=OCIParse($conn,$sql);
echo "Connection ID 1 = $conn <br>\n";
OCIFreeStatement($stmt);
OCILogoff($conn);
echo "Connection ID 2 = $conn <br>\n";
?>
The result of "Connection ID 1 and 2" is "Resource id #1 ";
(If Session in oracle was ended i think Connection ID 2 must be null
value not "Resource id #1" )
This problem still in PHP 4.0.5 (with apache 1.3.20)
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=11234&edit=1