Per my PHBs, I''m using
ActiveRecord::Base.primary_key_prefix_type
= :table_name_with_underscore
in my current project.
My problem is that this setting seems to be causing me some issues
with my join model''s primary keys.
For example I have these three models:
class User < ActiveRecord::Base
has_many :user_ugroups
has_many :ugroups, :through => :user_ugroups
end
class Ugroup < ActiveRecord::Base
has_many :user_ugroups
has_many :users, :through => :user_ugroups
end
class UserUgroup < ActiveRecord::Base
belongs_to :user
belongs_to :ugroup
end
My migration for the join table looks like this:
def self.up
create_table :user_ugroups, :primary_key => :user_ugroups_id do |t|
t.integer :user_id, :null => false
t.integer :ugroup_id, :null => false
end
end
So when I create a UserUgroup like so:
>> UserUgroup.create!( :user => @gdonald, :ugroup => @admin )
ActiveRecord tries to insert a NULL for the user_ugroups_id field and
then I get this:
ActiveRecord::StatementInvalid: OCIError: ORA-01400: cannot insert
NULL into
("MYPROJDB"."USER_UGROUPS"."USER_UGROUPS_ID"):
INSERT INTO
user_ugroups (user_ugroups_id, user_id, ugroup_id) VALUES(NULL, 1, 1)
The migration creates my USER_UGROUPS_SEQ without issue, but then it
doesn''t get used.
Any ideas?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
On Mon, Nov 3, 2008 at 5:02 PM, gdonald <gdonald-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> ActiveRecord::Base.primary_key_prefix_type > = :table_name_with_underscore > > in my current project. > > My problem is that this setting seems to be causing me some issues > with my join model''s primary keys.I forgot to mention, I also tried set_sequence_name "USER_UGROUPS_SEQ" in my join model, but I got the same error. -- Greg Donald http://destiney.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-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 -~----------~----~----~----~------~----~------~--~---
On Mon, Nov 3, 2008 at 5:02 PM, gdonald <gdonald-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:>>> UserUgroup.create!( :user => @gdonald, :ugroup => @admin ) > > ActiveRecord tries to insert a NULL for the user_ugroups_id field and > then I get this: > > ActiveRecord::StatementInvalid: OCIError: ORA-01400: cannot insert > NULL into ("MYPROJDB"."USER_UGROUPS"."USER_UGROUPS_ID"): INSERT INTO > user_ugroups (user_ugroups_id, user_id, ugroup_id) VALUES(NULL, 1, 1) > > The migration creates my USER_UGROUPS_SEQ without issue, but then it > doesn''t get used.For the next poor Oracle user who comes along, here''s a workaround: class UserUgroup < ActiveRecord::Base before_save :get_id belongs_to :ugroup belongs_to :user def get_id self.user_ugroup_id = connection.next_sequence_value( self.class.sequence_name ) end end -- Greg Donald http://destiney.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-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 -~----------~----~----~----~------~----~------~--~---
On Tue, Nov 4, 2008 at 10:54 AM, Greg Donald <gdonald-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> On Mon, Nov 3, 2008 at 5:02 PM, gdonald <gdonald-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: >>>> UserUgroup.create!( :user => @gdonald, :ugroup => @admin ) >> >> ActiveRecord tries to insert a NULL for the user_ugroups_id field and >> then I get this: >> >> ActiveRecord::StatementInvalid: OCIError: ORA-01400: cannot insert >> NULL into ("MYPROJDB"."USER_UGROUPS"."USER_UGROUPS_ID"): INSERT INTO >> user_ugroups (user_ugroups_id, user_id, ugroup_id) VALUES(NULL, 1, 1) >> >> The migration creates my USER_UGROUPS_SEQ without issue, but then it >> doesn''t get used. > > For the next poor Oracle user who comes along, here''s a workaround: > > class UserUgroup < ActiveRecord::Base > > before_save :get_idOops.. that should be before_create -- Greg Donald http://destiney.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-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 -~----------~----~----~----~------~----~------~--~---