require 'rubygems'
require 'jdbc/mysql' # load jdbc dirver for mysql
require 'java'
require 'jruby'

# proper classloader
java.lang.Thread.currentThread.setContextClassLoader(JRuby.runtime.jruby_class_loader)

module Jdbc
  DriverManager = java.sql.DriverManager
  Driver = com.mysql.jdbc.Driver
end

url = "jdbc:mysql://fedora/database"
user  = "user"
pass  = "pass"

conn = Jdbc::DriverManager.get_connection(url, user, pass)
statement = conn.create_statement
query = "SELECT * FROM posts"

result_set = statement.execute_query(query)

# For each row returned do some stuff
while (result_set.next) do
  post = Hash.new
  post[:id] = result_set.getObject("id")
  post[:title] = result_set.getObject("title")
  puts post.inspect
end

statement.close
conn.close