# SQL Server data to Elasticsearch using LogStash

**URL:** <https://discuss.elastic.co/t/sql-server-data-to-elasticsearch-using-logstash/283879>\
**Category:** Logstash\
**Created:** [September 10, 2021, 12:55pm UTC](https://discuss.elastic.co/t/sql-server-data-to-elasticsearch-using-logstash/283879 "2021-09-10T12:55:42Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Navlesh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/navlesh/32/81992_2.png) [@Navlesh](https://discuss.elastic.co/u/Navlesh)\
**Post date:** [September 10, 2021, 12:55pm UTC](https://discuss.elastic.co/t/sql-server-data-to-elasticsearch-using-logstash/283879/1 "2021-09-10T12:55:42Z")

</div>

Hi

input {  
jdbc {  
# SqlServer jdbc connection string to your database, productdb  
# "jdbc:sqlserver://HostName\instanceName;database=DBName;user=UserName;password=Password"  
jdbc\_connection\_string =\> "jdbc:sqlserver://XXXX;database=XXXX;user=XXXX;password=XXXXX;"  
# The user you want to execute your statement as  
jdbc\_user =\> nil  
# The path to your downloaded jdbc driver  
jdbc\_driver\_library =\> "C:/Program Files/Microsoft JDBC Driver 4.0 for SQL Server/sqljdbc\_4.2/enu/jre8/sqljdbc42.jar"  
# The name of the driver class for SqlServer  
jdbc\_driver\_class =\> "com.microsoft.sqlserver.jdbc.SQLServerDriver"  
# Query for testing purpose  
statement =\> "SELECT \* from Country"  
}  
}  
output {  
elasticsearch {  
hosts =\> ["[https://elastic.XXXXXX:9200](https://elastic.XXXXXX:9200)"]  
user =\> "XXXXX"  
password =\> "XXXX"  
index =\> "cs\_country"  
}  
stdout { }  
}

Getting Error  
[2021-09-10T18:14:13,168][ERROR][logstash.javapipeline][main][1b260913fb906cb14d0e10b411e900e700cc941bab9ac01dcc7d8cd125033610] A plugin had an unrecoverable error. Will restart this plugin.

C:/Program Files/Elastic/logstash-7.13.2/vendor/bundle/jruby/2.5.0/gems/logstash-integration-jdbc-5.0.7/lib/logstash/plugin\_mixins/jdbc/common.rb:42:in `load_driver_jars' C:/Program Files/Elastic/logstash-7.13.2/vendor/bundle/jruby/2.5.0/gems/logstash-integration-jdbc-5.0.7/lib/logstash/plugin_mixins/jdbc/common.rb:25:in `load\_driver'  
C:/Program Files/Elastic/logstash-7.13.2/vendor/bundle/jruby/2.5.0/gems/logstash-integration-jdbc-5.0.7/lib/logstash/inputs/jdbc.rb:275:in `run' C:/Program Files/Elastic/logstash-7.13.2/logstash-core/lib/logstash/java_pipeline.rb:405:in `inputworker'  
C:/Program Files/Elastic/logstash-7.13.2/logstash-core/lib/logstash/java\_pipeline.rb:396:in `block in start\_input'

---

<div class="post-metadata">

**Author:** ![Andy0708](https://avatars.discourse-cdn.com/v4/letter/a/df705f/32.png) [@Andy0708](https://discuss.elastic.co/u/Andy0708)\
**Post date:** [September 13, 2021, 11:33am UTC](https://discuss.elastic.co/t/sql-server-data-to-elasticsearch-using-logstash/283879/2 "2021-09-13T11:33:03Z")

</div>

I would say that the problem is with loading your JDBC driver. Are you sure that the provided driver path is correct?

---

<div class="post-metadata">

**Author:** ![Navlesh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/navlesh/32/81992_2.png) [@Navlesh](https://discuss.elastic.co/u/Navlesh)\
**Post date:** [September 13, 2021, 11:40am UTC](https://discuss.elastic.co/t/sql-server-data-to-elasticsearch-using-logstash/283879/3 "2021-09-13T11:40:01Z")

</div>

@Andy0708  
The Driver path is correct.

Note the same code is working file before the basic security of ELK

---

<div class="post-metadata">

**Author:** ![Navlesh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/navlesh/32/81992_2.png) [@Navlesh](https://discuss.elastic.co/u/Navlesh)\
**Post date:** [September 16, 2021, 5:49am UTC](https://discuss.elastic.co/t/sql-server-data-to-elasticsearch-using-logstash/283879/4 "2021-09-16T05:49:40Z")

</div>

After pasting the fresh copy of JDK in logstash folder issue is fixed

---

<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:** [October 14, 2021, 5:50am UTC](https://discuss.elastic.co/t/sql-server-data-to-elasticsearch-using-logstash/283879/5 "2021-10-14T05:50:32Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.