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)
end