#31222 [Opn->Asn]: ocicommit not working

From: Date: Mon, 04 Apr 2005 23:25:40 +0000
Subject: #31222 [Opn->Asn]: ocicommit not working
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-76817@lists.php.net to get a copy of this message
 ID:               31222
 Updated by:       sniper@php.net
 Reported By:      amonw at hotmail dot com
-Status:           Open
+Status:           Assigned
 Bug Type:         OCI8 related
 Operating System: *
 PHP Version:      4CVS-2005-04-04
 Assigned To:      tony2001
 New Comment:

Back to Antony



Previous Comments:
------------------------------------------------------------------------

[2005-04-04 09:27:40] amonw at hotmail dot com

I tried the http://snaps.php.net/php4-STABLE-latest.tar.gz,which
extracted to be php4-STABLE-200504040230,but the code produced the same
result.

------------------------------------------------------------------------

[2005-03-30 23:06:56] tony2001@php.net

Please try using this CVS snapshot:

  http://snaps.php.net/php4-STABLE-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-STABLE-latest.zip



------------------------------------------------------------------------

[2004-12-24 03:08:50] amonw at hotmail dot com

Thank you for your help.
But can you explain why the 4 methods I listed in the first comment can
change the result? 
And why can't I add "ocilogoff($c)" before the second ocilogon to
change the result?

------------------------------------------------------------------------

[2004-12-23 18:16:12] tony2001@php.net

You need to use ocinlogon() in this case, because you have 2 similar
connections (which are indeed ONE connection) messing around. One of
these connections still needs commit and gets  rollback'ed at the end
of the script execution and one of them doesn't. So, this is quite
expected.

There is another problem: this issue doesn't exist in PHP5
ocilogon()/oci_connect() because behaves similar to
ocinlogon()/oci_new_connect() and returns exclusive connection
descriptor. 
This is not the intended behaviour and I'll investigate who and why
changed it.

------------------------------------------------------------------------

[2004-12-23 13:26:48] amonw at hotmail dot com

Just in case, did you receive my email with a test account? I sent it
about 8 hours ago.

------------------------------------------------------------------------

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/31222

-- 
Edit this bug report at http://bugs.php.net/?id=31222&edit=1


Thread (28 messages)

« previous php.bugs (#76817) next »