{"action":"created","issue":{"url":"https://api.github.com/repos/rsim/oracle-enhanced/issues/1030","repository_url":"https://api.github.com/repos/rsim/oracle-enhanced","labels_url":"https://api.github.com/repos/rsim/oracle-enhanced/issues/1030/labels{/name}","comments_url":"https://api.github.com/repos/rsim/oracle-enhanced/issues/1030/comments","events_url":"https://api.github.com/repos/rsim/oracle-enhanced/issues/1030/events","html_url":"https://github.com/rsim/oracle-enhanced/issues/1030","id":185882599,"number":1030,"title":"Problem with will_paginate","user":{"login":"pandar1","id":622817,"avatar_url":"https://avatars.githubusercontent.com/u/622817?v=3","gravatar_id":"","url":"https://api.github.com/users/pandar1","html_url":"https://github.com/pandar1","followers_url":"https://api.github.com/users/pandar1/followers","following_url":"https://api.github.com/users/pandar1/following{/other_user}","gists_url":"https://api.github.com/users/pandar1/gists{/gist_id}","starred_url":"https://api.github.com/users/pandar1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pandar1/subscriptions","organizations_url":"https://api.github.com/users/pandar1/orgs","repos_url":"https://api.github.com/users/pandar1/repos","events_url":"https://api.github.com/users/pandar1/events{/privacy}","received_events_url":"https://api.github.com/users/pandar1/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2016-10-28T09:49:17Z","updated_at":"2016-11-02T16:52:24Z","closed_at":null,"body":"I have this problem when using the gem will paginate, using jrails 9.1.5.0, rails 5.0.0.1 under windows.\n\nI'm not 100% sure if this is a problem of will paginate or oracle enhanced, but I suspect it's a bug in oracle enhanced dealing with limits to the number of returned rows.\n\nThis work:\n@vendors = Vendor.all\n\nThis don't work\n@vendors = Vendor.all.paginate :per_page => 20 , :page => params[:page]\n\ngiving the following error message:\n\nJava::JavaSql::SQLException: Missing IN or OUT parameter at index:: 3: \n              SELECT \\* FROM (\n                SELECT raw_sql_._, rownum raw_rnum_\n                FROM (SELECT  \"VENDORS\"._ FROM \"VENDORS\" ORDER BY \"VENDORS\".\"ID\" ASC ) raw_sql_ WHERE rownum <= (:a1 + :a2) ) WHERE raw_rnum_ > :a1\n\nThe query in itself it's correct, eg:\n\nSELECT \\* FROM (\n                SELECT raw_sql_._, rownum raw_rnum_\n                FROM (SELECT  \"VENDORS\"._ FROM \"VENDORS\" ORDER BY \"VENDORS\".\"ID\" ASC ) raw_sql_ WHERE rownum <= (100) ) WHERE raw_rnum_ > 0\n\nin toad just works... any ideas?\n"},"comment":{"url":"https://api.github.com/repos/rsim/oracle-enhanced/issues/comments/257926241","html_url":"https://github.com/rsim/oracle-enhanced/issues/1030#issuecomment-257926241","issue_url":"https://api.github.com/repos/rsim/oracle-enhanced/issues/1030","id":257926241,"user":{"login":"yahonda","id":73684,"avatar_url":"https://avatars.githubusercontent.com/u/73684?v=3","gravatar_id":"","url":"https://api.github.com/users/yahonda","html_url":"https://github.com/yahonda","followers_url":"https://api.github.com/users/yahonda/followers","following_url":"https://api.github.com/users/yahonda/following{/other_user}","gists_url":"https://api.github.com/users/yahonda/gists{/gist_id}","starred_url":"https://api.github.com/users/yahonda/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yahonda/subscriptions","organizations_url":"https://api.github.com/users/yahonda/orgs","repos_url":"https://api.github.com/users/yahonda/repos","events_url":"https://api.github.com/users/yahonda/events{/privacy}","received_events_url":"https://api.github.com/users/yahonda/received_events","type":"User","site_admin":false},"created_at":"2016-11-02T16:52:24Z","updated_at":"2016-11-02T16:52:24Z","body":"Thanks guys. \r\n\r\n@pandar1 \r\nWould you update the Gemfile and see if it still reproduces or not.\r\n\r\n```ruby\r\ngem 'activerecord-oracle_enhanced-adapter', github: 'yahonda/oracle-enhanced', branch: 'diag_1030'\r\n```\r\n\r\n@roooodcastro Thanks for the reply. since this query binds ` :a1` twice then \r\nI guess that bind variables are referenced by their order in Oracle enhanced adapter JDBC implementation otherwise referenced by name in Oracle enhanced adapter OCI implementation.\r\n\r\nOnce this fix is confirmed I'm going to open a pull request to master branch.\r\n\r\nThanks.\r\n\r\n"}}
{"actor":{"display_login":"yahonda"}}