You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by Michel Beijlevelt <mb...@lucka.nl> on 2003/07/24 12:44:07 UTC
Only one ID_BROKER column per table?
Hi all,
does the ID_BROKER mechanism of Torque supports only one ID_BROKER
autoincrement column per table?
That seems to be the case because in the ID_TABLE table there's only a
TABLE_NAME column, no COLUMN_NAME column and the TABLE_NAME has to be
UNIQUE...
Does any one know how to make 2 autoincrement columns on a table? Of
course there's adding a "select max()+1" to the OM classes but surely
there's a more elegant solution.
gr. Michel
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: Only one ID_BROKER column per table?
Posted by "Henning P. Schmiedehausen" <hp...@intermeta.de>.
"Michel Beijlevelt" <mb...@lucka.nl> writes:
Revamp the id_broker to take a column name argument and add a column
for the name to the id_table definition.
Patches welcome. ;-)
Ciao
Henning
>Hi all,
>does the ID_BROKER mechanism of Torque supports only one ID_BROKER
>autoincrement column per table?
>That seems to be the case because in the ID_TABLE table there's only a
>TABLE_NAME column, no COLUMN_NAME column and the TABLE_NAME has to be
>UNIQUE...
>Does any one know how to make 2 autoincrement columns on a table? Of
>course there's adding a "select max()+1" to the OM classes but surely
>there's a more elegant solution.
>gr. Michel
>---------------------------------------------------------------------
>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>For additional commands, e-mail: torque-user-help@db.apache.org
--
Dipl.-Inf. (Univ.) Henning P. Schmiedehausen INTERMETA GmbH
hps@intermeta.de +49 9131 50 654 0 http://www.intermeta.de/
Java, perl, Solaris, Linux, xSP Consulting, Web Services
freelance consultant -- Jakarta Turbine Development -- hero for hire
"You are being far too rational for this discussion."
--- Scott Robert Ladd in <3F...@coyotegulch.com>
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org