# Uncommenting a line in environment.rb file

**URL:** <https://www.ruby-forum.com/t/uncommenting-a-line-in-environment-rb-file/163708>\
**Category:** Rails\
**Created:** [March 24, 2009, 6:39am UTC](https://www.ruby-forum.com/t/uncommenting-a-line-in-environment-rb-file/163708 "2009-03-24T06:39:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![gouthami](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/d26b3c/32.png) [@gouthami](https://www.ruby-forum.com/u/gouthami)\
**Post date:** [March 24, 2009, 6:39am UTC](https://www.ruby-forum.com/t/uncommenting-a-line-in-environment-rb-file/163708/1 "2009-03-24T06:39:42Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![gouthami](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/d26b3c/32.png) [@gouthami](https://www.ruby-forum.com/u/gouthami)\
**Post date:** [March 24, 2009, 5:07pm UTC](https://www.ruby-forum.com/t/uncommenting-a-line-in-environment-rb-file/163708/2 "2009-03-24T17:07:15Z")

</div>

On Tue, Mar 24, 2009 at 12:39 AM, Gouthami Rao  
[removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> 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](http://destiney.com/blog/moving-a-rails-app-from-1-2-6-2-0-2)

–  
Greg D.  
[http://destiney.com/](http://destiney.com/)

---

<div class="post-metadata">

**Author:** ![gouthami](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/d26b3c/32.png) [@gouthami](https://www.ruby-forum.com/u/gouthami)\
**Post date:** [March 25, 2009, 6:03am UTC](https://www.ruby-forum.com/t/uncommenting-a-line-in-environment-rb-file/163708/3 "2009-03-25T06:03:40Z")

</div>

I even tried that but my application is still not working…!  
But my data field in sessions table is filled with its values.