InnoDB Transaction,Commit,Rollback

[Plutarco Gonzalez]

Hi Everybody,

I have a application with invoice and invoice_items, but i need used transaction to save records.

If only user save data this fine. But if two users save data same time, one users save correctly and another user go to rollback directly, if second user save data again this ok.

InnodBd Documentation have a timeOut transaction = 50 Secs.
But, the application save all records in about 2 secs.

The sintax is the next:

try
myInnoDB.StartTransaction;
...
Insert, update, deletion records
...
myInnoDB.Commit;
except
myInnoDB.Rollback;
Showmessage('Table busy');
end;


Question:
¿ InnoDB transaction must be wait to another transaction ?
¿ What is wrong?

InnodB start up options = = = =

innodb_data_file_path = ibdata1:10M:autoextend
innodb_buffer_pool_size = 256M
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 64M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 120

- Settings -
Netware 6.0 SP5 (HD:70 GB/RAM:768 MB) Mysql 4.0.21 and InnoDB Tables
Borland Delphi 6.0 with MySQLDAC.



Any comments are Welcome,


Thx and regards

Plutarco G.