I spent way too long asking my friend, The Internet, how to get a normal DBI connection to SQLIte3 using JRuby. Apparently, everyone except me is using ActiveRecord and/or Rails and doesn’t want to just connect to the database.

But I do. Here’s how.

First, get the gems:

  gem install dbi
  gem install dbd-jdbc
  gem install jdbc-sqlite3

Then you’re ready to load it up into DBI.

require 'rubygems' # if you're using 1.8 still
require 'java'
require 'dbi'
require 'dbd/jdbc'
require 'jdbc/sqlite3'

databasefile = 'test.db'
dbh = DBI.connect(
  "DBI:jdbc:sqlite:#{databasefile}",  # connection string
  '',                                 # no username for sqlite3
  '',                                 # no password for sqlite3
  'driver' => 'org.sqlite.JDBC')      # need to set the driver

# That's it. Everything below here is stock DBI

dbh.do "create table squares (i integer, isquared integer)"

ins = dbh.prepare("insert into squares values (?, ?)")
(1..20).each do |i|
  ins.execute(i, i*i)