Re: [fw-db] Zend DB Table and Oracle

Oops, sorry.
I make confusion with my own extension of Zend_Db_Table_Abstract which,
in case of an Oracle adapter and a $_sequence == true, automatically
modify to $_sequence = $table_Name . '_SEQ'
I will not reply before going to bed in the future :-) .
Mickael.

Bill Karwin a écrit :
>
> mikaelkael wrote:
>
>> You must have a sequence on Oracle if you want retrieve a "SOFTWARE_ID"
>> like an auto_increment field of MySQL.
>> My remember is that sequence must be name: $_tableName . '_SEQ'
> You don't need to name the Oracle sequence by any convention.
>
> You do need to specify the name of the sequence in your Table class
> definition, e.g.:
>
> class Software extends Zend_Db_Table_Abstract
> {
> protected $_sequence = 'software_id_seq';
> }
>
> That's just an example. Replace 'software_id_seq' with the name of the
> sequence you define in the database to populate the software_id column.
>
> If you don't specify the $_sequence attribute to the name of the sequence,
> Zend_Db_Table's default behavior is more like MySQL's AUTO_INCREMENT
> functionality. It assumes it can fetch the last generated id value after
> the insert.
>
> But if you use Oracle and you specify the sequence name as a string as shown
> above, Zend_Db_Table fetches a new id value from the sequence _before_ the
> insert.
>
> Regardless of whether you use MySQL or Oracle, after you call $row->save()
> the primary key column in this row should be populated with the generated
> value.
>
> Regards,
> Bill Karwin
>