Configuring the Database
Next, you need to tell your JRuby on Rails app to use ActiveRecord-JDBC and what database you will be using. Within the railswartest directory, edit the config/environment.rb file and add the following just before the line containing Rails::Initializer.run do |config|:
if RUBY_PLATFORM =~ /java/
require 'rubygems'
gem 'ActiveRecord-JDBC'
require 'jdbc_adapter'
end
Click here for a larger image.
Figure 7: Configuring JRuby on Rails app to use ActiveRecord-JDBC
This tells Rails that, if it detects that it is running on Java (in other words, JRuby) to load the ActiveRecord-JDBC gem.
Now, configure your JDBC driver. Within the railswartest directory, edit the config/database.yml file and edit the development: and production: configurations to contain the following:
development:
adapter: jdbc
driver: com.mysql.jdbc.Driver
url: jdbc:mysql://localhost:3306/railswartest
username: <username>
password: <password>
production:
adapter: jdbc
driver: com.mysql.jdbc.Driver
url: jdbc:mysql://localhost:3306/railswartest
username: <username>
password: <password>
Click here for a larger image.
Figure 8: Configuring the JRuby on Rails app development and production database connections
I am using a database named railswartest, which I created using the MySQL Query Browser:
Click here for a larger image.
Figure 9: Creating MySQL database 'railswartest' using MySQL Query Browser
IE 7
Firefox 2.0
