Hi Bogdan, +) If you are using transactions or not is defined the SQL script creating your DB - something such as "USE IMNODB" at the end of the table definition. +) Is this behaviour reproducable, e.g. always fails for the same ID generated by the IDBroker?!
Cheers, Siegfried Goeschl -----Original Message----- From: Bogdan Vatkov [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 9:59 AM To: [EMAIL PROTECTED] Subject: IDBroker broken ? 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 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
