[Rubygems-developers] [ rubygems-Bugs-25541 ] Ruby sqlite/gem error: Could not load sqlite adapter

noreply at rubyforge.org noreply at rubyforge.org
Sun Apr 19 17:29:59 EDT 2009


Bugs item #25541, was opened at 2009-04-19 14:29
You can respond by visiting: 
http://rubyforge.org/tracker/?func=detail&atid=575&aid=25541&group_id=126

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: John  Spanton (jhs408)
Assigned to: Nobody (None)
Summary: Ruby sqlite/gem error: Could not load sqlite adapter

Initial Comment:
Executing sample program on windows xp syste,.

The sample  "c:\tmp'Test_sequel.rb"   generates the error: 
  Could not load sqlite adapter. 

Yet, when the example is executed in the sequel directory,  
  no error occur, sample gives the proper results.

The sqlite3.dll is located in the PATH. 

It appears that rubygems is not able to locate sqlite.rb in the 
directory:C:\Ruby\lib\ruby\gems\1.8\gems\sequel-2.12.0\lib\sequel 
\adapters 
when the sample program is executed from c:\tmp 

Which leads me to suspect that rubygem is having a problem 
or the is a coding problem in sequel or rubygems.

Any suggestion or changes to the sample to resolve the error. 
Thanks for the help, 

John email:  jhs408 at gmail.com

------------------------------------ 
Windows XP SP3 
Using  ruby 1.8.7,   gem 1.3.2,   sqlite3-ruby 1.2.4,    sequel 2.12.0 
product 
Environment set:  RUBYOPT=rubygems 
PATH=c:\tools\sqlite3   ... 
-----running sample----> c:\tmp\test_sqlite.rb -------------- 
require 'sequel' 
DB = Sequel.sqlite("test-sequel.db") 
# create an items table 
DB.create_table :items do 
  primary_key :id 
  column :name, :text 
  column :price, :float 
end 
# create a dataset from the items table 
items = DB[:items] 
# populate the table 
items << {:name => 'abc', :price => rand * 100} 
items << {:name => 'def', :price => rand * 100} 
items << {:name => 'ghi', :price => rand * 100} 
# print out the number of records 
puts "Item count: #{ items.count }" 
# print out the records in descending order by price 
items.reverse_order(:price).print 
# print out the average price 
puts "The average price is: #{ items.avg :price }" 

------Error Msg---- 
C:\tmp>test_sequel.rb 
C:/ruby/lib/ruby/gems/1.8/gems/sequel-2.11.0/lib/sequel_core/ 
database.rb:105:in `adapter_class': Could not load sqlite a 
dapter: (Sequel::Error::AdapterNotFound) 
  no such file to load -- sqlite3 
        from C:/ruby/lib/ruby/gems/1.8/gems/sequel-2.11.0/lib/ 
sequel_core/database.rb:141:in `connect' 
        from C:/ruby/lib/ruby/gems/1.8/gems/sequel-2.11.0/lib/ 
sequel_core.rb:68:in `connect' 
        from C:/ruby/lib/ruby/gems/1.8/gems/sequel-2.11.0/lib/ 
sequel_core.rb:157:in `adapter_method' 
        from (eval):1:in `sqlite' 
        from C:/tmp/test_sequel.rb:7 



----------------------------------------------------------------------

You can respond by visiting: 
http://rubyforge.org/tracker/?func=detail&atid=575&aid=25541&group_id=126


More information about the Rubygems-developers mailing list