Bug #16704 Updated: Screwed up handles while connection multiple DBs
ID: 16704 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: OCI8 related Operating System: Windows 2000 PHP Version: 4.1.2 New Comment: This is not my day. I figured out that the bug is not in php but in my code. So sorry for the time I've wasted and please close the ticket. Previous Comments: [2002-05-01 13:01:36] [EMAIL PROTECTED] Arggh, There was an error in my testscript. Gotta search on :( [2002-05-01 12:59:25] [EMAIL PROTECTED] x [2002-05-01 12:50:20] [EMAIL PROTECTED] I'm happy to report, that I've minimized the problem to one lil script in order to demonstrate it easily. I sent a description and the script to [EMAIL PROTECTED] If someone else needs it - drop a message! [2002-04-23 03:19:57] [EMAIL PROTECTED] Hi, I'll send you a nice testsript tomorrow (European Time). cu [2002-04-22 14:45:55] [EMAIL PROTECTED] please send me a shot _selfcontained_ php script that shows and explains your problem! 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
Bug #16704 Updated: Screwed up handles while connection multiple DBs
ID: 16704 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: OCI8 related Operating System: Windows 2000 PHP Version: 4.1.2 New Comment: Arggh, There was an error in my testscript. Gotta search on :( Previous Comments: [2002-05-01 12:59:25] [EMAIL PROTECTED] x [2002-05-01 12:50:20] [EMAIL PROTECTED] I'm happy to report, that I've minimized the problem to one lil script in order to demonstrate it easily. I sent a description and the script to [EMAIL PROTECTED] If someone else needs it - drop a message! [2002-04-23 03:19:57] [EMAIL PROTECTED] Hi, I'll send you a nice testsript tomorrow (European Time). cu [2002-04-22 14:45:55] [EMAIL PROTECTED] please send me a shot _selfcontained_ php script that shows and explains your problem! [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! 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
Bug #16704 Updated: Screwed up handles while connection multiple DBs
ID: 16704 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Feedback +Status: Open Bug Type: OCI8 related Operating System: Windows 2000 PHP Version: 4.1.2 New Comment: x Previous Comments: [2002-05-01 12:50:20] [EMAIL PROTECTED] I'm happy to report, that I've minimized the problem to one lil script in order to demonstrate it easily. I sent a description and the script to [EMAIL PROTECTED] If someone else needs it - drop a message! [2002-04-23 03:19:57] [EMAIL PROTECTED] Hi, I'll send you a nice testsript tomorrow (European Time). cu [2002-04-22 14:45:55] [EMAIL PROTECTED] please send me a shot _selfcontained_ php script that shows and explains your problem! [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. 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
Bug #16704 Updated: Screwed up handles while connection multiple DBs
ID: 16704 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Feedback Bug Type: OCI8 related Operating System: Windows 2000 PHP Version: 4.1.2 New Comment: I'm happy to report, that I've minimized the problem to one lil script in order to demonstrate it easily. I sent a description and the script to [EMAIL PROTECTED] If someone else needs it - drop a message! Previous Comments: [2002-04-23 03:19:57] [EMAIL PROTECTED] Hi, I'll send you a nice testsript tomorrow (European Time). cu [2002-04-22 14:45:55] [EMAIL PROTECTED] please send me a shot _selfcontained_ php script that shows and explains your problem! [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 ___^ 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
Bug #16704 Updated: Screwed up handles while connection multiple DBs
ID: 16704 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Feedback Bug Type: OCI8 related Operating System: Windows 2000 PHP Version: 4.1.2 New Comment: Hi, I'll send you a nice testsript tomorrow (European Time). cu Previous Comments: [2002-04-22 14:45:55] [EMAIL PROTECTED] please send me a shot _selfcontained_ php script that shows and explains your problem! [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 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
Bug #16704 Updated: Screwed up handles while connection multiple DBs
ID: 16704 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Feedback Bug Type: OCI8 related Operating System: Windows 2000 PHP Version: 4.1.2 New Comment: Bah! Bug in bug report: 5.) echo out connection one $con1 -> you get Resource id # 2 ___^ Previous Comments: [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? [2002-04-20 16:57:15] [EMAIL PROTECTED] Hi, thanx for your fast reply! The true version is 4.0.6. I selected 4.1.2 as there was no better choice. I have an aitional Note: Exactly the same problem existed for Informix AND Mysql: http://bugs.php.net/bug.php?id=15628 The mysql one cane be found also here. I browsed through all OCI8 related bugs but I couldn't find this bug, so I considered it is still existing in 4.1.2. Antoher problem: I also tried to read the changelogs but why the hell are there no changelogs in new releases?? updating of 4.0.2rcx is really risky as it is aproduction environment. Do you think this problem is really gone? [2002-04-19 21:08:12] [EMAIL PROTECTED] Which version is it now? In the Report field you write 4.1.2, but in the body you write 4.0.6 In the latter case, please test a newer version first (even 4.2.0rc4 from php.net/~derick if possible). 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
Bug #16704 Updated: Screwed up handles while connection multiple DBs
ID: 16704
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Status: Feedback
Bug Type: OCI8 related
Operating System: Windows 2000
PHP Version: 4.1.2
New Comment:
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
Previous Comments:
[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?
[2002-04-20 16:57:15] [EMAIL PROTECTED]
Hi, thanx for your fast reply!
The true version is 4.0.6. I selected 4.1.2 as there was no better
choice.
I have an aitional Note: Exactly the same problem existed for Informix
AND Mysql:
http://bugs.php.net/bug.php?id=15628
The mysql one cane be found also here.
I browsed through all OCI8 related bugs but I couldn't find this bug,
so I considered it is still existing in 4.1.2.
Antoher problem: I also tried to read the changelogs but why the hell
are there no changelogs in new releases??
updating of 4.0.2rcx is really risky as it is aproduction environment.
Do you think this problem is really gone?
[2002-04-19 21:08:12] [EMAIL PROTECTED]
Which version is it now? In the Report field you write 4.1.2, but in
the body you write 4.0.6
In the latter case, please test a newer version first (even 4.2.0rc4
from php.net/~derick if possible).
[2002-04-19 15:10:19] [EMAIL PROTECTED]
I would like to report a problem and ask for help with php 4.0.6 and
Oracle 8 Support.
When you try to use more than one connection, the last connection
created is the one that receives every statement.
I found a workaround but I'm not quite sure if it really works
everytime (not enough testing yet):
You could do the following for each connections and somehow they are
available
after that:
for ($i=1; $i <= 2; $i++)
{
$oci_connection_new = OCILogon ($oracle_user, $oracle_pass,
$oracle_inst);
}
I reviewed $oci_connection_new and figured out thata it changes the
recource id after the loop
Thomas
--
Edit this bug report at http://bugs.php.net/?id=16704&edit=1
Bug #16704 Updated: Screwed up handles while connection multiple DBs
ID: 16704
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Status: Feedback
Bug Type: OCI8 related
Operating System: Windows 2000
PHP Version: 4.1.2
New Comment:
Hi, thanx for your fast reply!
The true version is 4.0.6. I selected 4.1.2 as there was no better
choice.
I have an aitional Note: Exactly the same problem existed for Informix
AND Mysql:
http://bugs.php.net/bug.php?id=15628
The mysql one cane be found also here.
I browsed through all OCI8 related bugs but I couldn't find this bug,
so I considered it is still existing in 4.1.2.
Antoher problem: I also tried to read the changelogs but why the hell
are there no changelogs in new releases??
updating of 4.0.2rcx is really risky as it is aproduction environment.
Do you think this problem is really gone?
Previous Comments:
[2002-04-19 21:08:12] [EMAIL PROTECTED]
Which version is it now? In the Report field you write 4.1.2, but in
the body you write 4.0.6
In the latter case, please test a newer version first (even 4.2.0rc4
from php.net/~derick if possible).
[2002-04-19 15:10:19] [EMAIL PROTECTED]
I would like to report a problem and ask for help with php 4.0.6 and
Oracle 8 Support.
When you try to use more than one connection, the last connection
created is the one that receives every statement.
I found a workaround but I'm not quite sure if it really works
everytime (not enough testing yet):
You could do the following for each connections and somehow they are
available
after that:
for ($i=1; $i <= 2; $i++)
{
$oci_connection_new = OCILogon ($oracle_user, $oracle_pass,
$oracle_inst);
}
I reviewed $oci_connection_new and figured out thata it changes the
recource id after the loop
Thomas
--
Edit this bug report at http://bugs.php.net/?id=16704&edit=1
Bug #16704: Screwed up handles while connection multiple DBs
From: [EMAIL PROTECTED]
Operating system: Windows 2000
PHP version: 4.1.2
PHP Bug Type: OCI8 related
Bug description: Screwed up handles while connection multiple DBs
I would like to report a problem and ask for help with php 4.0.6 and Oracle
8 Support.
When you try to use more than one connection, the last connection
created is the one that receives every statement.
I found a workaround but I'm not quite sure if it really works everytime
(not enough testing yet):
You could do the following for each connections and somehow they are
available
after that:
for ($i=1; $i <= 2; $i++)
{
$oci_connection_new = OCILogon ($oracle_user, $oracle_pass,
$oracle_inst);
}
I reviewed $oci_connection_new and figured out thata it changes the
recource id after the loop
Thomas
--
Edit bug report at http://bugs.php.net/?id=16704&edit=1
--
Fixed in CVS:http://bugs.php.net/fix.php?id=16704&r=fixedcvs
Fixed in release:http://bugs.php.net/fix.php?id=16704&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=16704&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=16704&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=16704&r=support
Expected behavior: http://bugs.php.net/fix.php?id=16704&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=16704&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=16704&r=submittedtwice
Bug #15628 Updated: Multiple Connections not allowed
ID: 15628 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: Informix related Operating System: SunSolaris 8 Sparc PHP Version: 4.1.1 New Comment: I have the exactly same problem with Oracle!!! Previous Comments: [2002-02-22 12:25:42] [EMAIL PROTECTED], [EMAIL PROTECTED] Some information: SO - Red Hat 7.1 kernel 2.2.12 The file to be edited is ext/informix/ifx.ec [2002-02-22 12:22:36] [EMAIL PROTECTED], [EMAIL PROTECTED] we´ve found the same bug. This solution worked very well! Thanks! [2002-02-19 14:29:36] [EMAIL PROTECTED] Hi, I would like to report a bug in the Informix module of PHP 4.1.1. When you try to use more than one connection, the last connection created is the one that receives every statement, and under this circumstances you may get a SQLCODE error code -206 when calling ifx_query as the table may not exist in the current database. I was debugging the Informix implementation and I found that in the function ifx_query the following statement is missing: EXEC SQL set connection :ifx; before the call of the macro PHP_IFX_CHECK_CONNECTION and the call to the PREPARE statement. If you add that statement, the funcion ifx_query works fine. This function call is needed as every time that you execute the statement CONNECT TO ... that connection is the active one and the former connections become dormant. When you want to use one of those connection, you need to active it again using the statement SET CONNECTION. I hope this helps. -- Edit this bug report at http://bugs.php.net/?id=15628&edit=1
