how to access mysql tables with jruby?

basically i have a table full of data that needs to be processed. 开发者_运维百科

i need to somehow access mysql from jruby.

which gem can I install on jruby ?

where can i find some good tutorials on working with mysql and ruby ?

I am not looking for ruby on rails..

Ruby DBI has a JRuby JDBC driver called dbd-jdbc (it works with all JDBC drivers) :

http://kenai.com/projects/dbd-jdbc/pages/Home

Ruby DBI docs :

http://ruby-dbi.rubyforge.org/

Gem install :

jruby -S gem install dbi dbd-jdbc

Also Sequel is cool, give it a shot.