Subject | Transaction over multiple connection |
---|---|
Author | Anatol Ogórek |
Post date | 2004-12-01T18:31:53Z |
Hello
I would like to start transaction over multple connections:
So I coded it like this:
$host = 'localhost:/opt/firebird/invoice.gdb';
$username = 'SYSDBA';
$password ='masterkey';
$dbh = ibase_connect($host, $username, $password);
$dbh2 = ibase_connect('localhost:/opt/firebird/invoice.gdb',
$username, $password);
if (!$dbh) die ("error connecting to database");
$tr = ibase_trans( IBASE_COMMIT, $dbh, IBASE_COMMIT,$dbh2);
But how should I call a query?
I call it like this:
$sth = ibase_query($tr, $query);
and I got warning;
*Warning*: ibase_query() [function.ibase-query
<http://localhost/function.ibase-query>]: Link id is ambiguous:
transaction spans multiple connections. in
*/usr/local/apache2/htdocs/connect.php* on line *19
*Can You help me?
Thanks
Anatol
*
*
I would like to start transaction over multple connections:
So I coded it like this:
$host = 'localhost:/opt/firebird/invoice.gdb';
$username = 'SYSDBA';
$password ='masterkey';
$dbh = ibase_connect($host, $username, $password);
$dbh2 = ibase_connect('localhost:/opt/firebird/invoice.gdb',
$username, $password);
if (!$dbh) die ("error connecting to database");
$tr = ibase_trans( IBASE_COMMIT, $dbh, IBASE_COMMIT,$dbh2);
But how should I call a query?
I call it like this:
$sth = ibase_query($tr, $query);
and I got warning;
*Warning*: ibase_query() [function.ibase-query
<http://localhost/function.ibase-query>]: Link id is ambiguous:
transaction spans multiple connections. in
*/usr/local/apache2/htdocs/connect.php* on line *19
*Can You help me?
Thanks
Anatol
*
*