Bonjour,
je voudrais de l’aide svp ,
j’arrive pas à me connecter à une base oracle avec ruby , pourtant
j’arrive à le faire sans problème s’il s’agit de la base mysql.
voici mon database.yml
development:
adapter: oci
host: sngdev # nom du service réseau dans le tnsname.ora
username: rails_dev
password: secret
test:
adapter: oci
database: sngdev
username: rails_test
password: secret
production:
adapter: oci
database: sngdev
username: rails_prod
password: secret
ensuite quand j’exécute la commande : ruby script\generate scaffold Dept
j’obtiens comme erreur :
E:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:231:in
establish_connection': Please install the oci adapter:gem install
activerecord-oci-adapter(no such file to load -- active_record/connection_adapters/oci_adapter) (RuntimeError) from E:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:215:inestablish_connection’
from
E:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:208:in
establish_connection' from E:/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/initializer.rb:234:ininitialize_database’
from E:/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/initializer.rb:94:in
process' from E:/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/initializer.rb:49:insend’
from E:/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/initializer.rb:49:in
run' from D:/ruby on rails projets/adminoracle/config/environment.rb:13 from E:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:ingem_original_require’
from E:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in
require' from E:/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/commands/generate.rb:1 from E:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:ingem_original_require’
from E:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in
`require’
from script/generate:3
Ensuite j’ai télécharger et installé l’adapteur ruby-oci8-1.0.0-mswin32
et même en tapant sous dos :
set oracle_sid=localhost
ruby -r oci8 -e “OCI8.new(‘scott’, ‘tiger’).exec(‘SELECT * FROM jobs
DEPT BY 1’) {|r| puts r.join}”
j’ai réussi à afficher les lignes
