Regarding Will_paginate and ActiveRecord_JDBC adapter

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
Tracehttp://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:inexecute’
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:inselect_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:incache_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:infind_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:inall’
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:infind’
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:inwp_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:increate’
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:insend_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:inprocess_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:inrun_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:inprocess_action’
activesupport (3.0.0) lib/active_support/notifications.rb:52:in
instrument' activesupport (3.0.0) lib/active_support/notifications/instrumenter.rb:21:ininstrument’
activesupport (3.0.0) lib/active_support/notifications.rb:52:in
instrument' actionpack (3.0.0) lib/action_controller/metal/instrumentation.rb:29:inprocess_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:inprocess’
actionpack (3.0.0) lib/abstract_controller/rendering.rb:40:in process' actionpack (3.0.0) lib/action_controller/metal.rb:133:indispatch’
actionpack (3.0.0)
lib/action_controller/metal/rack_delegation.rb:14:in dispatch' actionpack (3.0.0) lib/action_controller/metal.rb:173:inaction’
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:indispatch’
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:incall’
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:inoptimized_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:incall’
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:incall’
actionpack (3.0.0) lib/action_dispatch/middleware/head.rb:14:in call' rack (1.2.2) lib/rack/methodoverride.rb:24:incall’
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:incall’
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:incall’
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:incache’
activerecord (3.0.0) lib/active_record/query_cache.rb:12:in cache' activerecord (3.0.0) lib/active_record/query_cache.rb:31:incall’
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:incall’
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:incall’
rack (1.2.2) lib/rack/sendfile.rb:107:in call' actionpack (3.0.0) lib/action_dispatch/middleware/remote_ip.rb:48:incall’
actionpack (3.0.0)
lib/action_dispatch/middleware/show_exceptions.rb:46:in call' railties (3.0.0) lib/rails/rack/logger.rb:13:incall’
rack (1.2.2) lib/rack/runtime.rb:17:in call' activesupport (3.0.0) lib/active_support/cache/strategy/local_cache.rb:90:incall’
rack (1.2.2) lib/rack/lock.rb:11:in call' actionpack (3.0.0) lib/action_dispatch/middleware/static.rb:30:incall’
railties (3.0.0) lib/rails/application.rb:168:in call' railties (3.0.0) lib/rails/application.rb:77:inmethod_missing’
railties (3.0.0) lib/rails/rack/log_tailer.rb:14:in call' rack (1.2.2) lib/rack/content_length.rb:13:incall’
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:inservice’
/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:instart_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:instart_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:ineach’
/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:instart’
/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:inrun’
rack (1.2.2) lib/rack/server.rb:213:in start' railties (3.0.0) lib/rails/commands/server.rb:65:instart’
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:inrequire’
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:inexecute’
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:inselect_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:incache_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:infind_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:inall’
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:infind’
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:inwp_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:increate’
will_paginate (3.0.pre2) lib/will_paginate/finders/base.rb:62:in
paginate' app/controllers/site_alerts_controller.rb:31:inshow’
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:inprocess_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:inprocess_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:inprocess_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:ininstrument’
activesupport (3.0.0)
lib/active_support/notifications/instrumenter.rb:21:in instrument' activesupport (3.0.0) lib/active_support/notifications.rb:52:ininstrument’
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:inprocess_action’
actionpack (3.0.0) lib/abstract_controller/base.rb:119:in process' actionpack (3.0.0) lib/abstract_controller/rendering.rb:40:inprocess’
actionpack (3.0.0) lib/action_controller/metal.rb:133:in dispatch' actionpack (3.0.0) lib/action_controller/metal/rack_delegation.rb:14:indispatch’
actionpack (3.0.0) lib/action_controller/metal.rb:173:in action' actionpack (3.0.0) lib/action_dispatch/routing/route_set.rb:62:incall’
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:incall’
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:inrecognize’
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:inrecognize’
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:incall’
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:incall’
rack (1.2.2) lib/rack/methodoverride.rb:24:in call' actionpack (3.0.0) lib/action_dispatch/middleware/params_parser.rb:21:incall’
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:incall’
actionpack (3.0.0) lib/action_dispatch/middleware/cookies.rb:287:in
call' activerecord (3.0.0) lib/active_record/query_cache.rb:32:incall’
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:incache’
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:incall’
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:incall’
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:incall’
railties (3.0.0) lib/rails/rack/logger.rb:13:in call' rack (1.2.2) lib/rack/runtime.rb:17:incall’
activesupport (3.0.0)
lib/active_support/cache/strategy/local_cache.rb:90:in call' rack (1.2.2) lib/rack/lock.rb:11:incall’
actionpack (3.0.0) lib/action_dispatch/middleware/static.rb:30:in call' railties (3.0.0) lib/rails/application.rb:168:incall’
railties (3.0.0) lib/rails/application.rb:77:in method_missing' railties (3.0.0) lib/rails/rack/log_tailer.rb:14:incall’
rack (1.2.2) lib/rack/content_length.rb:13:in call' rack (1.2.2) lib/rack/handler/webrick.rb:52:inservice’
/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:inrun’
/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:instart’
/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:instart’
/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:instart’
/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:instart’
rack (1.2.2) lib/rack/handler/webrick.rb:13:in run' rack (1.2.2) lib/rack/server.rb:213:instart’
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:intap’
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: “[email protected]

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”=>“[email protected]”},
“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:[email protected]/home/saideep/.rvm/gems/[email protected]/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=“[email protected]”,
@_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”=>“[email protected]”},
“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”=>“[email protected]”},
“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”=>“[email protected]”},
“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:[email protected]/home/saideep/.rvm/gems/[email protected]/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=“[email protected]”,
@_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”=>“[email protected]”}
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:

[email protected]:~/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: [email protected]
--------------------------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/[email protected]/gems/actionpack-3.0.0/lib/action_dispatch/middleware/templates/rescues/_trace.erb
(3.0ms)
Rendered
/home/saideep/.rvm/gems/[email protected]/gems/actionpack-3.0.0/lib/action_dispatch/middleware/templates/rescues/_request_and_response.erb
(19.0ms)
Rendered
/home/saideep/.rvm/gems/[email protected]/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

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs