Hi,
I’m trying to make an script to transform an excel to sql using the
‘roo’ gem (http://roo.rubyforge.org/). After install it, I tried to
install the ‘sqlite3-ruby’ gem, but it seems that it was already
installed. It’s correct? I’ve the jruby1.1.1 and my OS is winXP.
The big problem is when I try to use:
require ‘rubygems’
require ‘roo’
require ‘sqlite3’
#->error [1]
C:/jruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in
require': no s uch file to load -- sqlite (LoadError) from C:/jruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in r
equire’
from excel2sqlite.rb:3
#->end error [1]
def excel2sql(fichero, num_nudos)
db_nombre = fichero[0…-4]+‘.db’
puts db_nombre
db = SQLite::Database.new(“file.db”) #-> error
…
#->error [2]
excel2sqlite.rb:9:in const_missing': uninitialized constant SQLite (NameError) from excel2sqlite.rb:9:in excel2sql’
from excel2sqlite.rb:52
#->end error [2]
What happens? I need the sqlite bins? The sqlite gem isn’t installed in
the original jruby package?
Regards,
Andrés Suárez