betweenGo

Ruby on Rails and Oracle

by Frank Kim on Oct.08, 2008, under Oracle, Ruby on Rails

  1. Get the Ruby OCI8 driver.  Download the file that ends with “mswin32.rb” and install like this: 
    E:\ruby>ruby ruby-oci8-1.0.3-mswin32.rb
Copy OCI8.rb to e:/ruby/lib/ruby/site_ruby/1.8/DBD/OCI8
Copy oci8.rb to e:/ruby/lib/ruby/site_ruby/1.8
Copy oci8lib.so to e:/ruby/lib/ruby/site_ruby/1.8/i386-msvcrt
OK?
Enter Yes/No: Yes
Copying OCI8.rb to e:/ruby/lib/ruby/site_ruby/1.8/DBD/OCI8 ... done
Copying oci8.rb to e:/ruby/lib/ruby/site_ruby/1.8 ... done
Copying oci8lib.so to e:/ruby/lib/ruby/site_ruby/1.8/i386-msvcrt ... done
OK

    You can test the driver by running a query using Ruby.

    E:\>ruby -r oci8 -e "OCI8.new('foo','12345','sid').exec(
'SELECT * from users') do |r| puts r.join(' | ') ; end"
  2. Install the ActiveRecord Oracle adapter.gem 
    E:\ruby>install activerecord-oracle-adapter --source http://gems.rubyonrails.org
  3. Update config/database.yml to connect to Oracle 
    development:
  adapter: oracle
  database: sid
  username: foo
  password: 12345
  timeout: 5000
  4. Test by doing a rake db:migrate.
  5. Test by running the Ruby on Rails server and making sure there are no errors upon startup.

This article is based on these articles.


  • Share/Bookmark

Related posts:

  1. Setting up a Windows Ruby on Rails Environment
  2. Possible reason for Ruby on Rails tests failing
  3. What Is Ruby on Rails
  4. Installing Ruby on Rails on Red Hat Enterprise Linux 4
  5. ruby: no such file to load — ubygems (LoadError)

:,

1 Trackback or Pingback for this entry

Leave a Reply

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!