activerecord-jdbc-adapter-0.9.2 breaks my program (ActiveRecordError: Syntax
error: Encountered "FETCH")
--------------------------------------------------------------------------------------------------------
Key: JRUBY-4229
URL: http://jira.codehaus.org/browse/JRUBY-4229
Project: JRuby
Issue Type: Bug
Components: JRuby-extras
Affects Versions: JRuby 1.3.1
Environment: Ubuntu 9.04, JRuby 1.3.1,
activerecord-jdbc-adapter-0.9.2, Rails 2.3.2 & 2.3.4 (I tried both), Derby db
Reporter: James Lavin
Priority: Blocker
My Rails program runs fine if I revert to activerecord-jdbc-adapter-0.9.1.
Under 0.9.2, I get the following:
Processing MoviesController#index (for at 2009-11-11 22:26:28) [GET]
Parameters: {"controller"=>"movies", "action"=>"index"}
ActiveRecord::StatementInvalid (ActiveRecord::ActiveRecordError: Syntax error:
Encountered "FETCH" at line 1, column 43.: SELECT * FROM users WHERE (users.id
= 1) FETCH FIRST 1 ROWS ONLY):
/home/james/Tech/Ruby/JRuby/jruby-1.3.1/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.9.2/lib/active_record/connection_adapters/jdbc_adapter.rb:559:in
`execute'
/home/james/Tech/Ruby/JRuby/jruby-1.3.1/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.9.2/lib/jdbc_adapter/jdbc_derby.rb:228:in
`execute'
/home/james/Tech/Ruby/JRuby/jruby-1.3.1/lib/ruby/gems/1.8/gems/mislav-will_paginate-2.3.11/lib/will_paginate/finder.rb:170:in
`method_missing_with_paginate'
lib/authenticated_system.rb:108:in `login_from_session'
lib/authenticated_system.rb:12:in `current_user'
lib/authenticated_system.rb:6:in `logged_in?'
lib/authenticated_system.rb:35:in `authorized?'
lib/authenticated_system.rb:53:in `login_required'
file:tmp/.glassfish/static-cache/gf/glassfish.jar!/rack/adapter/rails.rb:82:in
`serve_rails'
file:tmp/.glassfish/static-cache/gf/glassfish.jar!/rack/adapter/rails.rb:109:in
`call'
file:tmp/.glassfish/static-cache/gf/glassfish.jar!/jruby/rack/rails.rb:69:in
`call'
file:tmp/.glassfish/static-cache/gf/glassfish.jar!/rack/handler/grizzly.rb:55:in
`call'
:1
Rendering /home/james/Rails_projects/jimmyflix_dist/public/500.html (500
Internal Server Error)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
