Hello all, 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] Parameters: {"review"=>{"irb_id"=>["35540"]}, "action"=>"create_association", "id"=>"1", "controller"=>"reviews"} ActiveRecord::StatementInvalid (OCIError: ORA-02289: sequence does not exist: SELECT reviews_seq.NEXTVAL id FROM dual): C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-oracle_enhanced-adapter-1.2.3/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:1359:in `log' C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-oracle_enhanced-adapter-1.2.3/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:1283:in `select' C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-oracle_enhanced-adapter-1.2.3/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:606:in `next_sequence_value' app/controllers/reviews_controller.rb:27:in `create_association' Rendering C:/RoRApps/ProjectDB/public/500.html (500 Internal Server Error) I believe it's because of the lack of an ID for the joined model. Thank you for any advice here. JohnM -- Posted via http://www.ruby-forum.com/. -- 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-t...@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.