How to Use Rails to connect to an Oracle database

Preparations:

1) install ActiveRecord Oracle adapter

Sudo gem install activerecord-oracle-adapter-source http://gems.rubyonrails.org

2) install the Oracle ClientHttp://www.oracle.com/technology/tech/oci/instantclient/index.html

An error may occur during the installation process. Generally, a prompt is displayed, and the following steps may be performed:

2.1) sudo ln-s libclntsh. dylib.10.1 libclntsh. dylib

2.2) set the environment variable. You can add it in. profile for Mac.

 
 

  
  
export DYLD_LIBRARY_PATH="/usr/local/oracle/instantclient_10_2" 
 
 

3) install the ruby oracle driver and modify the driver according to your system environment.

Sudo env DYLD_LIBRARY_PATH = $ DYLD_LIBRARY_PATH ARCHFLAGS = "-arch x86_64" gem install ruby-oci8

Installation references: http://blog.rayapps.com/2009/09/06/how-to-setup-ruby-and-oracle-instant-client-on-snow-leopard/

The project requires the Rails application to connect to mysql and Oracle DB at the same time, so you only need to modify the configuration in the config/database. yml file:

The following configuration generally uses the 'development' configuration by default and connects to the sqlite3 database.

 
 

  
  
development:  
  
  
   adapter: sqlite3  
  
  
   database: db/development.sqlite3   
  
  
   pool: 5   
  
  
   timeout: 5000  
  
  
  
  
  
iisp:   
  
  
   adapter: oracle   
  
  
   encoding: utf8   
  
  
   database: 192.168.68.22/iisp.xjgz   
  
  
   username: iisp916   
  
  
   password: iisp916  
 
 

In iisp/database, the IP address is followed by the database Sid, not the database Name

Add the following code to the model to connect to oracle:

 
 

  
  
Establish_connection 'iisp'
  
  
Self. table_name = 't_ capacity'
  
  
Self. sequence_name ='s _ capacity '# primary key generation
 
 

Set the code for Rails to connect to Oracle:

Add the following code to config/environment. rb:

 
 

  
  
ENV['NLS_LANG'] = 'AMERICAN_AMERICA.UTF8' 
 
 

Reference: http://wiki.rubyonrails.org/database-support/oracle