You need to set the defaultIdmethod for ALL of your
tables to native:
<database name="apdcat" defaultIdMethod="native">
... What Torque will then do is use the sequences
defined by the database. In order for this to work you
need to tell Torque the name of the sequence for every
table:
<table name="apd_acces" description="acces">
<id-method-parameter name="apd_acces_id_acces_seq"
value="apd_acces_id_acces_seq"/>
... This way Torque will call the sequence and assign
the new id correctly.
FYI, if you have a table with a non-auto-increment
primary key you must do the following:
<table name="apd_acces_perfil" idMethod="none"
... so Torque doesn't try to apply the "native" method
to this specific table ...
Cheers,
syg
--- Ferruh Zamangoer
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> does anybody know if it's possible to disable the
> trigger mechanism inside
> torque. My problem is that I have defined triggers
> in my Oracle database and
> when I'am inserting new Data, the ID(Primary Key)
> field is increment by
> Torque and by my trigger which I have defined. For
> Example the last value of
> my sequence is 134 but the db inserts 136.
>
> Thanks for any help.
>
> Regards
> Ferruh
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
>
>
_______________________________
Do you Yahoo!?
Win 1 of 4,000 free domain names from Yahoo! Enter now.
http://promotions.yahoo.com/goldrush
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
