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 <http://localhost:3333/site_alerts/show#> | Framework
Trace <http://localhost:3333/site_alerts/show#> | Full
Trace<http://localhost:3333/site_alerts/show#>
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 <http://localhost:3333/site_alerts/show#>
mail: "saideep.a-xthvdsQ13ZrQT0dZR+AlfA@public.gmane.org"
Show env dump <http://localhost:3333/site_alerts/show#>
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"
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",
"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-xthvdsQ13ZrQT0dZR+AlfA@public.gmane.org"},
"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-xthvdsQ13ZrQT0dZR+AlfA@public.gmane.org",
@_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",
"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-xthvdsQ13ZrQT0dZR+AlfA@public.gmane.org"},
"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",
"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-xthvdsQ13ZrQT0dZR+AlfA@public.gmane.org"},
"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",
"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-xthvdsQ13ZrQT0dZR+AlfA@public.gmane.org"},
"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-xthvdsQ13ZrQT0dZR+AlfA@public.gmane.org",
@_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-xthvdsQ13ZrQT0dZR+AlfA@public.gmane.org"}
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-xthvdsQ13ZrQT0dZR+AlfA@public.gmane.org
--------------------------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
) 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
--
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.