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

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!


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

[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

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

[2002-04-20 17:35:06] [EMAIL PROTECTED]

Can't comment on "if it's gone".

Do you mean that in all connection you establish you use the same
username/passwort/host (or sid) in your context?

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

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