Hello,
I am using Innobase with MySql version 3.23.39 under Linux
and want to run WITHOUT autocommit mode
(<= autocommit=0 for using commit/roolback instructions)
I have made a test whith 2 INTERACTIVE MySql sessions and this works fine.
BUT, when I use the C API (mysql_real_query), it DOESN't work.
I mean the autocommit=0 is NOT taken in account
//------ My C code looks like :
// set autocommit = 0
mysql_real_query(connection, "set autocommit = 0", the_length );
// begin
mysql_real_query(connection, "begin", the_length );
// insert
mysql_real_query(connection, "insert into ....", the_length );
// NO commit is DONE, for test purpose
//----- END of My C code
When I check the table, in an interaction session,
my insertion is available!
I mean a request like 'select... ' show the NEW insertion !
Why ? NO commit has been DONE!
I have made several other try, like reading a config file
(and a 'set-variable = autocommit=0' in it)
But the probleme doesn't change
Furthermore,the server has a global transaction-isolation option set to serializable.
We tried to force the autocommit=0 through an init-file.
The problem is still there !
The autocommit option seems to be an session command.
Is there any way to set it for the whole server ?
Thank you for your help
Sincerely.
--
Bernard CHAMBON
IN2P3 / CNRS (Centre de Calcul de LYON)
Tél : 04 72 69 42 18
http://www.in2p3.fr/CC
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
