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

Question

Hi Guys,

I am using Logstash to move data from my Microsoft SQL Server database to ElasticSearch. But I am getting the below error. 

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?

Answer 1

Hi@akhtar,

This has been an issue with the logstash-filter-jdbc_static driver. You need to move your .jar to /logstash-core/lib/jars/ directory. These jars get added to the correct JDK classpath as Logstash is started via java.