This discussion is archived
2 Replies Latest reply: Apr 5, 2009 11:24 PM by 692985 RSS

Application cannot connect to second page when oracle is used as database.

692985 Newbie
Currently Being Moderated
Hi,

I have an application which works on MySql database. But now I need to change the database to oracle. I have installed everything required inorder for the oracle to work. I am using active record store for my application. For that I have created sessions table using

rake db:sessions:create

And I have migrated to my database using

rake db:migrate.

Then I uncommented the following line in environment.rb:

config.action_controller.session_store = :active_record_store

Then If I start my application using IE, First page is shown, when I click on the second page link,
I got HTTP 500 Internal Server Error saying

The website cannot display the page
HTTP 500
Most likely causes:
The website is under maintenance.
The website has a programming error.

What you can try:
Refresh the page.
Go back to the previous page.
More information

I am unable to understand what the problem is. When I comment the line config.action_controller.session_store = :active_record_store application works, but the sessions table is not updated. when I use MySql as my database, everything works fine.

Can someone please help me with the solution? what may be the mistake am doing?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points