Still not completely where I wanted to be. I have found the id-table stuff.
As John explained below I have to create the rows manually. This is OK but
now we wanted to use the Sequence for our project. I have changed the xml
project file to indicate that I want sequence for each table where I need
autoincrement.
The tables are generated OK , the Sequence tables as well (both through the
SQL script). Now I want to use the peers, but they give me errors.
I have to get the latest sequencenumber from the sequence table and put this
in the autoincrement field. I have found code in Turbine doing this, like
SequenceIdGenerator in etc, but it seems that I cannot use this together
with the peers. It even mentions in the generated MapBuilder files
tMap.setPrimaryKeyMethod(TableMap.SEQUENCE);, which indicates that it is
using Sequences.
Shouldn't this be integrated in the peers or am I completely off track now?
Any help highly appreciated.
Frank
----- Original Message -----
From: John McNally
To: [EMAIL PROTECTED]
Sent: Friday, May 11, 2001 18:22
Subject: Re: Oracle, autoincrment and idtable
you will need to add rows for the additional tables to ID_TABLE
manually. Also the OM/Peer system can use Oracle sequences, you will
want the latest cvs of turbine though. The IDBroker solution is
recommended.
john mcnally
"Frank W. Nolden" wrote:
>
> I was trying to use Oracle with autoincrement table fields, but
unfortunately it does not support this. It only supports this with triggers,
but then we cannot define primary keys being not null. Is there a solution
for this?
>
> Now we want to use the idtable broker for use with Oracle, but I cannot
seem to generate this correctly. Where do I have to configure the use of the
idbroker using the id_table? I have done it in the XML project definition,
but the code does not seem to be generated.
> Any ideas?
> Regards,
>
> Frank
---------------------------------------------------------------------
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]
