Forum: JRuby query does not return ResultSet while running spec

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
371f037e847a1e1be0a92ce3f5c7e192?d=identicon&s=25 Chandra Sekhar (chandrarubyforum)
on 2015-02-08 16:45
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:in
`table_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:in
`instrument'
     #
/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:in
`table_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
486ca04f06d968004643ce5b47376ded?d=identicon&s=25 Keith B. (keith_b)
on 2015-02-08 19:00
(Received via mailing list)
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
54147c1a1223b425d4f4f7947c9bba46?d=identicon&s=25 Ariel Valentin (Guest)
on 2015-02-08 19:46
(Received via mailing list)
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...

Ariel Valentin
e-mail: ariel@arielvalentin.com
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 Bennett <keithrbennett@gmail.com>
This topic is locked and can not be replied to.