ID:               16704
 Updated by:       [EMAIL PROTECTED]
 Reported By:      [EMAIL PROTECTED]
-Status:           Closed
+Status:           Feedback
 Bug Type:         OCI8 related
 Operating System: Windows 2000
 PHP Version:      4.1.2
 New Comment:

please send me a shot _selfcontained_ php script that 
shows and explains your problem! 
 


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

[2002-04-22 14:06:13] [EMAIL PROTECTED]

I also tried OCINLogon, but there was no difference.

Addition: As the documentation implies: it should be no problem for any
OCI*logon function to make more than one connections!

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

[2002-04-22 13:55:31] [EMAIL PROTECTED]

 use OCINlogon to force session isolation. 
 

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

[2002-04-22 13:53:13] [EMAIL PROTECTED]

Bah! Bug in bug report:

5.) echo out connection one $con1 -> you get Resource id # 2
                                                    _______^

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

[2002-04-22 11:55:47] [EMAIL PROTECTED]

Update:

One piece of information was wrong: I use always the same instance/SID
name. But now I've even tried to create a alias for my instance that
both conns get a different instance without success.

After digging deeper into the problem I've figured out a really easy
way to see the bug:

1.) Create connection one $con1
2.) echo it out echo $con1 -> you get Resource id # 1
3.) Create connection two $con2
4.) echo it out echo $con2 -> you get Resource id # 2
5.) echo out connection one $con1 -> you get Resource id # 1

You see even the connection handles reflect the reality.

cu

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

[2002-04-21 07:37:11] [EMAIL PROTECTED]

Hi,

Well thats an important point with the connections, I forgot it -
sorry.

I'm using for each connection a different username, password and
instance/sid.
The aim is to have during each script-run two connections. I call a
function which generates a $oci_connection and $oci_connection_adm at
the beginning of each script. Both connections are used several times
and at the end of the script a logoff on both is commited.

If I do not the workaround that I've described, PHP isn't capable of
distinguish between both conns - tha last one 'wins'.

If we had a changelog, we could review if there were any cchanges
regarding the oci stuff between 4.0.6 and 4.1.2!

cu

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

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

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

Reply via email to