# Logstash JDBC Input table data not in sync with Kibana Index

**URL:** https://discuss.elastic.co/t/logstash-jdbc-input-table-data-not-in-sync-with-kibana-index/153395
**Category:** Logstash
**Created:** [October 22, 2018, 12:05pm UTC](https://discuss.elastic.co/t/logstash-jdbc-input-table-data-not-in-sync-with-kibana-index/153395 "2018-10-22T12:05:57Z")
**Posts on this page:** 1
**Showing post:** 9

<div class="post-metadata">

### Author: ![balumurari1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/balumurari1/32/39203_2.png) [@balumurari1](https://discuss.elastic.co/u/balumurari1)
#### Post date: [October 25, 2018, 7:48am UTC](https://discuss.elastic.co/t/logstash-jdbc-input-table-data-not-in-sync-with-kibana-index/153395/9 "2018-10-25T07:48:12Z")

</div>

If you were using Oracle DB to load the data to ES, check below code,

> [@Logstash doesn't apply my ES Template when I upload data](https://discuss.elastic.co/t/logstash-doesnt-apply-my-es-template-when-i-upload-data/153813/6):
>
> The input code is fine, in the output did you mention elasticsearch to get the result, Try this, input { jdbc { jdbc\_driver\_library =\> "xxxx\oracle-10g\ojdbc14.jar" jdbc\_driver\_class =\> "oracle.jdbc.driver.OracleDriver" jdbc\_connection\_string =\> "jdbc:oracle:thin:@localhost:1521:DATABASE" jdbc\_user =\> "ROMAINROM" jdbc\_password =\> "ROMAINROM" statement =\> "SELECT TOP 10 \* FROM TABLE" jdbc\_paging\_enabled =\> "true" jdbc\_page\_size =\> "50000" } } output{ elasticsearch { codec =\> json h…

To load the changes occurring in the databse use schedule =\> "\*/2 \* \* \* \*",  
schedule for every 2 min

---

_[View the full topic](https://discuss.elastic.co/t/logstash-jdbc-input-table-data-not-in-sync-with-kibana-index/153395)._