# Jar file version for logstash jdbc input

**URL:** <https://discuss.elastic.co/t/jar-file-version-for-logstash-jdbc-input/281353>\
**Category:** Logstash\
**Created:** [August 13, 2021, 12:29pm UTC](https://discuss.elastic.co/t/jar-file-version-for-logstash-jdbc-input/281353 "2021-08-13T12:29:52Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![6igwig](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/6igwig/32/88971_2.png) [@6igwig](https://discuss.elastic.co/u/6igwig)\
**Post date:** [August 13, 2021, 12:29pm UTC](https://discuss.elastic.co/t/jar-file-version-for-logstash-jdbc-input/281353/1 "2021-08-13T12:29:52Z")

</div>

I am trying to pull in data from a MS SQL Server database via logstash that is hosted on a linux server.

It looks like this is a great job for the JDBC input plugin. I am going through the [example config](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html#_usage) posted on the documentation page and here is my question: how do I know which jar file (jre version) to use? I downloaded the [Microsoft JDBC Driver for SQL Server](https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15) from microsoft's website which comes with three versions of the jar files: mssql-jdbc-9.4.0. **jre8**.jar, ..jre11.., and ..jre16..

Does this depend on the version of java runtime environment I have? I don't even know if I have java runtime environment installed on this server... I've tried to find it several different ways to no avail.

Could I just put all three jar files in the /usr/share/logstash/logstash-core/lib/jars directory and leave the `jdbc_driver_library` parameter blank?

I'm lost, any help would be appreciated!

---

<div class="post-metadata">

**Author:** ![chandu5565](https://avatars.discourse-cdn.com/v4/letter/c/c57346/32.png) [@chandu5565](https://discuss.elastic.co/u/chandu5565)\
**Post date:** [August 16, 2021, 5:20am UTC](https://discuss.elastic.co/t/jar-file-version-for-logstash-jdbc-input/281353/2 "2021-08-16T05:20:29Z")

</div>

Hi James,

You can use below link to download the JDBC driver library of MSSql and unzip jars to /usr/share/logstash/logstash-core/lib/jars and you can leave jdbc\_driver\_library as blank like jdbc\_driver\_library =\> ""

[Download MSSql JDBC Driver | Connect to MSSql (dbschema.com)](https://dbschema.com/jdbc-driver/SqlServer.html)

---

<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:** [September 13, 2021, 5:21am UTC](https://discuss.elastic.co/t/jar-file-version-for-logstash-jdbc-input/281353/3 "2021-09-13T05:21:20Z")

</div>

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