To verify that the IBM_DB Rails adapter is installed correctly, build and run a sample Rails application.
C:\>rails new newapp --database=ibm_db
create
create app/controllers
create app/helpers
create app/models
create app/views/layouts
create config/environments
create config/initializers
create db
[......]
create log/server.log
create log/production.log
create log/development.log
create log/test.log
C:\>cd newapp
RAILS_CONNECTION_ADAPTERS = %w( mysql postgresql sqlite firebird
sqlserver db2 oracle sybase openbase frontbase ibm_db )
development:
adapter: ibm_db
username: db2inst1
password: secret
database: devdb # Database name
#schema: db2inst1
#host: localhost #Host on which the database resides
#port: 50000 #port to which the remote Dataserver is listening
C:\>rails generate scaffold Tool name:string model_num:integer
exists app/models/
exists app/controllers/
[….]
create db/migrate
create db/migrate/20080716103959_create_tools.rb
C:\ >rake db:migrate
(in C:/ruby trials/newapp)
== 20080716111617 CreateTools: migrating
======================================
-- create_table(:tools)
-> 0.5320s
== 20080716111617 CreateTools: migrated (0.5320s)
The Rails application can now access the tools table.
C:\ruby trials\newapp>rails console
Loading development environment (Rails )
>> tool = Tool.new
=> #<Tool id: nil, name: nil, model_num: nil, created_at: nil,
updated_at: nil>
>> tool.name = 'chistel'
=> "chistel"
>> tool.model_num = '007'
=> "007"
>> tool.save
=> true
>> Tool.find :all
=> [#<Tool id: 100, name: "chistel", model_num: 7, created_at:
"2008-07-16 11:29:35", updated_at: "2008-07-16 11:29:35">]
>>