# Input plugin JDBC error

**URL:** <https://discuss.elastic.co/t/input-plugin-jdbc-error/43958>\
**Category:** Logstash\
**Created:** [March 9, 2016, 10:57pm UTC](https://discuss.elastic.co/t/input-plugin-jdbc-error/43958 "2016-03-09T22:57:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![tarik\_setia](https://avatars.discourse-cdn.com/v4/letter/t/d07c76/32.png) [@tarik\_setia](https://discuss.elastic.co/u/tarik_setia)\
**Post date:** [March 9, 2016, 10:57pm UTC](https://discuss.elastic.co/t/input-plugin-jdbc-error/43958/1 "2016-03-09T22:57:04Z")

</div>

I trying to log SQL server data using logstash but getting following error:

`PS D:\elk\logstash\bin> .\logstash -f simple.conf io/console not supported; tty will not be manipulated Settings: Default pipeline workers: 4 LoadError: no such file to load -- D:/ELK/sqljdbc4 require at org/jruby/RubyKernel.java:1040 require at D:/ELK/logstash/vendor/bundle/jruby/1.9/gems/polyglot-0.3.5/lib/polyglot.rb:65 load_drivers at D:/ELK/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.0.0/lib/logstash/plugin_mixins/jd bc.rb:115 each at org/jruby/RubyArray.java:1613 load_drivers at D:/ELK/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.0.0/lib/logstash/plugin_mixins/jd bc.rb:113 prepare_jdbc_connection at D:/ELK/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.0.0/lib/logstash/plugin_mixins/jd bc.rb:127 register at D:/ELK/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.0.0/lib/logstash/inputs/jdbc.rb:1 54 start_inputs at D:/ELK/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.2.2-java/lib/logstash/pipeline.rb:319 each at org/jruby/RubyArray.java:1613 start_inputs at D:/ELK/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.2.2-java/lib/logstash/pipeline.rb:318 start_workers at D:/ELK/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.2.2-java/lib/logstash/pipeline.rb:169 run at D:/ELK/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.2.2-java/lib/logstash/pipeline.rb:123 execute at D:/ELK/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.2.2-java/lib/logstash/agent.rb:211 run at D:/ELK/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.2.2-java/lib/logstash/runner.rb:90 call at org/jruby/RubyProc.java:281 run at D:/ELK/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.2.2-java/lib/logstash/runner.rb:95 call at org/jruby/RubyProc.java:281 initialize at D:/ELK/logstash/vendor/bundle/jruby/1.9/gems/stud-0.0.22/lib/stud/task.rb:24`

My config file is

# file: simple-out.conf

input {  
jdbc {  
# Postgres jdbc connection string to our database, mydb  
jdbc\_connection\_string =\> "jdbc:sqlserver://155.17.41.140:1433;"  
# The user we wish to execute our statement as  
jdbc\_user =\> "xxxxx"  
jdbc\_password =\> "xxxx"  
# The path to our downloaded jdbc driver  
jdbc\_driver\_library =\> "D:\ELK\sqljdbc4.jar"  
# The name of the driver class for Postgresql  
jdbc\_driver\_class =\> "com.microsoft.sqlserver.jdbc.SQLServerDriver"  
# our query  
statement =\> "SELECT \* from vEvents"  
}  
}  
output {  
stdout { codec =\> json\_lines }  
}

Please Help.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 5:07am UTC](https://discuss.elastic.co/t/input-plugin-jdbc-error/43958/2 "2017-07-06T05:07:41Z")

</div>