2 Replies Latest reply: Apr 6, 2009 1:24 AM by 692985 RSS

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


      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?