Query does not return ResultSet while running spec


#1

hi i have created Blog project using rails.when running spec getting
below error.

Article has a valid factory
Failure/Error: @article = build( :article)
ActiveRecord::StatementInvalid:
ActiveRecord::JDBCError: query does not return ResultSet: PRAGMA
table_info(“articles”)
# arjdbc/jdbc/RubyJdbcConnection.java:734:in execute_query_raw' # /Users/ChandrasekharPasupuleti/.rvm/gems/jruby-1.7.11/gems/activerecord-jdbc-adapter-1.3.13/lib/arjdbc/sqlite3/adapter.rb:344:intable_structure’
#
/Users/ChandrasekharPasupuleti/.rvm/gems/jruby-1.7.11/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract_adapter.rb:280:in
log' # /Users/ChandrasekharPasupuleti/.rvm/gems/jruby-1.7.11/gems/activesupport-3.2.17/lib/active_support/notifications/instrumenter.rb:20:ininstrument’
#
/Users/ChandrasekharPasupuleti/.rvm/gems/jruby-1.7.11/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract_adapter.rb:275:in
log' # /Users/ChandrasekharPasupuleti/.rvm/gems/jruby-1.7.11/gems/activerecord-jdbc-adapter-1.3.13/lib/arjdbc/sqlite3/adapter.rb:344:intable_structure’
# /Users/ChandrasekharPasupuleti/.

Gemfile

source ‘https://rubygems.org

gem ‘rails’, ‘3.2.17’

Bundle edge Rails instead:

gem ‘rails’, :git => ‘git://github.com/rails/rails.git’

gem ‘activerecord-jdbcsqlite3-adapter’
gem ‘jruby-openssl’

group :development, :test do
gem ‘ffaker’
gem ‘factory_girl_rails’
gem ‘rspec-rails’
gem ‘fixture_builder’, github: “pivotal-sharknado/fixture_builder”,
ref: “2ff43b5454979c44ba0b0420f5654fe0409592fb”
gem ‘jasmine-rails’
gem ‘jasmine-jquery-rails’
gem ‘pry-nav’
gem ‘quiet_assets’
end

Gems used only for assets and not required

in production environments by default.

group :assets do
gem ‘sass-rails’, ‘~> 3.2.3’
gem ‘coffee-rails’, ‘~> 3.2.1’

See https://github.com/sstephenson/execjs#readme for more supported

runtimes
gem ‘therubyrhino’

gem ‘uglifier’, ‘>= 1.0.3’
end

gem ‘jquery-rails’

To use ActiveModel has_secure_password

gem ‘bcrypt-ruby’, ‘~> 3.0.0’

To use Jbuilder templates for JSON

gem ‘jbuilder’

Use unicorn as the app server

gem ‘unicorn’

Deploy with Capistrano

gem ‘capistrano’

To use debugger

gem ‘debugger’

Spec-helper-------

ENV[“RAILS_ENV”] ||= ‘test’
require ‘rubygems’
require ‘rails/all’
require_relative ‘…/app/models/article.rb’
require_relative ‘…/spec/factories/articles.rb’
require ‘factory_girl’
require ‘java’
#requ’ire ‘jdbc/postgres’
#Jdbc::Postgres.load_driver
ActiveRecord::Base.establish_connection(:adapter => “sqlite3”, :database
=> “:memory:”)
RSpec.configure do |config|
config.include FactoryGirl::Syntax::Methods
end

Spec------

require ‘spec_helper’

describe Article do
it “has a valid factory” do
@article = build( :article)
end
end

factory—

require ‘factory_girl’

FactoryGirl.define do
factory :article do |f|
f.title “John”
f.text “Doe hjhj hb”
f.created_at “2014-11-21 04:48:39.000000000”
f.updated_at “2014-11-21 04:48:39.000000000”
end
end


#2

Chandra -

I don’t know anything about this, but my gut feeling is that it might be
helpful to pare down the test so that there are fewer moving parts. For
example:

  • does Sqlite access work at all, even with a simple query in plain
    JRuby without Rails?

  • is there a way to test FactoryGirl to see that it’s doing what you
    think it’s doing without a data base?

Also, I noticed you used Postgres before but commented it out, but
switched to Sqlite. Were you having a similar problem with Postgres?

  • Keith

#3

Chandra,

There is some chatter on the AR JDBC Adapter about a similar error when
running rake tasks. Perhaps there is something in that discussion that
may
shed some light on your problem:
https://github.com/jruby/activerecord-jdbc-adapter/issues/482

Ariel V.
e-mail: removed_email_address@domain.invalid
website: http://blog.arielvalentin.com
skype: ariel.s.valentin
twitter: arielvalentin
github: https://github.com/arielvalentin
linkedin: http://www.linkedin.com/profile/view?id=8996534

*simplicity *communication
*feedback *courage *respect

On Sun, Feb 8, 2015 at 12:59 PM, Keith B. removed_email_address@domain.invalid