# Microsoft sqlserver and logstash

**URL:** <https://discuss.elastic.co/t/microsoft-sqlserver-and-logstash/199864>\
**Category:** Logstash\
**Created:** [September 17, 2019, 5:23pm UTC](https://discuss.elastic.co/t/microsoft-sqlserver-and-logstash/199864 "2019-09-17T17:23:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\
**Post date:** [September 17, 2019, 5:23pm UTC](https://discuss.elastic.co/t/microsoft-sqlserver-and-logstash/199864/1 "2019-09-17T17:23:56Z")

</div>

I have try following config and it works with  
java 8 and sqljdbc4.2

jdbc\_driver\_class =\> "com.microsoft.sqlserver.jdbc.SQLServerDriver"  
jdbc\_driver\_library =\> "/root/sqljdbc\_4.2/enu/jre8/sqljdbc42.jar"

what I want to do is use jdk12 and sqljdbc7.4

Microsoft JDBC Driver 7.4 for SQL Server  
downloaded  
make sure java is 12

#\> java -version  
openjdk version "12.0.2" 2019-07-16  
OpenJDK Runtime Environment (build 12.0.2+10)  
OpenJDK 64-Bit Server VM (build 12.0.2+10, mixed mode, sharing)

but it fails saying  
Error: com.mysql.jdbc.Driver not loaded. :jdbc\_driver\_library is not set, are you sure you included  
the proper driver client libraries in your classpath?

if I use  
jdbc\_driver\_class =\> "com.microsoft.sqlserver.jdbc.SQLServerDriver"  
it still says

Error: com.microsoft.sqlserver.jdbc.SQLServerDriver not loaded. :jdbc\_driver\_library is not set, are you sure you included  
the proper driver client libraries in your classpath?

it seems like only classpath problem?

anyone has test this?

---

<div class="post-metadata">

**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\
**Post date:** [September 17, 2019, 5:58pm UTC](https://discuss.elastic.co/t/microsoft-sqlserver-and-logstash/199864/2 "2019-09-17T17:58:15Z")

</div>

oh well fixed it. Looks like I have to use mysql-jdbc-7.4.1.jre8.jar with openjdk12 and it works.

it does not work if I use mysql-jdbc-7.4.1.jre12.jar

basically I had two copy in  
/usr/share/logstash/logstash-core/lib/jars/sqljdbc42.jar  
/usr/share/logstash/logstash-core/lib/jars/mssql-jdbc-7.4.1.jre8.jar

remove old one

now I have following. if anyone has such problem they can check.

ls -la /usr/share/logstash/logstash-core/lib/jars/mssql-jdbc-7.4.1.jre8.jar  
-rw-r--r-- 1 root root 1209659 Sep 17 12:21 /usr/share/logstash/logstash-core/lib/jars/mssql-jdbc-7.4.1.jre8.jar

java -version  
openjdk version "12.0.2" 2019-07-16  
OpenJDK Runtime Environment (build 12.0.2+10)  
OpenJDK 64-Bit Server VM (build 12.0.2+10, mixed mode, sharing)

using openjdk12 provided by elasticsearch  
ls -la /etc/alternatives/java  
lrwxrwxrwx 1 root root 37 Sep 17 12:27 /etc/alternatives/java -\> /usr/share/elasticsearch/jdk/bin/java

And finally config file  
input {  
jdbc {  
jdbc\_validate\_connection =\> false  
jdbc\_driver\_class =\> "com.microsoft.sqlserver.jdbc.SQLServerDriver"  
jdbc\_connection\_string =\> "jdbc:sqlserver://server\_name;databaseName=db1;user=myuser;password=password;"  
jdbc\_user =\> "myser"  
jdbc\_password =\> "password"  
statement =\> "select \* from db1"  
clean\_run=\>true  
}  
}

---

<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 15, 2019, 5:58pm UTC](https://discuss.elastic.co/t/microsoft-sqlserver-and-logstash/199864/3 "2019-10-15T17:58:16Z")

</div>

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