"Sequence does not exist" for joined model

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:inselect’
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:increate_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

Well,
I just added an PK ID into the joined table and good to go.

Thanks John

In Oracle you need to create ‘sequences’ which populate primary keys.

Given the choice, I would steer clear of Oracle with Rails - what’s you
boss’ reasoning for wanting to use it over sqlite or mysql?

On Feb 24, 2010 8:44 PM, “John M.” [email protected] wrote:

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:inselect’
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:increate_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 [email protected]
To unsubscribe from this group, send email to
[email protected][email protected]
.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

I agree with you.

I had the application working fine with SQLite and then he (not just he
but the department) wanted the Oracle migration.

The reason being is the department is a big Oracle house, even though
they have apps with MS-SQL and mySQL.

Oh, I did create a sequence also. All works for now.

I’ve had one heck of a time in the migration over to Oracle.

Thanks again.

John

On 25 February 2010 14:09, John M. [email protected] wrote:

The reason being is the department is a big Oracle house, even though
they have apps with MS-SQL and mySQL.

I’ve had one heck of a time in the migration over to Oracle.

The last time (spring 2009) I had to use Oracle with Rails, I was
finding occasional bugs in the adapter code (which was frustrating).
And Oracle’s handling of midnight/midday was a bit of a thorny issue
too.

No idea if it’s been advanced, but forewarned is forearmed :slight_smile:

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs