# Relational inputs of logstash in jdbc plugin

**URL:** https://discuss.elastic.co/t/relational-inputs-of-logstash-in-jdbc-plugin/169724
**Category:** Logstash
**Created:** [February 24, 2019, 1:26pm UTC](https://discuss.elastic.co/t/relational-inputs-of-logstash-in-jdbc-plugin/169724 "2019-02-24T13:26:47Z")
**Posts on this page:** 1
**Showing post:** 7

<div class="post-metadata">

### Author: ![sahere37](https://avatars.discourse-cdn.com/v4/letter/s/b2d939/32.png) [@sahere37](https://discuss.elastic.co/u/sahere37)
#### Post date: [February 24, 2019, 3:40pm UTC](https://discuss.elastic.co/t/relational-inputs-of-logstash-in-jdbc-plugin/169724/7 "2019-02-24T15:40:55Z")

</div>

thanks for your reply. actually, i asked before, and waiting for inspiring advice

> [@Logstash jdbc plugin sql\_last\_value](https://discuss.elastic.co/t/logstash-jdbc-plugin-sql-last-value/169704):
>
> hi all, I am using logstash jdbc plugin as following: input { jdbc { jdbc\_driver\_library =\> "F:\driver\sqljdbc\_6.0\enu\jre8\sqljdbc42.jar" jdbc\_driver\_class =\> "com.microsoft.sqlserver.jdbc.SQLServerDriver" jdbc\_connection\_string =\> "jdbc:sqlserver://localhost:3333;databaseName=TotalTXN" jdbc\_user =\> "sss" jdbc\_password =\> "sss" schedule =\> "\* \*/1 \* \* \*" clean\_run =\> "true" statement =\> "SELECT date FROM dbo.TotalTxn\_Control" use\_column\_value =\> "true" tracking\_…

---

_[View the full topic](https://discuss.elastic.co/t/relational-inputs-of-logstash-in-jdbc-plugin/169724)._