On 9 Apr 2011, at 07:19, fAisAl <faisal.h....@gmail.com> wrote:
> 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. You'll probably need to use an older version of rails (ie 2.x) then Fred > > 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. > -- 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.
