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 Wed, 12 Apr 2006 21:59:48 GMT
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


Mime
View raw message