Using Oracle without sequences

rubyonrails-talk
1

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