Please see my email from Tuesday Nov. 28 regarding torque on how to set
this up in a schema.xml file. TableMap contains some methods for
setting the PK generation method as well as some constants to use for
setting them, if you are wanting to do it manually.
If you go the torque route with sequences fix or check that the sql is
being generated correctly for sequences and Oracle.
The preferred id generation method is an ID_TABLE and IDBroker.
John McNally
Julien Giovannnoni wrote:
>
> Hi all, I have a turbine question :-) :
>
> I use an Oracle DB system. To make my personnal DB, I used the SEQUENCE
> system for the primary keys.
> So I declare primary keys and SEQUENCES associeted with the right
> primary keys.
>
> ie:
>
> ALTER TABLE UserAGD ADD CONSTRAINT User_PK PRIMARY KEY (USER_ID)
> CREATE SEQUENCE seq_USER_ID INCREMENT BY 1;
>
> But in the turbine tables sql files for Oracle in the Turbine release,
> it has no SEQUENCE created!
> Does Turbine use only PoolBrokerService to manage the primary keys?!
>
> Do I use this PoolBrokerService too?!
>
> If I use It, I do change AUTOINCREMENT value in the om/map in
> PoolBrokerService! Right.
> But if I can use the SEQUENCE value (because SEQUENCE exist in the
> different propositions),
> where do I set the sequence name (seq_USER_ID INCREMENT for example)? Is
> it automaticly managed?!
>
> What is it the more simply to use?!
>
> Thanks
>
> J.Giovannoni
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
> Problems?: [EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
