{"action":"created","issue":{"url":"https://api.github.com/repos/logstash-plugins/logstash-input-jdbc/issues/6","labels_url":"https://api.github.com/repos/logstash-plugins/logstash-input-jdbc/issues/6/labels{/name}","comments_url":"https://api.github.com/repos/logstash-plugins/logstash-input-jdbc/issues/6/comments","events_url":"https://api.github.com/repos/logstash-plugins/logstash-input-jdbc/issues/6/events","html_url":"https://github.com/logstash-plugins/logstash-input-jdbc/issues/6","id":84685414,"number":6,"title":"No results No errors","user":{"login":"kyunam","id":1238609,"avatar_url":"https://avatars.githubusercontent.com/u/1238609?v=3","gravatar_id":"","url":"https://api.github.com/users/kyunam","html_url":"https://github.com/kyunam","followers_url":"https://api.github.com/users/kyunam/followers","following_url":"https://api.github.com/users/kyunam/following{/other_user}","gists_url":"https://api.github.com/users/kyunam/gists{/gist_id}","starred_url":"https://api.github.com/users/kyunam/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kyunam/subscriptions","organizations_url":"https://api.github.com/users/kyunam/orgs","repos_url":"https://api.github.com/users/kyunam/repos","events_url":"https://api.github.com/users/kyunam/events{/privacy}","received_events_url":"https://api.github.com/users/kyunam/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-06-03T17:44:17Z","updated_at":"2015-07-07T00:47:14Z","closed_at":null,"body":"I only see \"Logstash startup completed\" then nothing happens whether I use sql_last_start or not.\r\nI use Logstash 1.5.0 and the configuration is,\r\ninput {\r\njdbc {\r\njdbc_driver_library => '/Users/someWhere/sqljdbc4.jar'\r\njdbc_driver_class => 'com.microsoft.sqlserver.jdbc.SQLServerDriver'\r\njdbc_connection_string => 'jdbc:sqlserver://myServer:1433;databaseName=myDB'\r\njdbc_user => 'aUser'\r\njdbc_password => 'aPassword'\r\nstatement => 'SELECT * FROM LOGSTASH_POINT where CREATED_DATE > :sql_last_start'\r\n#parameters => { \"sql_last_start\" => \"2014-01-01\" }\r\njdbc_validate_connection => true\r\nschedule => \"* * * * *\"\r\n}\r\n}\r\noutput {\r\nstdout { codec => rubydebug }\r\n}\r\n\r\nAny help is appreciated."},"comment":{"url":"https://api.github.com/repos/logstash-plugins/logstash-input-jdbc/issues/comments/119036381","html_url":"https://github.com/logstash-plugins/logstash-input-jdbc/issues/6#issuecomment-119036381","issue_url":"https://api.github.com/repos/logstash-plugins/logstash-input-jdbc/issues/6","id":119036381,"user":{"login":"talevy","id":388837,"avatar_url":"https://avatars.githubusercontent.com/u/388837?v=3","gravatar_id":"","url":"https://api.github.com/users/talevy","html_url":"https://github.com/talevy","followers_url":"https://api.github.com/users/talevy/followers","following_url":"https://api.github.com/users/talevy/following{/other_user}","gists_url":"https://api.github.com/users/talevy/gists{/gist_id}","starred_url":"https://api.github.com/users/talevy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/talevy/subscriptions","organizations_url":"https://api.github.com/users/talevy/orgs","repos_url":"https://api.github.com/users/talevy/repos","events_url":"https://api.github.com/users/talevy/events{/privacy}","received_events_url":"https://api.github.com/users/talevy/received_events","type":"User","site_admin":false},"created_at":"2015-07-07T00:47:14Z","updated_at":"2015-07-07T00:47:14Z","body":"I will add some debug statements to further inform on the progress. but it may very well be that no results were returned from the statement."}}