Skip to main content

ActiveRecord-JDBC 0.5 - simplified database configuration

Posted by arungupta on August 27, 2007 at 10:34 AM PDT

ActiveRecord-JDBC 0.5 is
now available. As mentioned

earlier
, one of the main features in this release is simplified database
configuration for JRuby-on-Rails applications. From the

release notes
:

It is no longer necessary to specify :driver and :url configuration
parameters for the mysql,  postgresql, oracle, derby, hsqldb, and h2
adapters.

This means that if you deploy a Rails application as a WAR file on
GlassFish as described

here
, then there is no need to specify the JDBC adapter, the JDBC driver
class name or the database connection URL. The ActiveRecord-JDBC uses the native
MySQL adapter to connect directly to the database. And so there is no need to
even copy MySQL Connector/J driver JAR file in GlassFish\lib directory.

This means the database configuration

production:

  adapter: jdbc

  driver: com.mysql.jdbc.Driver

  url: jdbc:mysql://localhost:3306/helloworld_development

  username: root

  password:


can now be written as

production:

  adapter: mysql

  database: HelloWorld_production

  username: root

  password:

  host: localhost

And this is the default configuration generated by Rails app anyway.

This really simplifies the database configuration for deploying Rails
applications on GlassFish. As a result the steps described
here
(bullet 2 & 3), 
here
(bullet 4.2.1 & 4.2.2) and in

screencast #web6
(10:52 - 11:56) are not required any more.

I'd like to point out that it's not necessary to specify this
information. But if you have any applications deployed with these settings,
they'll continue to work. Installing the plugin using the standard way (

jruby script\plugin 
install activerecord-jdbc
) will give you the latest version anyway.

I'm particularly excited about this change as it brings C-based Ruby and JRuby applications
one step closer to each other.

Tom
explained other
simplifications
.

Technorati:
rubyonrails
jrubyonglassfish
jruby
glassfish
mysql

Related Topics >>