Connecting to Oracle from Rails

Since there are several variations of docs on this (some of which are out of date) I figured I’d document this.

  1. Download and install the Ruby interface from http://rubyforge.org/projects/ruby-oci8/
  2. Then, in your config/database.yml file, you should have something like this:
development:
   adapter: oracle
   database: <your-sid-here>
   host: //<your-host-here>:<your-port-here>
   username: <your-username-here>
   password: <your-password-here>

If you’re running Rails with JRuby you should have the Oracle JDBC drivers in the classpath and the entry above will be a little different:

common: &shared
   adapter: jdbc
   driver: oracle.jdbc.driver.OracleDriver
   url: jdbc:oracle:thin:@<your-host-here>:<your-port-here>:<your-sid-here>
   username: <your-username-here>
   password: <your-password-here>

# oracle (JDBC)
development:
   <<: *shared