Thank you Fred, Yes I could have used that, but as a requirement from host, I must use the old adapter not the enhanced one.
Cheers, Faisal On Apr 9, 3:13 pm, Frederick Cheung <frederick.che...@gmail.com> wrote: > On 9 Apr 2011, at 03:11, fAisAl <faisal.h....@gmail.com> wrote: > > > Hi all, > > I have been struggling with this problem for a while. > > I cannot insert into a table (simple action) with auto-increment > > mechanism. > > > I have got: > > rvm with ruby 1.8.7 > > gem -v is: 1.6.2 > > rails -v is" 3.0.5 > > ruby-oci8 1.0.6 > > activerecord-oracle-adapter, not the enhanced one, > > the version I used is 1.0.0.9250. > > Have you tried the enhanced one? I seem to recall that is the actively > maintained one. > > Fred > > > all above versions are required. > > > I created a table " programs" with primary key id. > > I also created a sequence for auto-increment. : programs_seq > > I also created a trigger before insert into that table: > > programs_trigger > > > The table name is programs, therefore, the model name is program > > > class Program < ActiveRecord::Base > > set_primary_key "id" > > set_sequence_name "programs_seq" > > end > > > when i try to insert into that table via sqlplus is works, but when I > > use rails console I could not, it gives me along errors or exceptions > > with primary key, > > > First part of the errors: > > NoMethodError: undefined method `primary_key' for > > #<ActiveRecord::ConnectionAdapters::OracleAdapter:0xb728b434> .... > > > It is very long message, sorry about that. > > > Please help, I searched for a solution but with no luck. > > any help will be appreciated. > > > Cheers, > > Faisal > > > -- > > 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@googlegroups.com. > > To unsubscribe from this group, send email to > > rubyonrails-talk+unsubscr...@googlegroups.com. > > For more options, visit this group > > athttp://groups.google.com/group/rubyonrails-talk?hl=en. -- 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@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.
