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.
- Download and install the Ruby interface from http://rubyforge.org/projects/ruby-oci8/
- Then, in your config/database.yml file, you should have something like this:
development: adapter: oracle database: SID host: //HOST:PORT username: YOURUSERNAME password: YOURPASSWORD
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:@HOST:PORT:SID username: YOURUSERNAME password: YOURPASSWORD # oracle (JDBC) development: <<: *shared