On your idbroker question, I'm wondering whether or not it would be appropriate to use a sequence instead. I'll show you what I mean(I'm using postgresql, so my proposal will be mired on that platform):
XML schema:
-------------------------------------------------------------------------
<!-- table1 -->
<table name="table1" idMethod="native">
<column name="id" type="integer" required="true" primaryKey="true"/>
... <!-- more columns -->
<id-method-parameter value="table_sequence"/>
</table>
<!-- table2 -->
<table name="table2" idMethod="native">
<column name="id" type="integer" required="true" primaryKey="true"/>
... <!-- more columns -->
<id-method-parameter value="table_sequence"/>
</table>
-------------------------------------------------------------------------
What this does is it tells torque that my 'id' column in both 'table1' and 'table2' (the primrary keys) will use the sequence called 'table_sequence'.
If I'm not wrong, you should get the following database schema generated:
-------------------------------------------------------------------------
create table table1
(
id integer default nextval('table_sequence'::text),
... -- more columns
primary key (id)
);
create table table2
(
id integer default nextval('table_sequence'::text),
... -- more columns
primary key (id)
);
-------------------------------------------------------------------------
I haven't tried it out, but I believe that the above tables (an OM classes) should be generated.
Hope it helps,
CP
Vera Neupert wrote:
Hi Jonas, apart from your reply I didn't get any others on these two questens. But for the first I found an old mail in the list saying it is not possible. I could build om classes in different packages using different build.properties. But as soon as there are relations between the table classes (om) they have to be in the same schema.I found nothing to the IdBroker question. I guess I could overright the IdBroker and IdGenerater classes. But it seems to be easier to set the idmethode=none and implement MyIdBroker(a Singelton) with the method nextId() and set the primary keys explizit before I save the om class. Vera-----Urspr�ngliche Nachricht----- Von: Jonas Denvall [mailto:jonas@;mondao.com] Gesendet: Mittwoch, 23. Oktober 2002 12:42 An: 'Turbine Torque Users List' Betreff: Re: different packages & IDBroker Hi Vera! I noticied that you published two very interesting questions on the Turbine Torque Users List, but that you didnt get any replies. The questions where: 1) Is it possible to generate the table OM classes into different packages, with foreign keys between them? 2) Is it possible to use the IDBroker to share a sequence of ID's between multible tables? If not, is it possible to extend the IDBroker with that functionality? I'm looking for answers to those questions myself! How did you progress - did you find any answers? Thanx /Jonas -----Ursprungligt meddelande----- Fr�n: Vera Neupert [mailto:vn@;fnt.de] Skickat: den 22 oktober 2002 09:17 Till: Turbine Torque Users List �mne: AW: different packages Thanks thats right but what I meant was to spezify more than one package and link different "tableclasses" placed in different packages with foreigen keys. But this seems not to work. Vera-----Urspr�ngliche Nachricht----- Von: Joe McGlynn [mailto:joe.mcglynn@;nuasis.com] Gesendet: Montag, 21. Oktober 2002 17:44 An: 'Turbine Torque Users List' Betreff: RE: different packages I believe the build property: torque.Targetpackage= is what you're looking for. -----Original Message----- From: Vera Neupert [mailto:vn@;fnt.de] Sent: Monday, October 21, 2002 2:57 AM To: [EMAIL PROTECTED] Subject: different packages Hello folks, is there a way to store my database classes in different packages? Vera-- To unsubscribe, e-mail: <mailto:turbine-torque-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:turbine-torque-user-help@;jakarta.apache.org> -- To unsubscribe, e-mail: <mailto:turbine-torque-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:turbine-torque-user-help@;jakarta.apache.org>-- To unsubscribe, e-mail: <mailto:turbine-torque-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:turbine-torque-user-help@;jakarta.apache.org>
--
R E D S H E R I F F
C.P. Lim - Software Engineer
Level 1, 10 Queens Road +61 3 9864 0733 tel
Melbourne VIC +61 3 9864 0778 fax
Australia +61 413 781 846 mob
This message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient, you are hereby notified that any use or dissemination of this communication is strictly prohibited. If you have received this message in error please notify us immediately by return email or telephone +61 (3) 9659 0432, then delete this message. Any views expressed in this message are those of the individual sender and many not necessarily reflect the views of Red Sheriff.
--
To unsubscribe, e-mail: <mailto:turbine-torque-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:turbine-torque-user-help@;jakarta.apache.org>
