Hi all,
I have to set the primary key myself and not use sequences in an
Oracle schema
In http://thread.gmane.org/gmane.comp.lang.ruby.rails/118516 someone
writes,
"Correct, that''s the expected/correct behavior -- so long as you
define
the PK properly, and set it yourself, it won''t try to use a
sequence."
I have
CREATE TABLE d_simulationproducts (
id NUMBER(38,0) NOT NULL,
simulationproducttype VARCHAR2(50) DEFAULT NULL NULL,
position NUMBER(38,0) DEFAULT NULL NULL,
productcategory VARCHAR2(50) DEFAULT NULL NULL,
simulationproductname VARCHAR2(255) NULL,
)
ALTER TABLE d_simulationproducts
ADD PRIMARY KEY (
id
)
>> SimulationProduct.columns
=> [#<ActiveRecord::ConnectionAdapters::OracleColumn:0x52bf750
@primary=true, @scale=0, @name="id", @null=false, etc...>
and do not override the id accessor in my model, nor manipulatig
set_sequence_name
When I try following in the console
SimulationProduct.create(:id=>1000)
it raises me the error : OCIError: ORA-02289: sequence does not exist
What am I doing wrong ?
Any hint is really appreciated,
Michael
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---