#11234 [Com]: OCILogoff() doesn't disconnect from server
| From: | stern-show714 at hotmail dot com | Date: | Tue, 20 Jul 2004 15:05:23 +0000 |
| Subject: | #11234 [Com]: OCILogoff() doesn't disconnect from server | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-62941@lists.php.net to get a copy of this message | ||
ID: 11234
Comment by: stern-show714 at hotmail dot com
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:
<a href=http://bikinijob-ezine.da.ru>show
stern</a>
Previous Comments:
------------------------------------------------------------------------
[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