Jdbc-firebird

addis_a · July 22, 2014, 5:07pm

Hi,

I cannot seem to get the Firebird driver to work from within my jruby
rails 4 app.

When doing a simple access

User.first

I get a Dynamic SQL error:

ActiveRecord::JDBCError: org.firebirdsql.jdbc.FBSQLException: GDS
Exception. 335544569. Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 1
&: &FIRST 1 “USER”.* FROM “USER” ORDER BY “USER”.“ID” ASC

Anyone have firebird working with this gem, activerecord and jruby??? Is
there some configuration gotcha I may be missing?

jruby version: 1.7.13 with ruby 2.0
activerecord-jdbc-adapter 1.3.6
jdbc-firebird 2.2.4
rails 4.1.3

any help is appreciated,
Rick

rickf · July 23, 2014, 1:43pm

Seems to be a Visitors issue

Here is the source for the jruby Firebird Visitor

https://github.com/jruby/activerecord-jdbc-adapter/blob/master/lib/arel/visitors/firebird.rb

and compare it with the one from MRuby

github.com

rowland/activerecord-fb-adapter/blob/master/lib/active_record/connection_adapters/fb_adapter.rb


# Rails 3 & 4 specific database adapter for Firebird (http://firebirdsql.org)
# Author: Brent Rowland <[email protected]>
# Based originally on FireRuby extension by Ken Kunz <[email protected]>

require 'fb'
require 'base64'
require 'arel'

if Arel::VERSION < "6.0.0"
  require 'arel/visitors/fb'
else
  require 'arel/visitors/fb_collector'
end

require 'arel/visitors/bind_visitor'
require 'active_record'
require 'active_record/base'
require 'active_record/connection_adapters/abstract_adapter'
require 'active_record/connection_adapters/fb/database_limits'

This file has been truncated. show original

I will install a jruby rvm and test the jruby version

ps: In future Firebird visitor should be pushed to Arel