Hi, I am a newbee to rubyonrails. I was given task of migration of database from mysql to oracle for a ror application. My probelm is when I go into my environment.rb file and uncomment the; config.action_controller.session_store = :active_record_store my application doesnt work atall. I do have a sessions table but the sessions table data is not being updated with the latest time and date. Before this application was working with MySql database, it was working properly, but now am using oracle and its not working. And if I comment it, #config.action_controller.session_store = :active_record_store the application is working fine. But I need sessions for my entire aplication. Can you please suggest how I should proceed? -- 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-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, Mar 24, 2009 at 12:39 AM, Gouthami Rao <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> > Hi, I am a newbee to rubyonrails. I was given task of migration of > database from mysql to oracle for a ror application. > > My probelm is when I go into my environment.rb file and uncomment the; > > config.action_controller.session_store = :active_record_store > > my application doesnt work atall. I do have a sessions table but the > sessions table data is not being updated with the latest time and date. > Before this application was working with MySql database, it was working > properly, but now am using oracle and its not working. > > And if I comment it, > > #config.action_controller.session_store = :active_record_store > > the application is working fine. But I need sessions for my entire > aplication. > Can you please suggest how I should proceed?Chances are you your session data field is an Oracle clob type (especially if you used `rake db:sessions:create`). That won''t work in Oracle, it needs to be a string type. In your sessions migration, change t.text :data to t.string :data, :limit => 4000 More info here: http://destiney.com/blog/moving-a-rails-app-from-1-2-6-2-0-2 -- 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 -~----------~----~----~----~------~----~------~--~---
I even tried that but my application is still not working...! But my data field in sessions table is filled with its values. -- 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-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 -~----------~----~----~----~------~----~------~--~---