Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: RE: IDBroker broken ?
Date: Thu, 11 Dec 2003 10:06:30 +0100
Message-ID: <90B3A0967470D44CB8FDE74907512328F1CDE3@av1s008.at-work.local>
Thread-Topic: IDBroker broken ?
Thread-Index: AcO/xPxuh0TIFkYJRYmDGFPSfJQEQQAAE7uQ
From: =?iso-8859-1?Q?=22G=F6schl=2CSiegfried=22?= <Siegfried.Goeschl@drei.com>
To: "Apache Torque Users List" <torque-user@db.apache.org>

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:bvatkov@globaltech-bg.com]
Sent: Thursday, December 11, 2003 9:59 AM
To: torque-user@db.apache.org
Subject: IDBroker broken ?


Hi all,
I am using torque with mysql 4.0.13 with IDmethod=3D IDBroker

Usualy it works just fine ..but the following test fails somewhen:

            /*   MASS TEST */
            for (int i=3D0;i<1000000;i++) {
              User temp =3D 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.=20
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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org