MySQL Forums
Forum List  »  Connector/C++

Limit of transactions without commit
Posted by: imanol muñoz pandiella
Date: October 26, 2009 07:26AM

Hello! does anybody know if exist a maximum number of transactions to do before commit?

My problem is the next: i am using the c++ conector to make transactions to a mysql db. I have disabled the auto commit function using:

/* Create a connection */
_driver = get_driver_instance();
_con = _driver->connect(_host,_usuari,_contrasenya);
_con->setAutoCommit(false);

During the execution of the problem i have to make over 10.000 insert's to the db without making commit... The problem, is that i have seen than when over 20 inserts are made they are in the bd, and although i make rollback they persist in the bd...

Anybody can help me?

Thanks!

Imanol.

Options: ReplyQuote


Subject
Views
Written By
Posted
Limit of transactions without commit
4952
October 26, 2009 07:26AM
2144
October 26, 2009 07:30AM
2052
November 02, 2009 12:18PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.