Forum: JRuby jdbc-firebird

F33408c4e5dd817c41c98cb743c96269?d=identicon&s=25 Rick F. (rickrails)
on 2014-07-22 17:07
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
3d77f8da992a51cc7502f72231c49ee9?d=identicon&s=25 Adrian Marius P. (adrianmarius_p)
on 2014-07-23 13:43
Seems to be a Visitors issue

Here is the source for the jruby Firebird Visitor

https://github.com/jruby/activerecord-jdbc-adapter...


and compare it with the one from MRuby

https://github.com/rowland/activerecord-fb-adapter...

I will install a jruby rvm and test the jruby version


ps: In future Firebird visitor should be pushed to Arel
Please log in before posting. Registration is free and takes only a minute.
Existing account

NEW: Do you have a Google/GoogleMail, Yahoo or Facebook account? No registration required!
Log in with Google account | Log in with Yahoo account | Log in with Facebook account
No account? Register here.