# Logstash error to configure java 11 - sql server

**URL:** <https://discuss.elastic.co/t/logstash-error-to-configure-java-11-sql-server/196831>\
**Category:** Logstash\
**Created:** [August 26, 2019, 7:47pm UTC](https://discuss.elastic.co/t/logstash-error-to-configure-java-11-sql-server/196831 "2019-08-26T19:47:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![crisao](https://avatars.discourse-cdn.com/v4/letter/c/73ab20/32.png) [@crisao](https://discuss.elastic.co/u/crisao)\
**Post date:** [August 26, 2019, 7:47pm UTC](https://discuss.elastic.co/t/logstash-error-to-configure-java-11-sql-server/196831/1 "2019-08-26T19:47:21Z")

</div>

Error logstash to configure java 11 to make sql server data etl

{"logstash.version"=\>"7.3.1"}

input {  
jdbc {  
jdbc\_driver\_library =\> "/etc/logstash/sql/sqljdbc\_7.4/enu/mssql-jdbc-7.4.1.jre11.jar"   
jdbc\_driver\_class =\> "com.microsoft.sqlserver.jdbc.SQLServerDriver"  
jdbc\_connection\_string =\> "jdbc:sqlserver://srvbancoTESTE,1433;databaseName=DB\_Teste"  
jdbc\_user =\> "elasticSearch"  
jdbc\_password =\> "\*\*\*\*\*\*"  
tracking\_column = IdArtigo  
use\_column\_value = true  
statement =\> "select top 100 \* from dbo.textos where IdArtigo \> :sql\_last\_value"  
}  
}

## Add your filters / logstash plugins configuration here.

output {  
elasticsearch {  
hosts =\> "elasticsearch:9200"  
index =\> "jornal"  
document\_type =\> "artigo"  
document\_id =\> "%{IdArtigo}"

```
    }

```

}

---

<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 23, 2019, 7:55pm UTC](https://discuss.elastic.co/t/logstash-error-to-configure-java-11-sql-server/196831/2 "2019-09-23T19:55:22Z")

</div>

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