# Jdbc, for getting mssql to Logstash not working :-(

**URL:** <https://discuss.elastic.co/t/jdbc-for-getting-mssql-to-logstash-not-working/247627>\
**Category:** Logstash\
**Created:** [September 5, 2020, 10:43am UTC](https://discuss.elastic.co/t/jdbc-for-getting-mssql-to-logstash-not-working/247627 "2020-09-05T10:43:52Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Farid\_N](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/farid_n/32/74144_2.png) [@Farid\_N](https://discuss.elastic.co/u/Farid_N)\
**Post date:** [September 5, 2020, 10:43am UTC](https://discuss.elastic.co/t/jdbc-for-getting-mssql-to-logstash-not-working/247627/1 "2020-09-05T10:43:52Z")

</div>

![Error](https://us1.discourse-cdn.com/elastic/original/3X/3/3/337fce9c3ddb01bedfd3c16f8b527c490452ae7d.jpeg)

Hello  
Unfortunately, I can not able to input mssql data base to logstash...  
This is my configuration file:

input {  
jdbc {  
jdbc\_driver\_library =\> "/usr/share/logstash/jdbc\_driver/sqljdbc\_8.4/enu/mssql-jdbc-8.4.1.jre14.jar"  
jdbc\_driver\_class =\> "com.microsoft.sqlserver.jdbc.SQLServerDriver"  
# mssql jdbc connection string to our database, mydb  
jdbc\_connection\_string =\> "jdbc:mssql://192.168.11.52:1433;databasename:Morakhasi"  
# The user we wish to execute our statement as  
jdbc\_user =\> "faridTest"  
jdbc\_password =\> "---"  
schedule =\> "\* \* \* \* \*"  
# our query to fetch blog details  
#statement =\> "SELECT \* from songs where artist = :favorite\_artist"  
}  
}  
output {  
stdout { codec =\> rubydebug }  
elasticsearch {  
hosts =\> "localhost:9200"  
index =\> "mssql"  
document\_type =\> "blogs"  
}  
}

PLEASE PLEASE, Somebody help me... (see the attachment photo)

---

<div class="post-metadata">

**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\
**Post date:** [September 5, 2020, 11:33am UTC](https://discuss.elastic.co/t/jdbc-for-getting-mssql-to-logstash-not-working/247627/2 "2020-09-05T11:33:17Z")

</div>

```auto
#statement => "SELECT * from songs where artist = :favorite_artist"

```

The statement is commented out for one. Do you get data if you uncomment it? Try to execute something simple also to test.

```auto
statement => "SELECT TOP 1 * from songs"

```

---

<div class="post-metadata">

**Author:** ![Farid\_N](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/farid_n/32/74144_2.png) [@Farid\_N](https://discuss.elastic.co/u/Farid_N)\
**Post date:** [September 5, 2020, 11:41am UTC](https://discuss.elastic.co/t/jdbc-for-getting-mssql-to-logstash-not-working/247627/3 "2020-09-05T11:41:51Z")

</div>

Thank you so much bro for replying...  
It is work now, probably... but it seems have issue with the jdbc driver (see the attachment please

 ![Error 2](https://us1.discourse-cdn.com/elastic/original/3X/9/1/912c44969c5c0680be7f0a7aa8c59a142b058c0a.jpeg) )

---

<div class="post-metadata">

**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\
**Post date:** [September 5, 2020, 12:01pm UTC](https://discuss.elastic.co/t/jdbc-for-getting-mssql-to-logstash-not-working/247627/4 "2020-09-05T12:01:49Z")

</div>

It could be dealing with this [current issue](https://github.com/elastic/logstash/issues/10983#issuecomment-565701094). I would try that next.

---

<div class="post-metadata">

**Author:** ![Farid\_N](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/farid_n/32/74144_2.png) [@Farid\_N](https://discuss.elastic.co/u/Farid_N)\
**Post date:** [September 5, 2020, 12:45pm UTC](https://discuss.elastic.co/t/jdbc-for-getting-mssql-to-logstash-not-working/247627/5 "2020-09-05T12:45:07Z")

</div>

Thank you so much...

---

<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 3, 2020, 12:45pm UTC](https://discuss.elastic.co/t/jdbc-for-getting-mssql-to-logstash-not-working/247627/6 "2020-10-03T12:45:12Z")

</div>

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