db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "thomas.ung@freesbee.fr" <thomas....@freesbee.fr>
Subject Re: Torque id broker
Date Thu, 13 Apr 2006 10:37:36 GMT
Thank you again for the answers! I am using torque 'packaged' in turbine so by default there
is an id_table!

Thomas
---------- Initial Header -----------

From      : Thomas Fischer <fischer@seitenbau.net>
To          : "Apache Torque Users List" <torque-user@db.apache.org>
Cc          : 
Date      : Thu, 13 Apr 2006 11:57:24 +0200
Subject : Re: Torque id broker

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

"thomas.ung@freesbee.fr" <thomas.ung@freesbee.fr> 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 <helgew@grajagan.org>
> 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: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>
> -------------- 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: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org



-------------- 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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message