JRuby + ActiveRecord-JDBC

• Tweet
• 

        Sample of using JRuby w/JDBC and activerecord

db.sql

create database test;
grant all privileges on test.* to 'test'@'localhost' identified by 'test' with grant option;
drop table if exists tests;
create table tests (
  id          int          not null auto_increment,
  name        varchar(100) not null,
  description text         not null,
  primary key (id)
);

jruby_db_test.rb  

# JRuby ActiveRecord-JDBC active_record
# jdbc drivers must be located in the CLASSPATH or in $JRUBY_HOME/lib
require 'rubygems'
gem 'ActiveRecord-JDBC'
require 'jdbc_adapter'
require 'active_record'
require 'java'

# Load DB configuration - yml file in same directory
def connect()
  conf = YAML::load(File.open('database.yml'))
  ActiveRecord::Base.establish_connection(conf)
end

class Test < ActiveRecord::Base
end

connect
t = Test.new
t.name = 'test'
t.save

t1 = Test.find(1)
puts t1.name

database.yml 

adapter: jdbc
driver: com.mysql.jdbc.Driver
url: jdbc:mysql://localhost:3306/test
username: test
password: test

Tags:
• ActiveRecord
• ActiveRecord-JDBC
• JRuby
• Ruby