Return to drcp_connect1.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / oci8 / tests

Annotation of embedaddon/php/ext/oci8/tests/drcp_connect1.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: DRCP: oci_connect()
                      3: --SKIPIF--
                      4: <?php
                      5: $target_dbs = array('oracledb' => true, 'timesten' => false);  // test runs on these DBs (Calling PL/SQL from SQL is not supported in TimesTen)
                      6: require(dirname(__FILE__).'/skipif.inc');
                      7: ?> 
                      8: --INI--
                      9: oci8.connection_class=test
                     10: oci8.old_oci_close_semantics=0
                     11: --FILE--
                     12: <?php
                     13: 
                     14: require dirname(__FILE__)."/details.inc";
                     15: require dirname(__FILE__)."/drcp_functions.inc";
                     16: 
                     17: // Open a number of connections with oci_connect and oci_pconnect and verify
                     18: // whether we get a used session with DRCP.
                     19: // To verify this, we change the value of a PL/SQL package variable in one
                     20: // session and query for this through another connection
                     21: 
                     22: echo "Test 1a\n";
                     23: var_dump($conn1 = oci_connect($user,$password,$dbase));
                     24: // Create the package
                     25: drcp_create_package($conn1);
                     26: 
                     27: echo "Test 1b\n";     
                     28: // OCI_CONNECT
                     29: echo " This is with OCI_CONNECT.....\n";
                     30: drcp_select_packagevar($conn1); // Returns 0
                     31: drcp_set_packagevar($conn1,1000);
                     32: oci_close($conn1);
                     33: echo " Connection conn1  closed....\n";
                     34: 
                     35: echo "Test 2\n";
                     36: // Second connection should return 0 for the package variable.
                     37: var_dump($conn2 = oci_connect($user,$password,$dbase));
                     38: echo " Select with connection 2 \n";
                     39: drcp_select_packagevar($conn2); // Returns 0
                     40: drcp_set_packagevar($conn2,100);
                     41: 
                     42: echo "Test 3\n";
                     43: // Third connection. There is no oci_close() for conn2 hence this should
                     44: // return the value set by conn2.
                     45: var_dump($conn3 = oci_connect($user,$password,$dbase));
                     46: echo " Select with connection 3 \n";
                     47: drcp_select_packagevar($conn3); // Returns 100
                     48: 
                     49: // Close all the connections
                     50: oci_close($conn2);
                     51: oci_close($conn3);
                     52: 
                     53: echo "Test 4\n";
                     54: // OCI_PCONNECT
                     55: echo " This is with oci_pconnect().....\n";
                     56: var_dump($pconn1 = oci_pconnect($user,$password,$dbase));
                     57: drcp_set_packagevar($pconn1,1000);
                     58: oci_close($pconn1);
                     59: echo " Connection pconn1  closed....\n";
                     60: 
                     61: // Second connection with oci_pconnect should return the same session hence the
                     62: // value returned is what is set by pconn1
                     63: 
                     64: echo "Test 5\n";
                     65: var_dump($pconn2 = oci_pconnect($user,$password,$dbase));
                     66: echo " Select with persistent connection 2 \n";
                     67: drcp_select_packagevar($pconn2); // Returns 1000
                     68: oci_close($pconn2);
                     69: 
                     70: echo "Done\n";
                     71: 
                     72: ?>
                     73: --EXPECTF--
                     74: Test 1a
                     75: resource(%d) of type (oci8 connection)
                     76: Test 1b
                     77:  This is with OCI_CONNECT.....
                     78:  The value of the package variable is 0
                     79:  Package variable value set to 1000
                     80:  Connection conn1  closed....
                     81: Test 2
                     82: resource(%d) of type (oci8 connection)
                     83:  Select with connection 2 
                     84:  The value of the package variable is 0
                     85:  Package variable value set to 100
                     86: Test 3
                     87: resource(%d) of type (oci8 connection)
                     88:  Select with connection 3 
                     89:  The value of the package variable is 100
                     90: Test 4
                     91:  This is with oci_pconnect().....
                     92: resource(%d) of type (oci8 persistent connection)
                     93:  Package variable value set to 1000
                     94:  Connection pconn1  closed....
                     95: Test 5
                     96: resource(%d) of type (oci8 persistent connection)
                     97:  Select with persistent connection 2 
                     98:  The value of the package variable is 1000
                     99: Done
                    100: