# Logstash error: Java::JavaLang::NoClassDefFoundError: javax/xml/bind/DatatypeConverter

**URL:** <https://discuss.elastic.co/t/logstash-error-java-javax-xml-bind-datatypeconverter/258920>\
**Category:** Logstash\
**Created:** [December 16, 2020, 10:24pm UTC](https://discuss.elastic.co/t/logstash-error-java-javax-xml-bind-datatypeconverter/258920 "2020-12-16T22:24:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![streible](https://avatars.discourse-cdn.com/v4/letter/s/13edae/32.png) [@streible](https://discuss.elastic.co/u/streible)\
**Post date:** [December 16, 2020, 10:24pm UTC](https://discuss.elastic.co/t/logstash-error-java-javax-xml-bind-datatypeconverter/258920/1 "2020-12-16T22:24:50Z")

</div>

Hi everyone,

I'm hoping someone can lend a hand or give some guidance. I have recently installed Elasticsearch on Ubuntu 20.04 and have most everything up and running. I am working with SQL Server 2019 on a remote machine and can query the databases just fine using the mssql-tools, no problem.

At the present, I have been challenged with logstash connecting to SQL Server and have gone as far as setting the JAVA\_HOME and PATH environment variables to no avail and have also copied the jar file sqljdbc32.jar to /usr/share/logstash/logstash-core/lib/jars. I am using Open JDK 8. Installation went fine and all other services work great, but this one continues to be problematic. The tutorial I have followed to get SQL data into Logstash is:

> **[How To Transfer Data From MSSQL To Elasticsearch Using Logstash - Database...](https://dbtut.com/index.php/2019/06/02/how-to-transfer-data-from-mssql-to-elasticsearch-using-logstash/)**
>
> How To Transfer Data From MSSQL To Elasticsearch Using Logstash

The configuration file for connection is very similar to the file that is illustrated in the tutorial:

See this section of the tutorial: -\> Content of mssql\_dataset.conf

I'm even using the Adventureworks2014 database. The only things that are different are the username, password, and IP address. As indicated before, mssql-tools can query that DB from Linux with no problem, so it's not a connectivity issue that is firewall or protocol related from an OS perspective.

Any guidance would be appreciated.

Thanks for any and all responses,

Steve

---

<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:** [January 13, 2021, 10:25pm UTC](https://discuss.elastic.co/t/logstash-error-java-javax-xml-bind-datatypeconverter/258920/2 "2021-01-13T22:25:05Z")

</div>

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