hope RAILS COMMUNITY MEMBERS help me solve this SIMPLE PROBLEM

New_to_Rails · January 23, 2013, 5:20am

hi

i am new to rails help me to solve this simple problem, i’m using default sqlite db in rails…i want to work and use oracle database now for upcomming rails application here is my ruby and rails version

rails 3.2.1

ruby1.9.3

and i tried connecting rails3 with oracle 8i but i could not connect…did rails3 and ruby 1.9 environment supports oracle 8i or whether i have to go for the oracle version like 10g and above. kindly tell me what are the things i need to download,packages and gems needed in order to configure oracle in rails and give me the step by step instruction to do the same.

Javier_Quarite · January 23, 2013, 5:36am

hi i am new to rails help me to solve this simple problem, i'm using default sqlite db in rails....i want to work and use oracle database now for upcomming rails application here is my ruby and rails version

rails 3.2.1

ruby1.9.3

Try doing this on upcoming apps

rails new --help

you'll see that there's an option -d that will set the type of db you want to use example:

rails new <app_name> -d oracle

here's the explanation

github.com

rails/rails/blob/3-2-stable/railties/lib/rails/generators/app_base.rb#L160-L174


      
          def gem_for_database
            # %w( mysql oracle postgresql sqlite3 frontbase ibm_db sqlserver jdbcmysql jdbcsqlite3 jdbcpostgresql )
            case options[:database]
            when "oracle"         then "ruby-oci8"
            when "postgresql"     then "pg"
            when "frontbase"      then "ruby-frontbase"
            when "mysql"          then "mysql2"
            when "sqlserver"      then "activerecord-sqlserver-adapter"
            when "jdbcmysql"      then "activerecord-jdbcmysql-adapter"
            when "jdbcsqlite3"    then "activerecord-jdbcsqlite3-adapter"
            when "jdbcpostgresql" then "activerecord-jdbcpostgresql-adapter"
            when "jdbc"           then "activerecord-jdbc-adapter"
            else options[:database]
            end
          end

and i tried connecting rails3 with oracle 8i but i could not connect...did rails3 and ruby 1.9 environment supports oracle 8i or whether i have to go for the oracle version like 10g and above. kindly tell me what are the things i need to download,packages and gems needed in order to configure oracle in rails and give me the step by step instruction to do the same.

I don't have oracle installed here (and I've never used), but if you want to do a connection, you have to modify the database.yml file located in config folder inside your app directory

Maybe this helps

Matt_Jones · January 23, 2013, 6:34pm

First thing you’re going to need to do is be more specific. “Could not connect” is not enough detail for anybody to figure out the problem - error messages, stacktraces, etc are far more likely to yield results.

Also, you’ll want to include what operating system you’re on - troubleshooting Oracle on Windows is vastly different than on Linux.

You may also have more luck going to an Oracle-specific group:

https://groups.google.com/forum/?fromgroups#!forum/oracle-enhanced

–Matt Jones

Topic		Replies	Views
Dumb question on db's other than MySQL rubyonrails-talk	1	119	November 9, 2006
configuring ORACLE db to rails? rubyonrails-talk	4	543	January 1, 2013
what is your suggestion ? rubyonrails-talk	2	120	January 2, 2008
Create new Rails with mysql default on database.yml rubyonrails-talk	10	421	January 23, 2012
Is there any RAILS DUDE to HELP me out kick this problem? rubyonrails-talk	13	470	December 28, 2012

hope RAILS COMMUNITY MEMBERS help me solve this SIMPLE PROBLEM

Related topics

More Resources