I'm currently using the Ruby SQLA connectors (https://github.com/sqlanywhere) with Rail 3.0.7 & Ruby 1.9.2 without any problems. After upgrading to Rails 3.0.10 I'm getting the following error:
ActiveRecord::StatementInvalid (ActiveRecord::ConnectionAdapters::SQLAnywhereException: Syntax error near '<' on line 1: SELECT TOP #<arel::nodes::limit:0xbdd77cc> "sessions".* FROM "sessions" WHERE "sessions"."session_id" = '297bc97413b5d1da5c765f8b98f2c06b'):
Has anyone else struck this problem, any ideas on what the cause could be?
asked 08 Sep '11, 18:30
Just giving you the heads up that I have created a fork that fixes the issues with calling .find, .first and .last, here: https://github.com/Sharagoz/activerecord-sqlanywhere-adapter
I'm looking into fixing the 3.1 compatibility issues as we speak.
answered 19 Oct '11, 14:14
I have found a small problem in Sharagoz's fork when used with the latest active_scaffold. It was easily fixed thanks to the work of Sharagoz. I have created a fork here: https://github.com/clst/activerecord-sqlanywhere-adapter
Thanks for your efforts Sharagoz.
I am using this version with Rails 3.1 and the Sybase 12 client on Ubuntu 10.04 x86_64 without issues so far.