Hi all,
I am using torque with mysql 4.0.13 with IDmethod= IDBroker
Usualy it works just fine ..but the following test fails somewhen:
/* MASS TEST */
for (int i=0;i<1000000;i++) {
User temp = new User();
temp.setLoginName("user"+String.valueOf(i));
temp.setPassword(temp.getLoginName());
temp.save();
}
I try to mass generate 1,000,000 User objects into db.
but on the 37,416 th iteration mysql jdbc driver says:
Duplicate entry for ..bla bla bla .....the id of the table has duplicated
then again on 6x,xxx th iteration...than on again 9x,xxx ..
I think that in that version of the mysql server thera are transactions available
(torque does not warn me for an absence of transactional support for the db, so i
believe my server has transactions)
I do not want to debug torque's code ..or neither to change it ...could somebody give
me a hint ..what
may be the reason leading to this?
This problem occurs only in this MASS test ...for now ...
Thanks in advance
Bogdan