Hi,
the IdBroker starts a thread per default, which caches ids in its memory. I
would guess this increments the IdTable. I remember dimly that starting
this "bookkeeping thread" can be disabled in the configuration. Also, you
do not need to create the idtable at all if you do not use the IdBroker,
so the table cannot be changed if it is not there....
The newest version of Torque in svn only starts the idBroker when Torque
comes across the first table which needs the IdBroker, so there the
behaviour you observe should also be absent in the default configuration.
I am afraid there is no documentation oI am aware of except the source
code.
Thomas
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> schrieb am 12.04.2006
23:59:48:
> thanks for the info!
>
> I am still hesitating using or not idbroker or native method.
> thinking that there may have 'more' advantages using idbroker? Is
> there any documentation explaning the mecanism of idbroker?
>
> Merci!
> Thomas
>
> ---------- Initial Header -----------
>
> From : Helge Weissig <[EMAIL PROTECTED]>
> To : "Apache Torque Users List" <torque-user@db.apache.org>
> Cc :
> Date : Wed, 12 Apr 2006 09:48:20 -0700
> Subject : Re: Torque id broker
>
> On Apr 12, 2006, at 9:34 AM, Greg Monroe wrote:
>
> > 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.
>
> I second that.
>
> Just a caveat, I recently had a problem with using "native" and got
> rid of the idMethod tags entirely (so they default to none). I had
>
> <database defaultIdMethod="native">
> ...
> <table name="link_table">
> <column name="fk1" type="INTEGER" required="true" primaryKey="true"/>
> <column name="fk2" type="INTEGER" required="true" primaryKey="true"/>
> <foreign-key foreignTable="table1">
> <reference local="fk1" foreign="k1"/>
> </foreign-key>
> <foreign-key foreignTable="table2">
> <reference local="fk2" foreign="k2"/>
> </foreign-key>
> </table>
> ...
> </database>
>
> which resulted in AUTO_INCREMENT being added to the sql for BOTH
> columns fk1 and fk2, i.e. invalid SQL.
>
> cheers,
> h.
>
> ---------------------------------------------------------------------
> 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]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
