Limit of transactions without commit

[imanol muñoz pandiella]

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.