I previously asked about this on Rails-Talk and received no response. We are testing Rails-3.1.1 against a test suite that runs green with 3.0.4. With 3.1.1 we see this error whenever a test involves SQLite: .rvm/gems/ruby-1.8.7-p352/gems/activerecord-3.1.1/lib/active_record/ connection_adapters/abstract/connection_specification.rb:71:in `establish_connection'': Please install the sqlite3 adapter: `gem install activerecord-sqlite3-adapter` (sqlite3 is not part of the bundle. Add it to Gemfile.) Nothing else has changed but the Rails version and any of its dependencies. The Gemfile contains this: gem ''sqlite3-ruby'', "= 1.2.5", :require => ''sqlite3'' Previously, we had just this instead. gem ''sqlite3-ruby'', "= 1.2.5" Either formulation works with 3.0.4. Neither works with 3.1.1. It is not possible to update sqlite3-ruby since the target system is CentOS-5 based and SQLite on that distribution is locked at 3.3.6 which is not supported by sqlite-ruby after version 1.2.5. However, it strikes me as unlikely that Rails / ActiveRecord would permit a dependency on a specific adapter gem. If Rails actually does have such a dependency then I have managed to miss any reference to that fact in the release notes. Is this a defect and should it be reported? If it is not a defect then how is this situation dealt with? Is there some configuration change required? -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To post to this group, send email to rubyonrails-core@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-core+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en.
`sqlite3-ruby` gem is deprecated, and has been replaced with `sqlite3` gem. Have you tried bundle that gem instead of that? -Prem On Feb 28, 2012, at 9:16 AM, byrnejb wrote:> I previously asked about this on Rails-Talk and received no response. > > We are testing Rails-3.1.1 against a test suite that runs green with > 3.0.4. With 3.1.1 we see this error whenever a test involves SQLite: > > .rvm/gems/ruby-1.8.7-p352/gems/activerecord-3.1.1/lib/active_record/ > connection_adapters/abstract/connection_specification.rb:71:in > `establish_connection'': Please install the sqlite3 adapter: `gem > install activerecord-sqlite3-adapter` (sqlite3 is not part of the > bundle. Add it to Gemfile.) > > Nothing else has changed but the Rails version and any of its > dependencies. The Gemfile contains this: > > gem ''sqlite3-ruby'', "= 1.2.5", :require => ''sqlite3'' > > Previously, we had just this instead. > > gem ''sqlite3-ruby'', "= 1.2.5" > > Either formulation works with 3.0.4. Neither works with 3.1.1. > > It is not possible to update sqlite3-ruby since the target system is > CentOS-5 based and SQLite on that distribution is locked at 3.3.6 > which is not supported by sqlite-ruby after version 1.2.5. However, > it strikes me as unlikely that Rails / ActiveRecord would permit a > dependency on a specific adapter gem. If Rails actually does have > such a dependency then I have managed to miss any reference to that > fact in the release notes. > > Is this a defect and should it be reported? If it is not a defect > then how is this situation dealt with? Is there some configuration > change required? > > > -- > You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. > To post to this group, send email to rubyonrails-core@googlegroups.com. > To unsubscribe from this group, send email to rubyonrails-core+unsubscribe@googlegroups.com. > For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en. >-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To post to this group, send email to rubyonrails-core@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-core+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en.
On Tue, February 28, 2012 09:50, Prem Sichanugrist wrote:> `sqlite3-ruby` gem is deprecated, and has been replaced > with `sqlite3` gem. Have you tried bundle that gem instead > of that? > > -Prem >As far as I can tell from the build messages, the sqlite3 gem is the form sqlite3-ruby renamed. In any case it throws the same exceptions when trying to build against SQLite-3.3.6. There is no interest evidenced on the part of the gem author to change this. Quite the contrary. As I wrote originally, I am constrained by the RedHat distribution (via CentOS) to use a version of SQLite that the current DBMS adapters, of which I am aware, do not support. I have an adapter that works with my version of SQLite and I wish to continue to use it. Why does ActiveRecord not permit it? -- *** E-Mail is NOT a SECURE channel *** James B. Byrne mailto:ByrneJB@Harte-Lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3 -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To post to this group, send email to rubyonrails-core@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-core+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en.
On 28 February 2012 15:49, James B. Byrne <byrnejb@harte-lyne.ca> wrote:> > On Tue, February 28, 2012 09:50, Prem Sichanugrist wrote: >> `sqlite3-ruby` gem is deprecated, and has been replaced >> with `sqlite3` gem. Have you tried bundle that gem instead >> of that? >> >> -Prem >> > > As far as I can tell from the build messages, the sqlite3 > gem is the form sqlite3-ruby renamed. In any case it > throws the same exceptions when trying to build against > SQLite-3.3.6. There is no interest evidenced on the part > of the gem author to change this. Quite the contrary. > > As I wrote originally, I am constrained by the RedHat > distribution (via CentOS) to use a version of SQLite that > the current DBMS adapters, of which I am aware, do not > support. I have an adapter that works with my version of > SQLite and I wish to continue to use it. Why does > ActiveRecord not permit it?A complete shot in the dark, but in database.yml what have you got as the adaptor? If it is not sqlite3 then try that. Colin -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To post to this group, send email to rubyonrails-core@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-core+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en.
On Tue, February 28, 2012 10:56, Colin Law wrote:> > A complete shot in the dark, but in database.yml what > have you got as the adaptor? If it is not sqlite3 > then try that. > > Colin >etl_execution: adapter: sqlite3 database: db/etl.sqlite3 timeout: 5000 I would gladly get rid of SQLite altogether but the ActiveWarehouse gem that we use to load data from our older computer systems depends upon it for housekeeping. I would also contemplae updating SQLite but I cannot. We must use packages provided in the distribution or from authorized repositories (EPEL or Rpmforge) and none provide a more recent version than 3.6.6 for SQLite for RHEL5. The problem apparently lies with ActiveRecord 3.1. The SQLite adapter exists and works with my version of SQLite. ActiveRecord 3.1 complains about not finding it. ActiveRecord 3.0 does not have this problem. To my mind this is a defect. This problem is reported elsewhere. http://intertwingly.net/blog/2011/08/09/Upgrade-Unavailable -- *** E-Mail is NOT a SECURE channel *** James B. Byrne mailto:ByrneJB@Harte-Lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3 -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To post to this group, send email to rubyonrails-core@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-core+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en.