You don't have to do it on each table (unless you want to), just set the defaultIdMethod="native" attribute in the database tag.
I think that this may also solve the ID_TABLE problem because Torque may think it needs it for some tables and still be doing some "accounting" and this is causing the ID_TABLE to be incremented. > -----Original Message----- > From: "[EMAIL PROTECTED]" [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 12, 2006 12:12 PM > To: torque-user > Subject: Re: Torque id broker > > > Last question... > > To use the vendor-specific autogenerated ids (mysql > auto-incremented id), I ve set all my tables using 'native' > as value for the property 'idMethod'. Should I do the same in > id-table-schema.xml and in particular for ID_TABLE? I ve also > add the property autoIncrement=true for field that should be > 'auto incremented' > > Is that enough to make it work? I did the changes but the > weird thing is that ID_TABLE still moving > > Many thanks, > Thomas > > ---------- Initial Header ----------- > > From : Thomas Fischer <[EMAIL PROTECTED]> > To : "Apache Torque Users List" <[email protected]> > Cc : > Date : Wed, 12 Apr 2006 10:09:42 +0200 > Subject : Re: Torque id broker > > The only advantage is that it is portable across databases. > If you have the possibility to use vendor-specific > autogenerated ids, my advice would be to use them instead of > the idbroker. > > Thomas > > "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> schrieb am > 12.04.2006 > 00:00:27: > > > Bonjour! > > > > First of all, my name is thomas, 26, living in Paris and I am very > > happy and exciting joining this mailing list! > > > > I first start using scarab. From there, I was very interrested on > > turbine framework and now torque. I have a fair > understanding of this > > but some > points > > still seems to be 'obscure'. > > > > In particular on the ID Broker, I would like to know the advantages > > using this instead of 'db vendor' auto generated id. (In > 'id_table', > > what is the > interest > > having an 'id' incremented by the value specified in colomn > 'Quantity' > and > > why not just 1 ?) > > > > Many thanks in advance for your help! > > Thomas > > > > -------------- ALICE HAUT DEBIT : TRIPLE PLAY A 29,95 EUR/MOIS > -------------- > > Découvrez vite ALICEBOX : avec le modem WIFI, profitez de > l'ADSL, de > > la TELEPHONIE et en exclusivité de la TELEVISION ! > Bénéficiez aussi de > > la hotline gratuite 24h/24 ! Soumis à conditions. Pour en profiter > > cliquez ici http://abonnement.aliceadsl.fr > > > > > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > -------------- ALICE HAUT DEBIT : TRIPLE PLAY A 29,95 > EUR/MOIS -------------- > Découvrez vite ALICEBOX : avec le modem WIFI, profitez de > l'ADSL, de la TELEPHONIE et en exclusivité de la TELEVISION ! > Bénéficiez aussi de la hotline gratuite 24h/24 ! Soumis à > conditions. Pour en profiter cliquez ici > http://abonnement.aliceadsl.fr > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > Duke CE Privacy Statement Please be advised that this e-mail and any files transmitted with it are confidential communication or may otherwise be privileged or confidential and are intended solely for the individual or entity to whom they are addressed. If you are not the intended recipient you may not rely on the contents of this email or any attachments, and we ask that you please not read, copy or retransmit this communication, but reply to the sender and destroy the email, its contents, and all copies thereof immediately. Any unauthorized dissemination, distribution or copying of this communication is strictly prohibited. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
