Regarding Will_paginate and ActiveRecord_JDBC adapter

Venkat · May 3, 2011, 8:53am

Hello All,

          Greetings. This is with regards to an issue am facing while trying to integrate will_paginate into my Rails 3 application. A little overview on the versions I am using.

rails (3.0.0)

activerecord-jdbc-adapter (1.1.1) arel (1.0.1) will_paginate (3.0.pre2) jruby-1.5.6 [ x86-java ] and I am using DB2 database

                 I have followed the instructions to integrate the will_paginate. The following are the codes :  ( Codes attached in code.txt)

The ISSUE:

                While trying to access the show page, I am getting stuck with the following error on the broswer:   (I am attaching the full trace for reference.)

ActiveRecord::StatementInvalid

in Site alertsController#show

ActiveRecord::JDBCError: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=desc;ORDER BY startdate;<interval_qualifier>, DRIVER=3.57.82: SELECT site_alerts.* FROM site_alerts ORDER BY startdate desc) A ) B WHERE B.internal$rownum > 0 AND B.internal$rownum <= 3

Rails.root: /home/saideep/Rails/dynamo

Application Trace | Framework Trace | Full Trace

app/controllers/site_alerts_controller.rb:31:in `show'

activerecord (3.0.0) lib/active_record/connection_adapters/abstract_adapter.rb:202:in `log'
activerecord-jdbc-adapter (1.1.1) lib/arjdbc/jdbc/adapter.rb:183:in `execute'
activerecord-jdbc-adapter (1.1.1) lib/arjdbc/jdbc/adapter.rb:275:in `select'
activerecord (3.0.0) lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all'
activerecord (3.0.0) lib/active_record/connection_adapters/abstract/query_cache.rb:54:in `select_all'
activerecord (3.0.0) lib/active_record/connection_adapters/abstract/query_cache.rb:68:in `cache_sql'
activerecord (3.0.0) lib/active_record/connection_adapters/abstract/query_cache.rb:54:in `select_all'
activerecord (3.0.0) lib/active_record/base.rb:467:in `find_by_sql'
activerecord (3.0.0) lib/active_record/relation.rb:64:in `to_a'
activerecord (3.0.0) lib/active_record/relation/finder_methods.rb:143:in `all'
activerecord (3.0.0) lib/active_record/relation/finder_methods.rb:105:in `find'
activerecord (3.0.0) lib/active_record/relation/finder_methods.rb:101:in `find'
activerecord (3.0.0) lib/active_record/base.rb:439:in `find'
will_paginate (3.0.pre2) lib/will_paginate/finders/active_record.rb:91:in `wp_query'
will_paginate (3.0.pre2) lib/will_paginate/finders/base.rb:64:in `paginate'
will_paginate (3.0.pre2) lib/will_paginate/collection.rb:87:in `create'
will_paginate (3.0.pre2) lib/will_paginate/finders/base.rb:62:in `paginate'
actionpack (3.0.0) lib/action_controller/metal/implicit_render.rb:4:in `send_action'
actionpack (3.0.0) lib/abstract_controller/base.rb:150:in `process_action'
actionpack (3.0.0) lib/action_controller/metal/rendering.rb:11:in `process_action'
actionpack (3.0.0) lib/abstract_controller/callbacks.rb:18:in `process_action'
activesupport (3.0.0) lib/active_support/callbacks.rb:453:in `_run__801560423__process_action__453433196__callbacks'
activesupport (3.0.0) lib/active_support/callbacks.rb:424:in `_run_process_action_callbacks'
activesupport (3.0.0) lib/active_support/callbacks.rb:93:in `run_callbacks'
actionpack (3.0.0) lib/abstract_controller/callbacks.rb:17:in `process_action'
actionpack (3.0.0) lib/action_controller/metal/instrumentation.rb:30:in `process_action'
activesupport (3.0.0) lib/active_support/notifications.rb:52:in `instrument'
activesupport (3.0.0) lib/active_support/notifications/instrumenter.rb:21:in `instrument'
activesupport (3.0.0) lib/active_support/notifications.rb:52:in `instrument'
actionpack (3.0.0) lib/action_controller/metal/instrumentation.rb:29:in `process_action'
actionpack (3.0.0) lib/action_controller/metal/rescue.rb:17:in `process_action'
actionpack (3.0.0) lib/abstract_controller/base.rb:119:in `process'
actionpack (3.0.0) lib/abstract_controller/rendering.rb:40:in `process'
actionpack (3.0.0) lib/action_controller/metal.rb:133:in `dispatch'
actionpack (3.0.0) lib/action_controller/metal/rack_delegation.rb:14:in `dispatch'
actionpack (3.0.0) lib/action_controller/metal.rb:173:in `action'
actionpack (3.0.0) lib/action_dispatch/routing/route_set.rb:62:in `call'
actionpack (3.0.0) lib/action_dispatch/routing/route_set.rb:62:in `dispatch'
actionpack (3.0.0) lib/action_dispatch/routing/route_set.rb:27:in `call'
rack-mount (0.6.14) lib/rack/mount/route_set.rb:148:in `call'
rack-mount (0.6.14) lib/rack/mount/code_generation.rb:111:in `recognize'
rack-mount (0.6.14) lib/rack/mount/code_generation.rb:241:in `optimized_each'
rack-mount (0.6.14) lib/rack/mount/code_generation.rb:110:in `recognize'
rack-mount (0.6.14) lib/rack/mount/route_set.rb:139:in `call'
actionpack (3.0.0) lib/action_dispatch/routing/route_set.rb:492:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/best_standards_support.rb:17:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/head.rb:14:in `call'
rack (1.2.2) lib/rack/methodoverride.rb:24:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/params_parser.rb:21:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/flash.rb:182:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/session/abstract_store.rb:149:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/cookies.rb:287:in `call'
activerecord (3.0.0) lib/active_record/query_cache.rb:32:in `call'
activerecord (3.0.0) lib/active_record/connection_adapters/abstract/query_cache.rb:28:in `cache'
activerecord (3.0.0) lib/active_record/query_cache.rb:12:in `cache'
activerecord (3.0.0) lib/active_record/query_cache.rb:31:in `call'
activerecord (3.0.0) lib/active_record/connection_adapters/abstract/connection_pool.rb:355:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/callbacks.rb:46:in `call'
activesupport (3.0.0) lib/active_support/callbacks.rb:430:in `_run_call_callbacks'
actionpack (3.0.0) lib/action_dispatch/middleware/callbacks.rb:44:in `call'
rack (1.2.2) lib/rack/sendfile.rb:107:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/remote_ip.rb:48:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/show_exceptions.rb:46:in `call'
railties (3.0.0) lib/rails/rack/logger.rb:13:in `call'
rack (1.2.2) lib/rack/runtime.rb:17:in `call'
activesupport (3.0.0) lib/active_support/cache/strategy/local_cache.rb:90:in `call'
rack (1.2.2) lib/rack/lock.rb:11:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/static.rb:30:in `call'
railties (3.0.0) lib/rails/application.rb:168:in `call'
railties (3.0.0) lib/rails/application.rb:77:in `method_missing'
railties (3.0.0) lib/rails/rack/log_tailer.rb:14:in `call'
rack (1.2.2) lib/rack/content_length.rb:13:in `call'
rack (1.2.2) lib/rack/handler/webrick.rb:52:in `service'
/home/saideep/.rvm/rubies/jruby-1.5.6/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
/home/saideep/.rvm/rubies/jruby-1.5.6/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
/home/saideep/.rvm/rubies/jruby-1.5.6/lib/ruby/1.8/webrick/server.rb:174:in `start_thread'
/home/saideep/.rvm/rubies/jruby-1.5.6/lib/ruby/1.8/webrick/server.rb:163:in `start'
/home/saideep/.rvm/rubies/jruby-1.5.6/lib/ruby/1.8/webrick/server.rb:163:in `start_thread'
/home/saideep/.rvm/rubies/jruby-1.5.6/lib/ruby/1.8/webrick/server.rb:95:in `start'
/home/saideep/.rvm/rubies/jruby-1.5.6/lib/ruby/1.8/webrick/server.rb:92:in `each'
/home/saideep/.rvm/rubies/jruby-1.5.6/lib/ruby/1.8/webrick/server.rb:92:in `start'
/home/saideep/.rvm/rubies/jruby-1.5.6/lib/ruby/1.8/webrick/server.rb:23:in `start'
/home/saideep/.rvm/rubies/jruby-1.5.6/lib/ruby/1.8/webrick/server.rb:82:in `start'
rack (1.2.2) lib/rack/handler/webrick.rb:13:in `run'
rack (1.2.2) lib/rack/server.rb:213:in `start'
railties (3.0.0) lib/rails/commands/server.rb:65:in `start'
railties (3.0.0) lib/rails/commands.rb:30
railties (3.0.0) lib/rails/commands.rb:27:in `tap'
railties (3.0.0) lib/rails/commands.rb:27
railties (3.0.0) lib/rails/commands.rb:6:in `require'
script/rails:6

activerecord (3.0.0) lib/active_record/connection_adapters/abstract_adapter.rb:202:in `log'
activerecord-jdbc-adapter (1.1.1) lib/arjdbc/jdbc/adapter.rb:183:in `execute'
activerecord-jdbc-adapter (1.1.1) lib/arjdbc/jdbc/adapter.rb:275:in `select'
activerecord (3.0.0) lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all'
activerecord (3.0.0) lib/active_record/connection_adapters/abstract/query_cache.rb:54:in `select_all'
activerecord (3.0.0) lib/active_record/connection_adapters/abstract/query_cache.rb:68:in `cache_sql'
activerecord (3.0.0) lib/active_record/connection_adapters/abstract/query_cache.rb:54:in `select_all'
activerecord (3.0.0) lib/active_record/base.rb:467:in `find_by_sql'
activerecord (3.0.0) lib/active_record/relation.rb:64:in `to_a'
activerecord (3.0.0) lib/active_record/relation/finder_methods.rb:143:in `all'
activerecord (3.0.0) lib/active_record/relation/finder_methods.rb:105:in `find'
activerecord (3.0.0) lib/active_record/relation/finder_methods.rb:101:in `find'
activerecord (3.0.0) lib/active_record/base.rb:439:in `find'
will_paginate (3.0.pre2) lib/will_paginate/finders/active_record.rb:91:in `wp_query'
will_paginate (3.0.pre2) lib/will_paginate/finders/base.rb:64:in `paginate'
will_paginate (3.0.pre2) lib/will_paginate/collection.rb:87:in `create'
will_paginate (3.0.pre2) lib/will_paginate/finders/base.rb:62:in `paginate'
app/controllers/site_alerts_controller.rb:31:in `show'
actionpack (3.0.0) lib/action_controller/metal/implicit_render.rb:4:in `send_action'
actionpack (3.0.0) lib/abstract_controller/base.rb:150:in `process_action'
actionpack (3.0.0) lib/action_controller/metal/rendering.rb:11:in `process_action'
actionpack (3.0.0) lib/abstract_controller/callbacks.rb:18:in `process_action'
activesupport (3.0.0) lib/active_support/callbacks.rb:453:in `_run__801560423__process_action__453433196__callbacks'
activesupport (3.0.0) lib/active_support/callbacks.rb:424:in `_run_process_action_callbacks'
activesupport (3.0.0) lib/active_support/callbacks.rb:93:in `run_callbacks'
actionpack (3.0.0) lib/abstract_controller/callbacks.rb:17:in `process_action'
actionpack (3.0.0) lib/action_controller/metal/instrumentation.rb:30:in `process_action'
activesupport (3.0.0) lib/active_support/notifications.rb:52:in `instrument'
activesupport (3.0.0) lib/active_support/notifications/instrumenter.rb:21:in `instrument'
activesupport (3.0.0) lib/active_support/notifications.rb:52:in `instrument'
actionpack (3.0.0) lib/action_controller/metal/instrumentation.rb:29:in `process_action'
actionpack (3.0.0) lib/action_controller/metal/rescue.rb:17:in `process_action'
actionpack (3.0.0) lib/abstract_controller/base.rb:119:in `process'
actionpack (3.0.0) lib/abstract_controller/rendering.rb:40:in `process'
actionpack (3.0.0) lib/action_controller/metal.rb:133:in `dispatch'
actionpack (3.0.0) lib/action_controller/metal/rack_delegation.rb:14:in `dispatch'
actionpack (3.0.0) lib/action_controller/metal.rb:173:in `action'
actionpack (3.0.0) lib/action_dispatch/routing/route_set.rb:62:in `call'
actionpack (3.0.0) lib/action_dispatch/routing/route_set.rb:62:in `dispatch'
actionpack (3.0.0) lib/action_dispatch/routing/route_set.rb:27:in `call'
rack-mount (0.6.14) lib/rack/mount/route_set.rb:148:in `call'
rack-mount (0.6.14) lib/rack/mount/code_generation.rb:111:in `recognize'
rack-mount (0.6.14) lib/rack/mount/code_generation.rb:241:in `optimized_each'
rack-mount (0.6.14) lib/rack/mount/code_generation.rb:110:in `recognize'
rack-mount (0.6.14) lib/rack/mount/route_set.rb:139:in `call'
actionpack (3.0.0) lib/action_dispatch/routing/route_set.rb:492:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/best_standards_support.rb:17:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/head.rb:14:in `call'
rack (1.2.2) lib/rack/methodoverride.rb:24:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/params_parser.rb:21:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/flash.rb:182:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/session/abstract_store.rb:149:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/cookies.rb:287:in `call'
activerecord (3.0.0) lib/active_record/query_cache.rb:32:in `call'
activerecord (3.0.0) lib/active_record/connection_adapters/abstract/query_cache.rb:28:in `cache'
activerecord (3.0.0) lib/active_record/query_cache.rb:12:in `cache'
activerecord (3.0.0) lib/active_record/query_cache.rb:31:in `call'
activerecord (3.0.0) lib/active_record/connection_adapters/abstract/connection_pool.rb:355:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/callbacks.rb:46:in `call'
activesupport (3.0.0) lib/active_support/callbacks.rb:430:in `_run_call_callbacks'
actionpack (3.0.0) lib/action_dispatch/middleware/callbacks.rb:44:in `call'
rack (1.2.2) lib/rack/sendfile.rb:107:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/remote_ip.rb:48:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/show_exceptions.rb:46:in `call'
railties (3.0.0) lib/rails/rack/logger.rb:13:in `call'
rack (1.2.2) lib/rack/runtime.rb:17:in `call'
activesupport (3.0.0) lib/active_support/cache/strategy/local_cache.rb:90:in `call'
rack (1.2.2) lib/rack/lock.rb:11:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/static.rb:30:in `call'
railties (3.0.0) lib/rails/application.rb:168:in `call'
railties (3.0.0) lib/rails/application.rb:77:in `method_missing'
railties (3.0.0) lib/rails/rack/log_tailer.rb:14:in `call'
rack (1.2.2) lib/rack/content_length.rb:13:in `call'
rack (1.2.2) lib/rack/handler/webrick.rb:52:in `service'
/home/saideep/.rvm/rubies/jruby-1.5.6/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
/home/saideep/.rvm/rubies/jruby-1.5.6/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
/home/saideep/.rvm/rubies/jruby-1.5.6/lib/ruby/1.8/webrick/server.rb:174:in `start_thread'
/home/saideep/.rvm/rubies/jruby-1.5.6/lib/ruby/1.8/webrick/server.rb:163:in `start'
/home/saideep/.rvm/rubies/jruby-1.5.6/lib/ruby/1.8/webrick/server.rb:163:in `start_thread'
/home/saideep/.rvm/rubies/jruby-1.5.6/lib/ruby/1.8/webrick/server.rb:95:in `start'
/home/saideep/.rvm/rubies/jruby-1.5.6/lib/ruby/1.8/webrick/server.rb:92:in `each'
/home/saideep/.rvm/rubies/jruby-1.5.6/lib/ruby/1.8/webrick/server.rb:92:in `start'
/home/saideep/.rvm/rubies/jruby-1.5.6/lib/ruby/1.8/webrick/server.rb:23:in `start'
/home/saideep/.rvm/rubies/jruby-1.5.6/lib/ruby/1.8/webrick/server.rb:82:in `start'
rack (1.2.2) lib/rack/handler/webrick.rb:13:in `run'
rack (1.2.2) lib/rack/server.rb:213:in `start'
railties (3.0.0) lib/rails/commands/server.rb:65:in `start'
railties (3.0.0) lib/rails/commands.rb:30
railties (3.0.0) lib/rails/commands.rb:27:in `tap'
railties (3.0.0) lib/rails/commands.rb:27
railties (3.0.0) lib/rails/commands.rb:6:in `require'
script/rails:6

Request

Parameters:

{"id"=>"show"}

Show session dump

mail: "saideep.a@in.ibm.com"

Show env dump

GATEWAY_INTERFACE: "CGI/1.1"
HTTP_ACCEPT: "text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8"
HTTP_ACCEPT_CHARSET: "ISO-8859-1,utf-8;q=0.7,*;q=0.7"
HTTP_ACCEPT_ENCODING: "gzip,deflate"
HTTP_ACCEPT_LANGUAGE: "en-us,en;q=0.5"
HTTP_AUTHORIZATION: "Basic c2FpZGVlcC5hQGluLmlibS5jb206U0tJUA=="
HTTP_CONNECTION: "keep-alive"
HTTP_HOST: "localhost:3333"
HTTP_KEEP_ALIVE: "115"
HTTP_USER_AGENT: "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Ubuntu/10.04 (CK-IBM) (CK-IBM) Firefox/3.6.3"
HTTP_VERSION: "HTTP/1.1"
PATH_INFO: "/site_alerts/show"
QUERY_STRING: ""
REMOTE_ADDR: "0:0:0:0:0:0:0:1"
REMOTE_HOST: "localhost"
REQUEST_METHOD: "GET"
REQUEST_PATH: "/"
REQUEST_URI: "[http://localhost:3333/site_alerts/show](http://localhost:3333/site_alerts/show)"
SCRIPT_NAME: ""
SERVER_NAME: "localhost"
SERVER_PORT: "3333"
SERVER_PROTOCOL: "HTTP/1.1"
SERVER_SOFTWARE: "WEBrick/1.3.1 (Ruby/1.8.7/2010-12-03)"
action_controller.instance: #<SiteAlertsController:0x7f907f90 @_response=#<ActionDispatch::Response:0x2270227 @cache_control={}, @sending_file=false, @body=[], @cookie=[], @length=0, @block=nil, @header={}, @request=#<ActionDispatch::Request:0x17c017c @method="GET", @request_method="GET", @filtered_parameters={"action"=>"show", "controller"=>"site_alerts", "id"=>"show"}, @fullpath="/site_alerts/show", @env={"GATEWAY_INTERFACE"=>"CGI/1.1", "PATH_INFO"=>"/site_alerts/show", "QUERY_STRING"=>"", "REMOTE_ADDR"=>"0:0:0:0:0:0:0:1", "REMOTE_HOST"=>"localhost", "REQUEST_METHOD"=>"GET", "REQUEST_URI"=>"[http://localhost:3333/site_alerts/show](http://localhost:3333/site_alerts/show)", "SCRIPT_NAME"=>"", "SERVER_NAME"=>"localhost", "SERVER_PORT"=>"3333", "SERVER_PROTOCOL"=>"HTTP/1.1", "SERVER_SOFTWARE"=>"WEBrick/1.3.1 (Ruby/1.8.7/2010-12-03)", "HTTP_HOST"=>"localhost:3333", "HTTP_USER_AGENT"=>"Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Ubuntu/10.04 (CK-IBM) (CK-IBM) Firefox/3.6.3", "HTTP_ACCEPT"=>"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8", "HTTP_ACCEPT_LANGUAGE"=>"en-us,en;q=0.5", "HTTP_ACCEPT_ENCODING"=>"gzip,deflate", "HTTP_ACCEPT_CHARSET"=>"ISO-8859-1,utf-8;q=0.7,*;q=0.7", "HTTP_KEEP_ALIVE"=>"115", "HTTP_CONNECTION"=>"keep-alive", "HTTP_AUTHORIZATION"=>"Basic c2FpZGVlcC5hQGluLmlibS5jb206U0tJUA==", "rack.version"=>[1, 1], "rack.input"=>#<StringIO:0x176e176e>, "rack.errors"=>#<IO:0x7c7d7c7d>, "rack.multithread"=>false, "rack.multiprocess"=>false, "rack.run_once"=>false, "rack.url_scheme"=>"http", "HTTP_VERSION"=>"HTTP/1.1", "REQUEST_PATH"=>"/", "action_dispatch.parameter_filter"=>[:password], "action_dispatch.secret_token"=>"1dc8c6cb72d00b274fd554825140c284fb1bb775f42f6cadc317e7ba28d1b736a16ce723ba9a59491684b7619e666f9e771568c5e41c30903a5cf9e786b72285", "action_dispatch.remote_ip"=>#<ActionDispatch::RemoteIp::RemoteIpGetter:0x25392539 @trusted_proxies=/(^127\.0\.0\.1$|^(10|172\.(1[6-9]|2[0-9]|30|31)|192\.168)\.)/i, @env={...}, @check_ip_spoofing=true>, "rack.session"=>{"mail"=>"saideep.a@in.ibm.com"}, "rack.session.options"=>{:path=>"/", :domain=>nil, :expire_after=>nil, :secure=>false, :httponly=>true, :id=>"61654eaeefc806cdc35057c0993e4c2d"}, "action_dispatch.request.path_parameters"=>{:action=>"show", :controller=>"site_alerts", :id=>"show"}, "action_controller.instance"=>#<SiteAlertsController:0x7f907f90 ...>, "action_dispatch.request.content_type"=>nil, "action_dispatch.request.request_parameters"=>{}, "rack.request.query_string"=>"", "rack.request.query_hash"=>{}, "action_dispatch.request.query_parameters"=>{}, "action_dispatch.request.parameters"=>{"action"=>"show", "controller"=>"site_alerts", "id"=>"show"}, "action_dispatch.request.formats"=>[#<Mime::Type:0x20482048 @symbol=:html, @synonyms=["application/xhtml+xml"], @string="text/html">], "rack.session.record"=>#<ActiveRecord::SessionStore::Session id: nil, session_id: "61654eaeefc806cdc35057c0993e4c2d", data: nil, created_at: nil, updated_at: nil>}>, @status=200, @writer=#<Proc:0x2a102a1@/home/saideep/.rvm/gems/jruby-1.5.6@jruby1561/gems/actionpack-3.0.0/lib/action_dispatch/http/response.rb:44>, @blank=false, @etag=nil>, @_config=#<OrderedHash {}>, @_response_body=nil, @nav={:title=>"Site Alerts ", :exclude=>:dynamo, :location=>:site_alerts}, @_params={"action"=>"show", "controller"=>"site_alerts", "id"=>"show"}, @_headers={"Content-Type"=>"text/html"}, @lookup_context=#<ActionView::LookupContext:0x45d045d @skip_default_locale=false, @details_key=nil, @details={:handlers=>[:erb, :rjs, :builder, :rhtml, :rxml], :formats=>[:html], :locale=>[:en, :en]}, @view_paths=[#<ActionView::FileSystemResolver:0x1aee1aee @path="/home/saideep/Rails/dynamo/app/views", @cached={}>, #<ActionView::FileSystemResolver:0x16c516c5 @path="/home/saideep/Rails/dynamo/vendor/plugins/country_select/app/views", @cached={}>, #<ActionView::FileSystemResolver:0x12991299 @path="/home/saideep/Rails/dynamo/vendor/plugins/calendar_date_select/app/views", @cached={}>, #<ActionView::FileSystemResolver:0xdbd0dbd @path="/home/saideep/Rails/dynamo/vendor/plugins/acts_as_tree/app/views", @cached={}>], @frozen_formats=false>, @user="saideep.a@in.ibm.com", @_env={"GATEWAY_INTERFACE"=>"CGI/1.1", "PATH_INFO"=>"/site_alerts/show", "QUERY_STRING"=>"", "REMOTE_ADDR"=>"0:0:0:0:0:0:0:1", "REMOTE_HOST"=>"localhost", "REQUEST_METHOD"=>"GET", "REQUEST_URI"=>"[http://localhost:3333/site_alerts/show](http://localhost:3333/site_alerts/show)", "SCRIPT_NAME"=>"", "SERVER_NAME"=>"localhost", "SERVER_PORT"=>"3333", "SERVER_PROTOCOL"=>"HTTP/1.1", "SERVER_SOFTWARE"=>"WEBrick/1.3.1 (Ruby/1.8.7/2010-12-03)", "HTTP_HOST"=>"localhost:3333", "HTTP_USER_AGENT"=>"Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Ubuntu/10.04 (CK-IBM) (CK-IBM) Firefox/3.6.3", "HTTP_ACCEPT"=>"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8", "HTTP_ACCEPT_LANGUAGE"=>"en-us,en;q=0.5", "HTTP_ACCEPT_ENCODING"=>"gzip,deflate", "HTTP_ACCEPT_CHARSET"=>"ISO-8859-1,utf-8;q=0.7,*;q=0.7", "HTTP_KEEP_ALIVE"=>"115", "HTTP_CONNECTION"=>"keep-alive", "HTTP_AUTHORIZATION"=>"Basic c2FpZGVlcC5hQGluLmlibS5jb206U0tJUA==", "rack.version"=>[1, 1], "rack.input"=>#<StringIO:0x176e176e>, "rack.errors"=>#<IO:0x7c7d7c7d>, "rack.multithread"=>false, "rack.multiprocess"=>false, "rack.run_once"=>false, "rack.url_scheme"=>"http", "HTTP_VERSION"=>"HTTP/1.1", "REQUEST_PATH"=>"/", "action_dispatch.parameter_filter"=>[:password], "action_dispatch.secret_token"=>"1dc8c6cb72d00b274fd554825140c284fb1bb775f42f6cadc317e7ba28d1b736a16ce723ba9a59491684b7619e666f9e771568c5e41c30903a5cf9e786b72285", "action_dispatch.remote_ip"=>#<ActionDispatch::RemoteIp::RemoteIpGetter:0x25392539 @trusted_proxies=/(^127\.0\.0\.1$|^(10|172\.(1[6-9]|2[0-9]|30|31)|192\.168)\.)/i, @env={...}, @check_ip_spoofing=true>, "rack.session"=>{"mail"=>"saideep.a@in.ibm.com"}, "rack.session.options"=>{:path=>"/", :domain=>nil, :expire_after=>nil, :secure=>false, :httponly=>true, :id=>"61654eaeefc806cdc35057c0993e4c2d"}, "action_dispatch.request.path_parameters"=>{:action=>"show", :controller=>"site_alerts", :id=>"show"}, "action_controller.instance"=>#<SiteAlertsController:0x7f907f90 ...>, "action_dispatch.request.content_type"=>nil, "action_dispatch.request.request_parameters"=>{}, "rack.request.query_string"=>"", "rack.request.query_hash"=>{}, "action_dispatch.request.query_parameters"=>{}, "action_dispatch.request.parameters"=>{"action"=>"show", "controller"=>"site_alerts", "id"=>"show"}, "action_dispatch.request.formats"=>[#<Mime::Type:0x20482048 @symbol=:html, @synonyms=["application/xhtml+xml"], @string="text/html">], "rack.session.record"=>#<ActiveRecord::SessionStore::Session id: nil, session_id: "61654eaeefc806cdc35057c0993e4c2d", data: nil, created_at: nil, updated_at: nil>}, @view_context_class=nil, @_request=#<ActionDispatch::Request:0x17c017c @method="GET", @request_method="GET", @filtered_parameters={"action"=>"show", "controller"=>"site_alerts", "id"=>"show"}, @fullpath="/site_alerts/show", @env={"GATEWAY_INTERFACE"=>"CGI/1.1", "PATH_INFO"=>"/site_alerts/show", "QUERY_STRING"=>"", "REMOTE_ADDR"=>"0:0:0:0:0:0:0:1", "REMOTE_HOST"=>"localhost", "REQUEST_METHOD"=>"GET", "REQUEST_URI"=>"[http://localhost:3333/site_alerts/show](http://localhost:3333/site_alerts/show)", "SCRIPT_NAME"=>"", "SERVER_NAME"=>"localhost", "SERVER_PORT"=>"3333", "SERVER_PROTOCOL"=>"HTTP/1.1", "SERVER_SOFTWARE"=>"WEBrick/1.3.1 (Ruby/1.8.7/2010-12-03)", "HTTP_HOST"=>"localhost:3333", "HTTP_USER_AGENT"=>"Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Ubuntu/10.04 (CK-IBM) (CK-IBM) Firefox/3.6.3", "HTTP_ACCEPT"=>"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8", "HTTP_ACCEPT_LANGUAGE"=>"en-us,en;q=0.5", "HTTP_ACCEPT_ENCODING"=>"gzip,deflate", "HTTP_ACCEPT_CHARSET"=>"ISO-8859-1,utf-8;q=0.7,*;q=0.7", "HTTP_KEEP_ALIVE"=>"115", "HTTP_CONNECTION"=>"keep-alive", "HTTP_AUTHORIZATION"=>"Basic c2FpZGVlcC5hQGluLmlibS5jb206U0tJUA==", "rack.version"=>[1, 1], "rack.input"=>#<StringIO:0x176e176e>, "rack.errors"=>#<IO:0x7c7d7c7d>, "rack.multithread"=>false, "rack.multiprocess"=>false, "rack.run_once"=>false, "rack.url_scheme"=>"http", "HTTP_VERSION"=>"HTTP/1.1", "REQUEST_PATH"=>"/", "action_dispatch.parameter_filter"=>[:password], "action_dispatch.secret_token"=>"1dc8c6cb72d00b274fd554825140c284fb1bb775f42f6cadc317e7ba28d1b736a16ce723ba9a59491684b7619e666f9e771568c5e41c30903a5cf9e786b72285", "action_dispatch.remote_ip"=>#<ActionDispatch::RemoteIp::RemoteIpGetter:0x25392539 @trusted_proxies=/(^127\.0\.0\.1$|^(10|172\.(1[6-9]|2[0-9]|30|31)|192\.168)\.)/i, @env={...}, @check_ip_spoofing=true>, "rack.session"=>{"mail"=>"saideep.a@in.ibm.com"}, "rack.session.options"=>{:path=>"/", :domain=>nil, :expire_after=>nil, :secure=>false, :httponly=>true, :id=>"61654eaeefc806cdc35057c0993e4c2d"}, "action_dispatch.request.path_parameters"=>{:action=>"show", :controller=>"site_alerts", :id=>"show"}, "action_controller.instance"=>#<SiteAlertsController:0x7f907f90 ...>, "action_dispatch.request.content_type"=>nil, "action_dispatch.request.request_parameters"=>{}, "rack.request.query_string"=>"", "rack.request.query_hash"=>{}, "action_dispatch.request.query_parameters"=>{}, "action_dispatch.request.parameters"=>{"action"=>"show", "controller"=>"site_alerts", "id"=>"show"}, "action_dispatch.request.formats"=>[#<Mime::Type:0x20482048 @symbol=:html, @synonyms=["application/xhtml+xml"], @string="text/html">], "rack.session.record"=>#<ActiveRecord::SessionStore::Session id: nil, session_id: "61654eaeefc806cdc35057c0993e4c2d", data: nil, created_at: nil, updated_at: nil>}>, @_status=200, @_action_name="show", @action_has_layout=true>
action_dispatch.parameter_filter: [:password]
action_dispatch.remote_ip: #<ActionDispatch::RemoteIp::RemoteIpGetter:0x25392539 @trusted_proxies=/(^127\.0\.0\.1$|^(10|172\.(1[6-9]|2[0-9]|30|31)|192\.168)\.)/i, @env={"GATEWAY_INTERFACE"=>"CGI/1.1", "PATH_INFO"=>"/site_alerts/show", "QUERY_STRING"=>"", "REMOTE_ADDR"=>"0:0:0:0:0:0:0:1", "REMOTE_HOST"=>"localhost", "REQUEST_METHOD"=>"GET", "REQUEST_URI"=>"[http://localhost:3333/site_alerts/show](http://localhost:3333/site_alerts/show)", "SCRIPT_NAME"=>"", "SERVER_NAME"=>"localhost", "SERVER_PORT"=>"3333", "SERVER_PROTOCOL"=>"HTTP/1.1", "SERVER_SOFTWARE"=>"WEBrick/1.3.1 (Ruby/1.8.7/2010-12-03)", "HTTP_HOST"=>"localhost:3333", "HTTP_USER_AGENT"=>"Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Ubuntu/10.04 (CK-IBM) (CK-IBM) Firefox/3.6.3", "HTTP_ACCEPT"=>"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8", "HTTP_ACCEPT_LANGUAGE"=>"en-us,en;q=0.5", "HTTP_ACCEPT_ENCODING"=>"gzip,deflate", "HTTP_ACCEPT_CHARSET"=>"ISO-8859-1,utf-8;q=0.7,*;q=0.7", "HTTP_KEEP_ALIVE"=>"115", "HTTP_CONNECTION"=>"keep-alive", "HTTP_AUTHORIZATION"=>"Basic c2FpZGVlcC5hQGluLmlibS5jb206U0tJUA==", "rack.version"=>[1, 1], "rack.input"=>#<StringIO:0x176e176e>, "rack.errors"=>#<IO:0x7c7d7c7d>, "rack.multithread"=>false, "rack.multiprocess"=>false, "rack.run_once"=>false, "rack.url_scheme"=>"http", "HTTP_VERSION"=>"HTTP/1.1", "REQUEST_PATH"=>"/", "action_dispatch.parameter_filter"=>[:password], "action_dispatch.secret_token"=>"1dc8c6cb72d00b274fd554825140c284fb1bb775f42f6cadc317e7ba28d1b736a16ce723ba9a59491684b7619e666f9e771568c5e41c30903a5cf9e786b72285", "action_dispatch.remote_ip"=>#<ActionDispatch::RemoteIp::RemoteIpGetter:0x25392539 ...>, "rack.session"=>{"mail"=>"saideep.a@in.ibm.com"}, "rack.session.options"=>{:path=>"/", :domain=>nil, :expire_after=>nil, :secure=>false, :httponly=>true, :id=>"61654eaeefc806cdc35057c0993e4c2d"}, "action_dispatch.request.path_parameters"=>{:action=>"show", :controller=>"site_alerts", :id=>"show"}, "action_controller.instance"=>#<SiteAlertsController:0x7f907f90 @_response=#<ActionDispatch::Response:0x2270227 @cache_control={}, @sending_file=false, @body=[], @cookie=[], @length=0, @block=nil, @header={}, @request=#<ActionDispatch::Request:0x17c017c @method="GET", @request_method="GET", @filtered_parameters={"action"=>"show", "controller"=>"site_alerts", "id"=>"show"}, @fullpath="/site_alerts/show", @env={...}>, @status=200, @writer=#<Proc:0x2a102a1@/home/saideep/.rvm/gems/jruby-1.5.6@jruby1561/gems/actionpack-3.0.0/lib/action_dispatch/http/response.rb:44>, @blank=false, @etag=nil>, @_config=#<OrderedHash {}>, @_response_body=nil, @nav={:title=>"Site Alerts ", :exclude=>:dynamo, :location=>:site_alerts}, @_params={"action"=>"show", "controller"=>"site_alerts", "id"=>"show"}, @_headers={"Content-Type"=>"text/html"}, @lookup_context=#<ActionView::LookupContext:0x45d045d @skip_default_locale=false, @details_key=nil, @details={:handlers=>[:erb, :rjs, :builder, :rhtml, :rxml], :formats=>[:html], :locale=>[:en, :en]}, @view_paths=[#<ActionView::FileSystemResolver:0x1aee1aee @path="/home/saideep/Rails/dynamo/app/views", @cached={}>, #<ActionView::FileSystemResolver:0x16c516c5 @path="/home/saideep/Rails/dynamo/vendor/plugins/country_select/app/views", @cached={}>, #<ActionView::FileSystemResolver:0x12991299 @path="/home/saideep/Rails/dynamo/vendor/plugins/calendar_date_select/app/views", @cached={}>, #<ActionView::FileSystemResolver:0xdbd0dbd @path="/home/saideep/Rails/dynamo/vendor/plugins/acts_as_tree/app/views", @cached={}>], @frozen_formats=false>, @user="saideep.a@in.ibm.com", @_env={...}, @view_context_class=nil, @_request=#<ActionDispatch::Request:0x17c017c @method="GET", @request_method="GET", @filtered_parameters={"action"=>"show", "controller"=>"site_alerts", "id"=>"show"}, @fullpath="/site_alerts/show", @env={...}>, @_status=200, @_action_name="show", @action_has_layout=true>, "action_dispatch.request.content_type"=>nil, "action_dispatch.request.request_parameters"=>{}, "rack.request.query_string"=>"", "rack.request.query_hash"=>{}, "action_dispatch.request.query_parameters"=>{}, "action_dispatch.request.parameters"=>{"action"=>"show", "controller"=>"site_alerts", "id"=>"show"}, "action_dispatch.request.formats"=>[#<Mime::Type:0x20482048 @symbol=:html, @synonyms=["application/xhtml+xml"], @string="text/html">], "rack.session.record"=>#<ActiveRecord::SessionStore::Session id: nil, session_id: "61654eaeefc806cdc35057c0993e4c2d", data: nil, created_at: nil, updated_at: nil>}, @check_ip_spoofing=true>
action_dispatch.request.content_type: nil
action_dispatch.request.formats: [#<Mime::Type:0x20482048 @symbol=:html, @synonyms=["application/xhtml+xml"], @string="text/html">]
action_dispatch.request.parameters: {"action"=>"show", "controller"=>"site_alerts", "id"=>"show"}
action_dispatch.request.path_parameters: {:action=>"show", :controller=>"site_alerts", :id=>"show"}
action_dispatch.request.query_parameters: {}
action_dispatch.request.request_parameters: {}
action_dispatch.secret_token: "1dc8c6cb72d00b274fd554825140c284fb1bb775f42f6cadc317e7ba28d1b736a16ce723ba9a59491684b7619e666f9e771568c5e41c30903a5cf9e786b72285"
rack.errors: #<IO:0x7c7d7c7d>
rack.input: #<StringIO:0x176e176e>
rack.multiprocess: false
rack.multithread: false
rack.request.query_hash: {}
rack.request.query_string: ""
rack.run_once: false
rack.session: {"mail"=>"saideep.a@in.ibm.com"}
rack.session.options: {:path=>"/", :domain=>nil, :expire_after=>nil, :secure=>false, :httponly=>true, :id=>"61654eaeefc806cdc35057c0993e4c2d"}
rack.session.record: #<ActiveRecord::SessionStore::Session id: nil, session_id: "61654eaeefc806cdc35057c0993e4c2d", data: nil, created_at: nil, updated_at: nil>
rack.url_scheme: "http"
rack.version: [1, 1]

Response

Headers:

None

-------------------------------------End of Browser output--------------------

The following is the console output at the webrick:

saideep@saideep-laptop:~/Rails/dynamo$ RAILS_ENV=development jruby -s script/rails server -p 3333

=> Booting WEBrick => Rails 3.0.0 application starting in development on http://0.0.0.0:3333 => Call with -d to detach => Ctrl-C to shutdown server

[2011-05-03 11:33:02] INFO WEBrick 1.3.1

[2011-05-03 11:33:02] INFO ruby 1.8.7 (2010-12-03) [java] [2011-05-03 11:33:07] INFO WEBrick::HTTPServer#start: pid=6083 port=3333

Started GET “/site_alerts/show” for 0:0:0:0:0:0:0:1 at Tue May 03 12:09:02 +0530 2011

Processing by SiteAlertsController#show as HTML Parameters: {“id”=>“show”} Completed 401 Unauthorized in 4ms

Started GET “/site_alerts/show” for 0:0:0:0:0:0:0:1 at Tue May 03 12:09:16 +0530 2011

Processing by SiteAlertsController#show as HTML Parameters: {“id”=>“show”} authenticated user: saideep.a@in.ibm.com --------------------------1---------page-------------

SiteAlert Load (135.0ms) SELECT site_alerts.* FROM site_alerts ORDER BY startdate desc) A ) B WHERE B.internal$rownum > 0 AND B.internal$rownum <= 3 ActiveRecord::JDBCError: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=desc;ORDER BY startdate;<interval_qualifier>, DRIVER=3.57.82: SELECT site_alerts.* FROM site_alerts ORDER BY startdate desc) A ) B WHERE B.internal$rownum > 0 AND B.internal$rownum <= 3

Completed in 1115ms

ActiveRecord::StatementInvalid (ActiveRecord::JDBCError: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=desc;ORDER BY startdate;<interval_qualifier>, DRIVER=3.57.82: SELECT site_alerts.* FROM site_alerts ORDER BY startdate desc) A ) B WHERE B.internal$rownum > 0 AND B.internal$rownum <= 3):

app/controllers/site_alerts_controller.rb:31:in `show’

Rendered /home/saideep/.rvm/gems/jruby-1.5.6@jruby1561/gems/actionpack-3.0.0/lib/action_dispatch/middleware/templates/rescues/_trace.erb (3.0ms) Rendered /home/saideep/.rvm/gems/jruby-1.5.6@jruby1561/gems/actionpack-3.0.0/lib/action_dispatch/middleware/templates/rescues/_request_and_response.erb (19.0ms)

Rendered /home/saideep/.rvm/gems/jruby-1.5.6@jruby1561/gems/actionpack-3.0.0/lib/action_dispatch/middleware/templates/rescues/diagnostics.erb within rescues/layout (51.0ms)

--------------------------End of log----------------------------

           Upon searching and little debugging, I found that it was problem with  limit counter ([http://kenai.com/projects/activerecord-jdbc/lists/issues/archive/2010-09/message/9](http://kenai.com/projects/activerecord-jdbc/lists/issues/archive/2010-09/message/9)  ) and according to the link, there was a patch which was released and it is already existing in my gem files. But still I am stuck with the limit issue I believe.  I request your guidance in making it work.

Please let me know if I am missing something for your reference.

Best Wishes, Saideep Annadatha

code.txt (1.19 KB)

fulltrace.txt (6.67 KB)