{"action":"created","issue":{"url":"https://api.github.com/repos/jprante/elasticsearch-jdbc/issues/696","labels_url":"https://api.github.com/repos/jprante/elasticsearch-jdbc/issues/696/labels{/name}","comments_url":"https://api.github.com/repos/jprante/elasticsearch-jdbc/issues/696/comments","events_url":"https://api.github.com/repos/jprante/elasticsearch-jdbc/issues/696/events","html_url":"https://github.com/jprante/elasticsearch-jdbc/issues/696","id":117274259,"number":696,"title":"Column index out of range","user":{"login":"kioku","id":1134466,"avatar_url":"https://avatars.githubusercontent.com/u/1134466?v=3","gravatar_id":"","url":"https://api.github.com/users/kioku","html_url":"https://github.com/kioku","followers_url":"https://api.github.com/users/kioku/followers","following_url":"https://api.github.com/users/kioku/following{/other_user}","gists_url":"https://api.github.com/users/kioku/gists{/gist_id}","starred_url":"https://api.github.com/users/kioku/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kioku/subscriptions","organizations_url":"https://api.github.com/users/kioku/orgs","repos_url":"https://api.github.com/users/kioku/repos","events_url":"https://api.github.com/users/kioku/events{/privacy}","received_events_url":"https://api.github.com/users/kioku/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-11-17T03:21:34Z","updated_at":"2015-11-17T07:58:44Z","closed_at":null,"body":"Hello\r\n\r\nI'm seeing the attached exception when setting `prepare_resultset_metadata` to `true`.\r\nThe result is the same regardless of the settings, or the sql statement.\r\n\r\nThe version in use is 1.7.1, along with MySQL.\r\n\r\nI encountered this issue while trying to use the `$row` query parameter, which seems to only want to take the value of the last row of the current result set.\r\n\r\n```\r\n[02:12:46,012][ERROR][importer.jdbc.context.standard][pool-2-thread-1] java.sql.SQLException: Column index out of range.\r\njava.io.IOException: java.sql.SQLException: Column index out of range.\r\n        at org.xbib.elasticsearch.jdbc.strategy.standard.StandardSource.fetch(StandardSource.java:617) ~[elasticsearch-jdbc-1.7.1.0-uberjar.jar:?]\r\n        at org.xbib.elasticsearch.jdbc.strategy.standard.StandardContext.fetch(StandardContext.java:215) [elasticsearch-jdbc-1.7.1.0-uberjar.jar:?]\r\n        at org.xbib.elasticsearch.jdbc.strategy.standard.StandardContext.execute(StandardContext.java:190) [elasticsearch-jdbc-1.7.1.0-uberjar.jar:?]\r\n        at org.xbib.tools.JDBCImporter.process(JDBCImporter.java:118) [elasticsearch-jdbc-1.7.1.0-uberjar.jar:?]\r\n        at org.xbib.tools.Importer.newRequest(Importer.java:241) [elasticsearch-jdbc-1.7.1.0-uberjar.jar:?]\r\n        at org.xbib.tools.Importer.newRequest(Importer.java:57) [elasticsearch-jdbc-1.7.1.0-uberjar.jar:?]\r\n        at org.xbib.pipeline.AbstractPipeline.call(AbstractPipeline.java:86) [elasticsearch-jdbc-1.7.1.0-uberjar.jar:?]\r\n        at org.xbib.pipeline.AbstractPipeline.call(AbstractPipeline.java:17) [elasticsearch-jdbc-1.7.1.0-uberjar.jar:?]\r\n        at java.util.concurrent.FutureTask.run(FutureTask.java:262) [?:1.7.0_80]\r\n        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [?:1.7.0_80]\r\n        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [?:1.7.0_80]\r\n        at java.lang.Thread.run(Thread.java:745) [?:1.7.0_80]\r\nCaused by: java.sql.SQLException: Column index out of range.\r\n        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) ~[mysql-connector-java-5.1.33.jar:5.1.33]\r\n        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935) ~[mysql-connector-java-5.1.33.jar:5.1.33]\r\n        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924) ~[mysql-connector-java-5.1.33.jar:5.1.33]\r\n        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870) ~[mysql-connector-java-5.1.33.jar:5.1.33]\r\n        at com.mysql.jdbc.ResultSetMetaData.getField(ResultSetMetaData.java:392) ~[mysql-connector-java-5.1.33.jar:5.1.33]\r\n        at com.mysql.jdbc.ResultSetMetaData.getCatalogName(ResultSetMetaData.java:98) ~[mysql-connector-java-5.1.33.jar:5.1.33]\r\n        at org.xbib.elasticsearch.jdbc.strategy.standard.StandardSource.prepare(StandardSource.java:1232) ~[elasticsearch-jdbc-1.7.1.0-uberjar.jar:?]\r\n        at org.xbib.elasticsearch.jdbc.strategy.standard.StandardSource.execute(StandardSource.java:668) ~[elasticsearch-jdbc-1.7.1.0-uberjar.jar:?]\r\n        at org.xbib.elasticsearch.jdbc.strategy.standard.StandardSource.fetch(StandardSource.java:583) ~[elasticsearch-jdbc-1.7.1.0-uberjar.jar:?]\r\n        ... 11 more\r\n```\r\n\r\nThanks!\r\n"},"comment":{"url":"https://api.github.com/repos/jprante/elasticsearch-jdbc/issues/comments/157303020","html_url":"https://github.com/jprante/elasticsearch-jdbc/issues/696#issuecomment-157303020","issue_url":"https://api.github.com/repos/jprante/elasticsearch-jdbc/issues/696","id":157303020,"user":{"login":"jprante","id":635745,"avatar_url":"https://avatars.githubusercontent.com/u/635745?v=3","gravatar_id":"","url":"https://api.github.com/users/jprante","html_url":"https://github.com/jprante","followers_url":"https://api.github.com/users/jprante/followers","following_url":"https://api.github.com/users/jprante/following{/other_user}","gists_url":"https://api.github.com/users/jprante/gists{/gist_id}","starred_url":"https://api.github.com/users/jprante/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jprante/subscriptions","organizations_url":"https://api.github.com/users/jprante/orgs","repos_url":"https://api.github.com/users/jprante/repos","events_url":"https://api.github.com/users/jprante/events{/privacy}","received_events_url":"https://api.github.com/users/jprante/received_events","type":"User","site_admin":false},"created_at":"2015-11-17T07:58:44Z","updated_at":"2015-11-17T07:58:44Z","body":"Yes, `$row` does not work across result sets.\r\n\r\nCan you show the JSON specification for reproduction? Thanks."}}