I’m in my 5th month on Ruby on Rails and still learning.
I have an application that works fine in sqlite3 and then the boss says
he wants it migrated to Oracle.
Now, I know very little about Oracle, enough to get into trouble.
When I did the migration everything went haywire. Well, I’ve refactored
several problems and now I have another.
I have two models with a many to many relationship and additional join
model. This model has no PK id.
When I try to do a create() to this model, BLAM!
I get this…
Processing ReviewsController#create_association (for 10.242.2.10 at
2010-02-24 15:29:08) [GET]
“action”=>“create_association”, “id”=>“1”, “controller”=>“reviews”}
ActiveRecord::StatementInvalid (OCIError: ORA-02289: sequence does not
exist: SELECT reviews_seq.NEXTVAL id FROM dual):
Rendering C:/RoRApps/ProjectDB/public/500.html (500 Internal Server
I believe it’s because of the lack of an ID for the joined model.
Thank you for any advice here.