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:in `establish_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:in `initialize_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:in `send'
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:in `gem_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:in `gem_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
Partager