On Tue, Mar 24, 2009 at 12:39 AM, Gouthami Rao <[email protected]> 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
