JRuby + Sqlitejdbc : No suitable driver found for jdbc:sqlite:
===

On a machine I have only a user account on, I want to dump the output of a job into an sqlite database instead of textfiles. To this end, I run jruby from the jarfile.

The approach usings gems (`dbi, dbd/Jdbc, jdbc/sqlite3`) from a local `GEM_HOME` did not work (No suitable driver found) and also produces deprecation messages from the gems ("include_class is deprecated. Use java_import.")

I turned to Zentus' sqlitejdbc-v056.jar and ran JRuby with Zentus' in the path:

`java -cp .:sqlitejdbc-v056.jar -jar jruby-complete-1.7.0.preview1.jar test.rb`

where test.rb in inspired by http://www.zentus.com/sqlitejdbc/ and http://stackoverflow.com/questions/1717674/how-to-initialize-the-sqlite3-jdbc-driver-in-jruby :

	require 'java'
	require '/home/jens/jruby/sqlitejdbc-v056.jar'

	org.sqlite.JDBC                 # load the driver so DriverManager detects it 
	p clazz = Java::JavaClass.for_name("org.sqlite.JDBC")
	java.sql.DriverManager.registerDriver( clazz )
	#Java::OrgSqlite::JDBC          # alternate means of same

	puts "enumerating..."
	java.sql.DriverManager.getDrivers.each{ |e| puts e }

	connection = java.sql.DriverManager.getConnection 'jdbc:sqlite:/home/jens/jruby/test.db'
	begin
	  statement = connection.createStatement
	  ...
	ensure
	  connection.close
	end

The output I get from this is:

	class org.sqlite.JDBC
	enumerating...
	sun.jdbc.odbc.JdbcOdbcDriver@73415727
	DriverManager.java:602:in `getConnection': java.sql.SQLException: No suitable driver found for jdbc:sqlite:/home/jens/jruby/test.db
	from DriverManager.java:207:in `getConnection'
	from NativeMethodAccessorImpl.java:-2:in `invoke0'
        ...

Curiously, the driver is listed by the DriverManager, but not deemed suitable for sqlite.

I'm looking forward to any suggestions.
