Archive for August, 2007
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:
CODE:
-
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:
CODE:
-
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